Bug 38484 - Incorrect loading of ODF file
Summary: Incorrect loading of ODF file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: ODF-import
  Show dependency treegraph
Reported: 2011-06-19 22:12 UTC by Andreas J Guelzow
Modified: 2021-12-14 10:26 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

sample file (4.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-06-19 22:12 UTC, Andreas J Guelzow

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas J Guelzow 2011-06-19 22:12:32 UTC
Created attachment 48176 [details]
sample file

According to ODF 1.2, the <style:header> element has a style:display attribute specifying whether the header or footer is displayed or not. The default value for this attribute is true. (See ODF 1.2 Part 1, 19.471)

The attached file has
    <style:master-page style:name="tamp-0x899f740" style:page-layout-name="pl-default">
        <style:region-left><text:p><text:span>Page </text:span><text:page-number style:num-format="1"/></text:p>        </style:region-left>
        <style:region-center><text:p><text:sheet-name/></text:p>        </style:region-center>
        <style:region-right><text:p><text:span>Date: </text:span><text:date style:data-style-name="ND.0"/></text:p>        </style:region-right>
        <style:region-left><text:p><text:expression text:display="formula" text:formula="of:=[.$A$1]"/></text:p>        </style:region-left>
        <style:region-center><text:p><text:span>Page </text:span><text:page-number style:num-format="1"/><text:span> of </text:span><text:page-count style:num-format="1"/></text:p>        </style:region-center>
        <style:region-right><text:p><text:file-name text:display="name-and-extension"/></text:p>        </style:region-right>
and although this is read by LibreOffice calc the header and footer are initially hidden.
Comment 1 Björn Michaelsen 2011-12-23 12:25:14 UTC Comment hidden (obsolete)
Comment 2 Andreas J Guelzow 2011-12-23 13:04:13 UTC Comment hidden (obsolete)
Comment 3 Rainer Bielefeld Retired 2012-01-08 04:13:58 UTC
Status of this bug report has been modified wrongly by a bulk change. 
No additional info is required, but someone with ODF knowledge to confirm reporter's complaint.
Comment 4 sasha.libreoffice 2012-04-11 03:16:32 UTC
Thanks for bugreport

http://odf-validator.rhcloud.com/ complains in this file only about this:
unexpected attribute "gnm:GnmHAlign"
So, nothing about header and footer. So, IMHO problem not in attached file.
msOffice 2007 on Windows 7 opens this file with header and footer initially.
Attached file created in gnumeric/1.10.17. So, we can do some additional experiments with Gnumeric when needed.
Comment 5 Andreas J Guelzow 2012-05-15 14:23:39 UTC
Regarding comment #4: 
http://odf-validator.rhcloud.com/ complains in this file only about
unexpected attribute "gnm:GnmHAlign"
only for OASIS ODF 1.2 (conforming), not for
OASIS ODF 1.2 (extended conforming).

OASIS ODF 1.2 allows for foreign attributes and foreign elements in the extended conforming class.
Comment 6 QA Administrators 2015-01-05 17:52:35 UTC Comment hidden (obsolete)
Comment 7 Buovjaga 2015-01-29 10:30:22 UTC

Win 7 Pro 64-bit Version:
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
Comment 8 QA Administrators 2016-02-21 08:38:14 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2017-03-06 16:11:29 UTC Comment hidden (obsolete)
Comment 10 Regina Henschel 2017-06-04 18:00:52 UTC
Neither header nor footer enabled in Version:
Build ID: b56d1e294d838d4b3d0f237c81325a0d1a1cff83
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-05-26_06:14:42
Locale: de-DE (de_DE); Calc: group
Comment 11 QA Administrators 2018-06-05 02:38:37 UTC Comment hidden (obsolete)
Comment 12 Franklin Weng 2019-11-23 13:34:13 UTC
Still reproducible in 

組建 ID:a64200df03143b798afd1ec74a12ab50359878ed
CPU 執行緒:4; OS:Linux 5.2; UI 算繪:預設; VCL: kde5; 
語言地區:zh-TW (zh_TW.UTF-8); UI語言:zh-TW
Calc: threaded

I noticed that even I enabled the header, added something in the middle block and removed another 2 blocks, and saved with this version, the style:header attribute became

<style:header><text:p>Book1 <text:date style:data-style-name="N2" text:date-value="2019-11-23">0000/00/00</text:date></text:p></style:header><style:header-left style:display="false"/>

No style:display="true" either.
Comment 13 João Paulo 2021-08-29 21:27:49 UTC
This bug is still reproducible with:

Version: (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: pt-BR (pt_BR); UI: pt-BR
Calc: threaded
Comment 14 Regina Henschel 2021-12-04 17:01:34 UTC
This is likely fixed with commits for bug 121715 and bug 144940. Please test with a current daily build.
Comment 15 Buovjaga 2021-12-14 10:26:59 UTC
(In reply to Regina Henschel from comment #14)
> This is likely fixed with commits for bug 121715 and bug 144940. Please test
> with a current daily build.

I checked the file with print preview and PDF export and did not see header or footer.

Arch Linux 64-bit
Version: / LibreOffice Community
Build ID: 110d3504c1f738a1d7f740cc212064dafa4fb224
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 10 December 2021