Bug 151966 - XLS: footer in the middle and at the right is not saved
Summary: XLS: footer in the middle and at the right is not saved
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xls, regression
Depends on:
Blocks: Calc-Header-Footer
  Show dependency treegraph
 
Reported: 2022-11-08 22:12 UTC by Stewart
Modified: 2023-04-17 05:49 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
The file as saved (46.46 KB, image/png)
2022-11-13 23:44 UTC, Stewart
Details
The file when Re-Openned (46.50 KB, image/png)
2022-11-13 23:45 UTC, Stewart
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stewart 2022-11-08 22:12:36 UTC
Description:
In Calc the format of the footer in the middle and at the right is not saved.

Actual Results:
Enter a value in the middle and right side of the footer. Save the file then open it again.

Expected Results:
The Middle and right side of the footer have not been saved after the file is openned again


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Saved the footer.
Comment 1 m_a_riosv 2022-11-08 23:34:44 UTC
Works fine for me with:
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b57307e8f3553fcb292c9c11fcf58bcef3a6cb3c
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
and
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL

What file format do you use to save?

You can test in safe mode, Menu/Help/Restart in Safe Mode
Comment 2 Stewart 2022-11-13 23:44:42 UTC
Created attachment 183573 [details]
The file as saved
Comment 3 Stewart 2022-11-13 23:45:37 UTC
Created attachment 183574 [details]
The file when Re-Openned
Comment 4 QA Administrators 2022-11-14 03:34:20 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2022-11-14 07:15:57 UTC
Did you really save the Calc file as *.xls?

Only *.ods will save all information for Calc in the right way.
Comment 6 Robert Großkopf 2022-11-14 07:23:44 UTC
Could confirm all content for footer isn't saved right in *.xls-format. There only appears the 'Page …', nothing else.

Saving the file as *.xlsx will save all informations and format like *.ods-files have been saved.
Comment 7 Tammy 2022-12-04 18:01:55 UTC
It also worked fine for me.
-Verified by saving the file as a .ofd file and reopening it 
-Verified by saving the file as a .xls and reopening it 
-Verified by saving the file as .csv and reopening. The footer information did not appear. 

Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Version: 7.5.0.0.alpha1+ (x86) / LibreOffice Community
Build ID: c50cf1883af26daebdfc9d796ced3c20c222f43b
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 8 raal 2022-12-09 16:45:26 UTC
works in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

confirm in Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 705b2924a14841883b4a8cac549f7af326d7a185
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

save as .xls
Comment 9 raal 2022-12-09 17:18:30 UTC
This seems to have begun at the below commit.
Adding Cc: to Dániel Arató; Could you possibly take a look at this one?
Thanks
 fd2ac7e8d6e355957a8222b3f2e1d3414103f5a8 is the first bad commit
commit fd2ac7e8d6e355957a8222b3f2e1d3414103f5a8
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Tue Jul 20 16:46:40 2021 +0200

    source 6128e2d55f0d0c68d3c7f6fb69539ec800637947

https://gerrit.libreoffice.org/c/core/+/117316