It has been some years since i have handled Excel in this way, but my recollection is that the numbers are stored in excel and the German formatting (e.g. comma as decimal separator) is applied in Excel.
Are you placing .xlsx in ID or saving out .csv from Excel? I will pop open Excel when i get to my office in a few hours and see if i can't remember how to keep German formatting when moving content from Excel to ID (unless someone else posts it first)
You should inform us on
- OS, version and language
- InDesign, version and language.
- What type of file do you use txt, XLS, XLSX or anything else?
- What language has your paragraph (best set up in Paragraph Style Definition) as this has influence how the cell fields are imported and translated into InDesign.
But to be honest, the Excel Sheet import for the German language is poor. It is different with a file created on a Mac and a file created on Windows, different when imported on a Mac and different when imported on Windows and causes different problems, when the platform changes.
In German we have the problem that comma and point are exchanged compared to English. Exports from Excel exchange point and comma a little bit to extensive and do it not only in the numbers, but also in the code, specially on the Mac.
I want place .xlsx in ID. I did a calendar with formulas in Excel. Now I want to place it in ID. But instead of the German Days in ID everything get translated into English.
I use Windows 7, German
InDesign CC, German
I want to place a XLSX-file
The language in my paragraph styles is also in German.
I tested today a XLS-File. With this file German stays German. But in this type, not every formula can be saved. So I need the XLSX Type, to garanty the whole functionality of the calendar. But with this, ID translate.
You have to make a workaround. Create another sheet, and make all fields equal to the other one, with a formula which translates the content to text. This can be imported as you want.
Thanks for the answer, but how I do this?
You have to do it in Excel, you need to use a formula to transform calculated values to text. Either use the widget in that program or consult an MS Excel forum.