excel import filter fails formatting
When importing an Excel spreadsheet, formatted cells are incorrectly imported.
E.g., place the following one-cell spreadsheet in CC 2018 (not tested in earlier, but I imagine it's true there), and you'll see either "10,000,000,000,000.0." in the cell (under macOS) or "1,000.0" (under Windows).
Needless to say, this is a critical bug for people using Excel with InDesign, since it causes serious mis-representations of imported numbers.
This issue has been fixed in the latest release.
I did find a solution to the issue, as far as my problem was concerned. In Excel, under the formatting menu, any formatting that has an asterix (*) as a prefix, will use the Windows home location format as a default. Changing to a formatting without an * took care of 90% of the problem. The remainder, after placing it in InDesign, was taken care off with a Find/Change replacement. Not perfect, but it worked.
It has not been fixed in the InDesign CC 14.0.1 x64 that I am using. I believe that to be the latest version.
When placing a table from Excel (.xlsx) into a InDesign document, for me it changes the date format. Adobe support was connected to my PC for app. 1 hr, without being able to solve it.
Is there any fix on this bug?
Melissa Voetberg commented
Is there an update on this issue? I need to move forward on the layout of several 500+ page budget books that are using the importing excel spreadsheet function. It appears I'm going to have to either export out of excel as a PDF and the client is not happy. Linking the spreadsheet is VITAL to seamless data importing!
Chris Ryland commented
(I should add that the actual number is 100,000,000 and the formatted number is 100.0 in the spreadsheet.)