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.
Chris Ryland
shared this idea
Hi,
This issue has been fixed in the latest release.
-Aman
-
Stefan
commented
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.
-
Stefan
commented
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. -
Anonymous
commented
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!
Melissa Voetberg
-
Chris Ryland
commented
(I should add that the actual number is 100,000,000 and the formatted number is 100.0 in the spreadsheet.)