Bug 120480 - Headers and Footers Can be Changed in Read-only Spreadsheets
Summary: Headers and Footers Can be Changed in Read-only Spreadsheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
5.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Read-Only
  Show dependency treegraph
Reported: 2018-10-10 12:06 UTC by Harald Koester
Modified: 2018-10-10 12:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Harald Koester 2018-10-10 12:06:48 UTC
In order to reproduce the bug:

[1] Create new spreadsheet.
[2] Insert a bit of text into a cell.
[3] Save document.
[4] Change to read-only mode: Edit > Edit Mode
[5] Change Header: Insert > Headers and Footers… > Tab Header > Insert a bit of text into one of the areas. Then OK.. Expected: A change should not be possible.
[6] View Preview: File > Print Preview. The change of step 5 is displayed.

One possibility in order to correct this bug may be to grey the menu item “Headers and Footers...”. But I think there are cases where a user likes to view the content of headers and footers in read-only mode. For this use cases the dialogue Headers/Footers should be displayed furthermore, but it should not be possible to make any changes in this dialogue.
Comment 1 Xisco Faulí 2018-10-10 12:12:23 UTC
Reproduced in

Build ID: 4a0ca73c31990568bf20a1c3f0906c3a5770a38e
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded
Comment 2 Xisco Faulí 2018-10-10 12:13:29 UTC
Also reproduced in

Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default;