Copy link to clipboard
Copied
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)
typing the formula
formula is working
Indesign import options I used
this is what I got
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.
- Mark
1 Correct answer
Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.
Copy link to clipboard
Copied
Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.
Copy link to clipboard
Copied
Thanks so much. I can confirm what you say. I have updated the bug report.
- Mark
Copy link to clipboard
Copied
Now that I think about it, Dates should work fine since they are really just numbers to Excel (days since 01/01/1900)
Copy link to clipboard
Copied
You are right.
![](/skins/images/DAB90319B8FCC6914FB48BF3A053A8A8/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/DAB90319B8FCC6914FB48BF3A053A8A8/responsive_peak/images/icon_anonymous_message.png)