Bug 118294 - Hidden gridlines cannot made visible temporarily
Summary: Hidden gridlines cannot made visible temporarily
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Grid-Helplines
  Show dependency treegraph
Reported: 2018-06-21 08:24 UTC by Heiko Tietze
Modified: 2021-09-02 07:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Heiko Tietze 2018-06-21 08:24:09 UTC
While the default with tools > options > calc > view > visual aids > gridlines = show allows to hide them temporarily per view > gridlines for sheet the opposite is not possible. That means when in tools > options the gridlines are off by default it should be respected and toggled by the view settings.
Comment 1 Maxim Monastirsky 2018-06-21 13:15:04 UTC
Currently the global and the per-sheet settings are independent of each other, and stored separately into ods. And the grid lines of a specific sheet are visible only if both of these settings are true. Therefore, making a per-sheet show setting override the global hide setting, will make the global setting effectively ignored for existing sheets, as any sheet has a per-sheet setting (set to either true or false) anyway. To solve this, we'll need to make sure that once the global setting is modified, all sheets are iterated, and their per-sheet setting is reseted to the global one (or to a 3rd "default" state which follows the global setting).

Another problem is compatibility with existing documents. Some users might just use the global setting to hide the grid (and actually that was the only option in OOo and still in AOO), and if we make the per-sheet setting override the global one, such documents will open with a visible grid, although they were originally designed with a hidden grid. So we'll have to check upon file import whether the document was created by an earlier version of LO, and in such case ignore the per-sheet setting if the global setting is "false".

Unfortunately, this won't solve the incompatibility of documents created by a newer version, and opening them with an older version, but I don't know what else can be done in this regard.

Adding Eike to CC, to get his input.
Comment 2 QA Administrators 2019-09-02 09:21:22 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2021-09-02 03:52:16 UTC Comment hidden (obsolete)
Comment 4 Heiko Tietze 2021-09-02 07:46:46 UTC
(In reply to Maxim Monastirsky from comment #1)
> a per-sheet show setting override the global hide setting... compatibility

Wasn't thinking so far. The issue is that you show/hide gridlines per View > View Grid Lines but only if tools > options ... visual aids is active. The option has no function if gridlines are hidden globally. So either we disable .uno:ToggleSheetGrid in this case or make .uno:ToggleSheetGrid toggle the global setting, which was my original idea.