Bug 38351 - XLSX: missing number format
Summary: XLSX: missing number format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.2 release
Hardware: Other All
: medium normal
Assignee: Katarina Behrens
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-15 09:26 UTC by Andreas J Guelzow
Modified: 2014-06-03 00:33 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
sample file (6.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-06-15 09:26 UTC, Andreas J Guelzow
Details

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.