Record Macro does not record inserting sheets done via Sheet-Insert Sheet.. where a number of new sheets can be added.
Note1: Sheet-Insert Sheet at End.. is recorded.
Note2: Record Macro doesn't record mouse actions like sheet selection. That's confusing as seen in https://ask.libreoffice.org/t/why-dont-recorded-macros-include-the-parameters-and-is-there-any-way-round-this/21470/6. Sheets can be selected via keyboard.
Note3: Record Macro works with dispatch and doesn't really create proper code, so it should be rewritten completely. Workaround could be using MRI extension.
(In reply to Timur from comment #0)
> Note3: Record Macro works with dispatch and doesn't really create proper
> code, so it should be rewritten completely. Workaround could be using MRI
So may be just disable it at all? =) Btw, today it has an experimental status
Half-working recorder is better than none. I wrote notes who may not be familiar with details about macro recorder. So no point in comment 1,please test .
If I Go to Sheet - Insert Sheet - Ok, then the macro is recorded.
dim args2(1) as new com.sun.star.beans.PropertyValue
args2(0).Name = "Name"
args2(0).Value = "Sheet10"
args2(1).Name = "Index"
args2(1).Value = 1
dispatcher.executeDispatch(document, ".uno:Insert", "", 0, args2())
However, if I change the number of sheets to something different than 1, nothing is recorded
Thanks. I tried only with increased number.
As for Duplicate Sheet, it records but sets REM so it doesn't work if not edited. Could be a separate bug but let's keep here for a while.
BTW, I cannot find how to insert multiple sheets with API Basic code. I just see insertNewByName which inserts a single sheet. I guess loop should be used.