I have extensive Excel VBA macros and I’ve just started looking at Libre and it seems that Libre’s macros require very much more code to do very simple things - so much so there there would be a LOT more typing and the resultant code would be very much harder to read.
I have tried a converter that tells me that Range("A1")=1
becomes:
Dim oSheet as Object[n]oSheet = ThisComponent.CurrentController.ActiveSheet[n]oSheet.getCellRangeByName($1)("A1")=1
I have also tried letting Libre create macros as I type and the results are very very much longer and much more obscure.
I doubt that it is in reality as bad as it looks because people are actually using it.
Am I just not looking at it correctly or is it really so bad?
Thanks for your insights.