Download it now!
Bug 38351 - FILESAVE XLSX: missing number format
Summary: FILESAVE XLSX: missing number format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.2 release
Hardware: Other All
: medium normal
Assignee: Katarina Behrens
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2011-06-15 09:26 UTC by Andreas J Guelzow
Modified: 2020-05-18 14:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


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

Note You need to log in before you can comment on or make changes to this bug.
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)
Comment 4 QA Administrators 2015-06-08 14:42:02 UTC Comment hidden (obsolete)
Comment 5 Bartosz 2016-08-03 21:03:56 UTC
Tested with LO 5.1 and ubuntu 16.04
Comment 6 JJ 2019-02-11 15:37:54 UTC
I have this problem with files created using both LibreOffice versions:
* 6.0.7.3.0+
* 6.1.5.2

Running on Arch Linux, locale: en-US (en_US.UTF-8)
Comment 7 Xisco Faulí 2019-02-12 16:44:01 UTC Comment hidden (obsolete)
Comment 8 Andreas J Guelzow 2019-02-12 17:26:16 UTC
Xisco, with which LO version does this work correctly for you?  LibreOffice developers appear to just like to close bugs that they didn't bother to fix and interoperability seems to be of no interest to them. So really there is little reason for others to file bugs to help to improve LO.