Summary: | XLSX: missing number format | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Andreas J Guelzow <aguelzow> |
Component: | Spreadsheet | Assignee: | Katarina Behrens <bubli> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | carlo.strata |
Version: | 3.3.2 release | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: | sample file |
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.
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>