Import XLSX spreadsheet to an InDesign table: the "-1" problem
InDesign CS4 - CC2017
Generate an Excel spreadsheet that contains at least one cell with the value "-1". Save as XLSX. Import/place (cmd-d) this file as "unformatted table".
the cells with the value "-1" should still have this value.
the cells are empty. All other values seem to show up correctly.
Additional information: Working regularly on Annual Reports with 100+ tables, our choice is to import as „unformatted table“ and to do all formatting in InDesign. After changes in Excel, all we have to do is updating the linked tables via the link panel. Table contents change, formatting stays. Perfect. But we are dependent on our clients still willing to use the outdated XLS format.
Please have a look at this problem! Thank you in advance.
Thank you for reporting the issue to us.
We have fixed the issue in the latest version of InDesign, Id 15.0
Please upgrade your InDesign application to the latest version to try out the fix.
If you face any problems with the new update, do let us know in the comments.
You may also follow the below given link for the list of all fixed issues in Id 15.0
I am also having an issue when relinking the excel sheet, the blank columns in excel fill in with -$1
Steve DAgostino commented
Any fix for this yet?
John Mortensen commented
I still have an issue with this. When linking xlsx files to InDesign I receive a "-1" when the linked cell in Excel contains a formula that returns text from a cell in a different worksheet in the same workbook. Numbers come in just fine.
InDesign ver 15.0.1 Win 10 workstation
Payal Awasthi commented
Thanks for reporting this issue.
We have verified this issue and it is currently under review.