Hi all, I'm experiencing a bug where any formulas that reference a text value in my excel files import into Indesign as "-1". Can anyone confirm this bug on their system? If so, please vote for this bug report.
Steps to reproduce:
1. In Microsoft Excel, in cell A1 add "Some text"
2. In cell B1 add formula "=A1"
3. Save excel document .xlsx
4. Import into indesign as Unformatted Table (note: formatted table works fine)
I'm using Indesign 17.4 and Excel for Mac 16.63.1, on MacOS 12.6.
If you are also experiencing this bug, please vote for this bug report.
Copy link to clipboard
Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.
Thanks so much. I can confirm what you say. I have updated the bug report.
Now that I think about it, Dates should work fine since they are really just numbers to Excel (days since 01/01/1900)
You are right.