Description: I have generated xlsx file using Open XML SDK structure and file is loaded blank. If you try to open it in Microsoft Excel it shows data, and if you just save it, it can be also read by LibreOffice. Seems like structure of generated XML is not readable by Libre, but im not sure. Steps to Reproduce: 1. Open XLSX file Actual Results: Blank file Expected Results: Loaded file with 5 rows of data Reproducible: Always User Profile Reset: No Additional Info: I can send example of docs if needed.
Created attachment 170364 [details] its a xlsx file with 5 rows File has 5 rows not readable by libre
according to Excel, some cell information needed repairing. when I load the repaired file in LibreOffice, I can see the contents.
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: dc3b64dcbfb0a49c0be65bd8d73ed4e6d3828a21 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: CL
Created attachment 170365 [details] the file repaired by Excel 2016
Yes, its repaired when open in Excel and save. But do you know what cell need reparation ? I've loaded xlsx in OOXML viwer and difference is in app.xml auto generated by SDK where Difference in app.xml: Repaired file: <TitlesOfParts> <vt:vector size="1" baseType="lpstr"> <vt:lpstr> Sheet1 </vt:lpstr> </vt:vector> </TitlesOfParts> <AppVersion> 14.0300 </AppVersion> Original file: <TitlesOfParts> <vt:vector size="1" baseType="lpstr"> <vt:lpstr> anton </vt:lpstr> </vt:vector> </TitlesOfParts> <AppVersion> 16.0300 </AppVersion> Other difference in SharedStrings.xml (self closing tag) Original file: <si> <t></t> </si> Repaired file: <si> <t/> </si>
Created attachment 170371 [details] New file with one row I've added a new file, with one row. Excel didnt display any problem about corrupted cells or problem with contetn. But its blank in Libre. Thanks for reply
Created attachment 170373 [details] smaller reproducible document ( with freezed pane )
wait, I thought the missing content was reproducible, but it wasn't. let me rethink.
just a guess (possible cause?) case-sensitiveness of the filename "sheet1.xml" and "Sheet1.xml"
possible source code pointer? https://opengrok.libreoffice.org/xref/core/oox/source/core/xmlfilterbase.cxx?r=99bc040b#395
Yes thats the problem. Even if pointer in workbook is Sheet1 it can't be read unless its lower case. Thank you for solving this issue!
(In reply to himajin100000 from comment #2) > according to Excel, some cell information needed repairing. > > when I load the repaired file in LibreOffice, I can see the contents. Are we sure it's LO's problem?
After I've replaced xl/worksheets/Sheet1.xml to xl/worksheets/sheet1.xml content is loaded normal in Libre, even stylings and filters are displayed. Im not sure why there is check for LO, maybe some convention...
(In reply to himajin100000 from comment #10) > possible source code pointer? > > https://opengrok.libreoffice.org/xref/core/oox/source/core/xmlfilterbase. > cxx?r=99bc040b#395 Yes it's related but the pb is LO uses one of these: - [Content_Types].xml - xl/_rels/workbook.xml.rels Indeed, if you unzip the xlsx, you'll see: sheet1.xml So the simplest thing would be to fix Open-XML-SDK so it would be coherent and about this bugtracker, I would put NOTOURBUG/NOTABUG but just my opinion. László: any thoughts here?
This looks similar to bug 100084. @Balazs Varga, I thought you might be interested in this issue
Since there were no more traction here, I close as proposed.
Excel opens the file and shows it as expected, and since that is the reference for OOXML files, Calc should do the same, regardless whether the file conforms to the standard or not.
Dear JohnR, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug