Hello,
I have converted some excel MACRO's to work in CALC but running in to some issuesSheet = ThisComponent.Sheets.getByName("somesheetname").Wh ile this code works when stepping through the code with F8 ... if I save and open my ods file I get an error for each cell that calls the function containing this object??? OpenOffice 4.1.1 BASIC runtime error ... property or method not found: sheets.This error occurs for each cell calling the function and provides no way to ignore all.There doesn't appear to be a way to turn off auto calc when calc opens ... excel has a shift F9 function to force a recalc of a sheet.Am I missing something?
Please help.
I didn't find the right solution from the Internet.
References:-
https://forum.openoffice.org/en/foru...p?f=20&t=77319
Thanks