Importing Excel unformatted table text-based formulas import as "-1"
Indesign 17.4
steps to reproduce:
a) In Microsoft Excel (for Mac version 16.63.1), in cell A1 add "Some text"
b) in cell B1 add formula "=A1"
c) save excel document .xlsx
d) Import into indesign as Unformatted Tableexpected result: table cell A2 contents should be "Some text", same as A1
Actual result: table cell A2 contents is "-1"
Anonymous
shared this idea
Fix for this issue is available in the latest release of InDesign 18.2.1
Please update InDesign to the latest from Creative Cloud Desktop app.
--
Adobe InDesign team
-
William tyrone Harper commented
No other devices just this phone 8708054287
-
[Deleted User]
commented
I can confirm this issue is fixed for me in Indesign 18.2 release.
-
[Deleted User]
commented
I can confirm that this is fixed in Indesign 18.2 Prerelease. Thank you.
-
[Deleted User]
commented
Maybe the fix for [this bug](https://indesign.uservoice.com/forums/601180-adobe-indesign-bugs/suggestions/31903918-import-xlsx-spreadsheet-to-an-indesign-table-the) might be causing this bug?
-
[Deleted User]
commented