Import XLSX spreadsheet to an InDesign table: the "-1" problem
1. InDesign CS4 - CC2017
2. 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".
3. the cells with the value "-1" should still have this value.
4. 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.
Thanks for reporting this issue. We are able to verify the issue and therefore changing its status to “Under Review”
Payal Awasthi commented
Thanks for reporting this issue.
We have verified this issue and it is currently under review.