How to hide the active sheet grid lines?

[eeigor]

Is there a replacement for the Uno-method of dispatcher?

Code: Select all

Sub ToggleSheetGrid
	Dim document As Object, dispatcher As Object

	document = ThisComponent.CurrentController.Frame
	dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
	dispatcher.executeDispatch(document, ".uno:ToggleSheetGrid", "", 0, Array())
End Sub

How do I know if the active sheet grid lines are currently displayed?

An example of a non-uniform approach.
E.g. Why it affects all sheets:
>>> ThisComponent.CurrentController.ShowGrid = True
And this one only for the active sheet:
>>> ThisComponent.CurrentController.freezeAtPosition(0, 1)

[Zizi64]

viewtopic.php?f=9&t=38999

[Zizi64]

A workaround tip:

Use Cell styles with colorized cell background (at least with white color), then the grid lines will be invisible on the sheet.

(Or just use the Dispatcher method)

[Zizi64]

viewtopic.php?f=9&t=91869

https://extensions.openoffice.org/en/project/gridlines

[eeigor]

ThisComponent.CurrentController.ShowGrid = True
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>