Issue 127086 - Incorrect import of xlsx file - no text
Summary: Incorrect import of xlsx file - no text
Status: RESOLVED DUPLICATE of issue 126720
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.2
Hardware: PC All
: P5 (lowest) Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2016-08-24 10:16 UTC by alexls
Modified: 2023-01-03 17:03 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Attachments
incorrectly opened document (137.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-08-24 10:16 UTC, alexls 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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 ***