Imported Excel unformatted table text-based formulas import as "-1"

Forum|Forum|3 years ago
September 26, 2022
1 reply
376 views

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.

- Mark

This topic has been closed for replies.

Correct answer Dave Creamer of IDEAS

Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.

Dave Creamer of IDEAS

Correct answer

Community Expert

Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.

David Creamer: Community Expert (ACI and ACE 1995-2023)

m1b

Author

Community Expert

Thanks so much. I can confirm what you say. I have updated the bug report.

- Mark

Dave Creamer of IDEAS

Community Expert

Now that I think about it, Dates should work fine since they are really just numbers to Excel (days since 01/01/1900)

David Creamer: Community Expert (ACI and ACE 1995-2023)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded