How to write a Basic Macro to set Libre calc options View Display Zero values On and Off?

[TingliChan]

How to write a Basic Macro to set Libre calc options View Display Zero values On and Off?

[JohnSUN]

Do you mean something like this?

Sub ToggleZeroView
Dim oCurrentController As Variant
	oCurrentController = ThisComponent.getCurrentController()
	oCurrentController.ShowZeroValues = Not oCurrentController.ShowZeroValues
End Sub

[TingliChan]

You are the Man! IOU many thanx.