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.