Bug 38351

Summary: XLSX: missing number format
Product: LibreOffice Reporter: Andreas J Guelzow <aguelzow>
Component: SpreadsheetAssignee: 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

Description Andreas J Guelzow 2011-06-15 09:26:38 UTC
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&quot;, &quot;YYYY" numFmtId="166"/></numFmts>
Comment 1 Katarina Behrens 2011-06-16 03:48:54 UTC
taking this one ...
Comment 2 Carlo Strata 2012-04-26 13:03:31 UTC
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
Comment 3 M Welinder 2014-06-03 00:33:10 UTC
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.