Issue 127086

Summary: Incorrect import of xlsx file - no text
Product: Calc Reporter: alexls <alexlsh>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: RESOLVED DUPLICATE QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: damjan, knmc, mseidel
Version: 4.1.2Keywords: ms_interoperability
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
incorrectly opened document none

Description alexls 2016-08-24 10:16:59 UTC
Created attachment 85653 [details]
incorrectly opened document

When I opened attached file in AOO, I see almost no text in it. File opened, I can see borders, images, but not text. I can see very small part of text. Most of cells looks like empty, but it is not. I can see text in cells: B25, B26, AB25, AB26, AG25, AG26, AK25, AK26, AK28, AK29, AK30. That's all. All other cells are empty. 
Possible this is incorrectly formatted document, but I can open it fine in MSO and I can read all text. 
Not me created this document. It received from other company and I need to open it.
Comment 1 Keith N. McKenna 2016-08-24 14:31:58 UTC
Confirmed with the following configuration:
System Configuration:
Processor: Intel Core i5 CPU M560 @2.67GHz
Installed Memory: 2.00 GB (1.6 usable)
Operating System: Windows 7 Home Premium 64 bit

Apache Open Office:
AOO412m3(Build:9782)  -  Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
Language: en_US
Additional Language Packs: None
and
AOO420m1(Build:9800)  -  Rev. 1692551
Rev.1692551

File opens fine with Excel Viewer showing entries in cells that appear blank when opened with AOO.
Comment 2 alexls 2018-01-30 14:49:48 UTC
Updated to 4.1.5 version - bug still here
Comment 3 Keith N. McKenna 2018-01-30 16:03:39 UTC
Restored the original Version to 4.1.2 and set Latest Confirmation in to 4.1.5.

Please do not change the Version field without discussion either in the bug or in the qa mailing list. This represents the version that the bug was first reported against and is used by developers to help locate potential areas in the code that could be causing the problem. To update the confirmation in a later version use the Latest Confirmation in: field.

Thank You
Comment 4 damjan 2023-01-03 16:51:01 UTC
The problem with this document is that the file:
xl/SharedStrings.xml
has the wrong case, it should be:
xl/sharedStrings.xml

If you rename it to a zip file, unzip it, change the filename, zip it back up, rename back to xslx, it opens perfectly, with all the text visible.

We should treat OOXML filenames case-insensitively, like Excel and LibreOffice do.
Comment 5 damjan 2023-01-03 17:03:41 UTC
This was first reported in bug 126720, resolving DUPLICATE.

Thank you for your bug report and sample file.

*** This issue has been marked as a duplicate of issue 126720 ***