Created attachment 48006 [details] sample file When saving a file (see attached) in xlsx (Office Open XML Spreadsheet) format includes the following xf records: <xf applyAlignment="false" applyBorder="false" applyFont="true" applyProtection="false" borderId="0" fillId="0" fontId="1" numFmtId="41"></xf> <xf applyAlignment="false" applyBorder="false" applyFont="true" applyProtection="false" borderId="0" fillId="0" fontId="1" numFmtId="44"></xf> <xf applyAlignment="false" applyBorder="false" applyFont="true" applyProtection="false" borderId="0" fillId="0" fontId="1" numFmtId="42"></xf> <xf applyAlignment="false" applyBorder="false" applyFont="true" applyProtection="false" borderId="0" fillId="0" fontId="1" numFmtId="43"></xf> These numFmtIDs 41,42,43 and 44 are not predefinied in ECMA-376-1 so corresponding <numFmt> elements should exist in <numFmts> but in this file we only have: <numFmts count="3"><numFmt formatCode="GENERAL" numFmtId="164"/><numFmt formatCode="YYYY/MM/DD" numFmtId="165"/><numFmt formatCode="DDDD, MMMM\ D", "YYYY" numFmtId="166"/></numFmts>
taking this one ...
Hi Everyone! I confirm this bug in my environment too. I have just verified and reproduced this ancient and long time bug. This is my environment: - OpenSuSE linux 12.1, x86-64 architecture, kernel 3.1.10-31; - LibreOffice, linux, x86-64, 3.5.3.1 (RC1) and 3.5.3.2 (RC2), vanilla rpm builds. To simply reproduce it: - you can create a new spread sheet; - "save as" it as xlsx 2007/2010 format; - open it on Gnumeric; - you will get: -- an "Undefined number format id '42'"; -- a spread sheet without any grid on cells. This is also well described here: http://ubuntuforums.org/archive/index.php/t-1611874.html Have a nice evening, Carlo
Still present in LibreOffice 4.2.3.3 420m0(Build:3)
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.