When opening my spreadsheet in excel I am encountering compatibility problems. Hopefully it is something simple but I am unable to solve it.
1.PNG
2.PNG
3.PNG
Any help appreciated.
Cheers,
Gary.
What LibreOffice version do you use?
WARNING: the ODS file linked to in the posting contains macros. Unless the asker clearly explains what the hell is going on, I recommend to ignore this thread.
Apologies,
yes there are macros that do several calcs but there are no references outside the sheet.
Version: 6.1.3.2 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 12; OS: Windows 10.0; UI render: default;
Locale: en-AU (en_AU); Calc: group threaded
Cheers.
Added the macro code to question.
Version: 6.2.2.1 (x64)
Build ID: fcd633fb1bf21b0a99c9acb3ad6e526437947b01
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL
The version above does not generate any “we found a problem” warnings in Excel. Still, it’s normal that your macros won’t work in Excel - they are simply not there. LibreOffice macros are not exported to any external format.
Thanks Mike,
that confirms what I have found. I will upgrade to version 6.2.2.1.
What is the correct way to approach this to get the macros (or equivalent) to work and be able to export to excel.
Possibly create an XLSM with required macros in Excel, then you can work with it with LO. LibreOffice can read (and write back, IIRC) Excel macros; Excel cannot read LO macros.
But that would require that you work with a foreign format - which is always not ideal. Some incompatibilities/shortcomings in external format support are likely to show up.
Thanks again,
at this point I think I’ll just convince the recipients to install LO and can’t see the point in duplicating effort, especially as this is for a new project.
Cheers.