Data missing when importing a spreadsheet (Exel) into InDesign
When I insert an excel document into my indesign document some values of some cells do not appear in Indesign document. I tried to save the excel document in an older version and that's the only way it worked.I think it's a compatibility issue. See this link that have the same problem: https://graphicdesign.stackexchange.com/questions/65160/data-missing-when-importing-a-spreadsheet-into-indesign
I need that this issue resolved to can work in editorial work design.
Glyn Szasz commented
Still having this same issue. When I import xlsx with -1 in a cell it comes in as blank. If I import xls into a document it comes perfectly fine. In 2022 this is not acceptable having to use a format that is 14 years old. Using the latest version of Indesign the issue seems to still be around..