Importing Numbers file with formulas

asked 2019-07-31 02:17:50 +0200

gyannes gravatar image

updated 2019-07-31 02:20:14 +0200

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.

edit retag flag offensive close merge delete


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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-31 02:32:10 +0200 )edit