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.
The fix is now available in the Beta builds of InDesign. You can download the latest beta build from Download section of InDesign Prerelease portal.
1. Go to adobeprerelease.com
2. Log in with your Adobe Id.
3. Once logged in, search for “InDesign CC Prerelease” program in the list.
4. Click on the program to join the same.
5. You can download the latest available build (22.214.171.124) from “Builds and Plugins” section on the page.
6. The steps for installing the build can be found in the release notes.
Adobe InDesign team
Payal Awasthi commented
Thanks for reporting this issue.
We have verified this issue and it is currently under review.