Importing Numbers file with formulas

[gyannes]

I have a numbers document with the following formula =SMALL(INDIRECT(“H6:H25”),1). It works fine in Numbers on iPad but when imported into LibreOffice on MacBook the formula is lost and replaced with last known value. But if I retype the formula in LibreOffice exactly as it is in Numbers then it works fine. If I send the file from LibreOffice to Numbers the same thing happens.
I believe Small and Indirect are supported by both but I can’t seem to share.

The issue is I have a workbook with 30+ sheets and each sheet has 10 similar formulas so I can’t keep updating the formulas when trying to send between iPad and mac book.
Please advise

Thank you.

[mikekaganski]

What you describe looks like a bug in import filter for Numbers files. (You didn’t mention the file format btw, nor LibreOffice version used.) Please file a bug report for that, and don’t forget to attach a sample spreadsheet that doesn’t get imported correctly.