Bug 153508 - Renaming Sheet Headers in Calc causes ALL headers to change to the new header
Summary: Renaming Sheet Headers in Calc causes ALL headers to change to the new header
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4 all versions
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-10 00:00 UTC by Dave
Modified: 2023-02-10 02:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dave 2023-02-10 00:00:08 UTC
Description:
If I insert a header such as JAN Expenses in a sheet and then create a new sheet and insert a header of FEB Expenses why does calc then apply that header to ALL calc sheets?


Steps to Reproduce:
1.Create a Calc sheet and insert a header of 1.
2.Create a NEW Calc sheet and name the header as today
3.Look at original Calc sheet that had a heade of 1 and it now has been changed to "today"
w. WHY??

Actual Results:
1.Create a Calc sheet and insert a header of 1.
2.Create a NEW Calc sheet and name the header as today
3.Look at original Calc sheet that had a heade of 1 and it now has been changed to "today"
w. WHY??

Expected Results:
That the header of each Calc sheet would remain as originally entered instead of being globally changed to the last header entered.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2023-02-10 02:49:17 UTC
Please for this kind of questions go first to https://ask.libreoffice.org/c/english/5 (on several languages available).

Headers/Footers are part of the page styles, every sheet only can have one style, and when you add a new sheet it has default's style, you need to create a new page style for this second one, for every page style you can set up their own header.


(https://help.libreoffice.org/latest/en-US/text/scalc/01/05070000.html?DbPAR=CALC#bm_id651593596384469)
https://help.libreoffice.org/latest/en-US/text/scalc/01/05070000.html?DbPAR=CALC#bm_id651593596384469 page 198