Bug 141667 - [Calc] ThisComponent.CurrentController.ShowGrid => affects the grid of all sheets, but not the active one (inconsistent behavior)
Summary: [Calc] ThisComponent.CurrentController.ShowGrid => affects the grid of all sh...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-UNOAPI
  Show dependency treegraph
Reported: 2021-04-13 08:07 UTC by Igor
Modified: 2021-04-16 06:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

bt with debug symbols (4.48 KB, text/plain)
2021-04-13 17:35 UTC, Julien Nabet

Note You need to log in before you can comment on or make changes to this bug.
Description Igor 2021-04-13 08:07:21 UTC
It's an example of a non-uniform approach.
>>> ThisComponent.CurrentController.ShowGrid = True  'affects all sheets
>>> ThisComponent.CurrentController.freezeAtPosition(0, 1)  'affects active sheet

NOTE: This looks like a 10 year-old bug. ODS's file 'settings.xml' contains the 'ShowGrid' property for each sheet.
<config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>

Steps to Reproduce:
1. Select a sheet.
2. Run in code: ThisComponent.CurrentController.ShowGrid = False

Actual Results:
The grid of all sheets will be hidden.

Expected Results:
The grid of only the active sheet is hidden.

Reproducible: Always

User Profile Reset: No

Additional Info:
To hide the sheet grid via the GUI, right-click on the sheet tab and select "View Grid Lines" (menu: View/View Grid Lines)

Some links solve a contrived problem:
Comment 1 Julien Nabet 2021-04-13 17:35:12 UTC
Created attachment 171168 [details]
bt with debug symbols

On pc Debian x86-64 with master sources updated today, I could reproduce this.

I don't know if it's expected or not but attached a bt showing where the value for "ShowGrid" is set.
Comment 2 himajin100000 2021-04-14 18:06:59 UTC
What if you run?

Option Explicit

Sub Macro1()

	Dim dispatchhelper As com.sun.star.frame.XDispatchHelper
	dispatchhelper = createUnoService("com.sun.star.frame.DispatchHelper")

	rem ----------------------------------------------------------------------
	dispatchhelper.executeDispatch(ThisComponent.CurrentController.Frame, ".uno:ToggleSheetGrid", "", 0, Array())

end sub
Comment 3 Igor 2021-04-15 03:36:02 UTC
The dispatcher method works. But the question was different. "Toggle” does not allow you to determine the current state.