[Solved] Hiding The Formula Bar

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
User avatar
RichieRH
Posts: 36
Joined: Sun Oct 19, 2014 6:16 pm

[Solved] Hiding The Formula Bar

Post by RichieRH »

Is there any code to hide Formula Bar using Macro ??

Like SheetTab, or Grid ?
thiscomponent.currentcontroller.showgrid= True/False

I want to design my application layout just like what I want.....
Last edited by RichieRH on Fri Oct 31, 2014 3:29 pm, edited 1 time in total.
Debian 8 Jessie
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Hiding The Formula Bar

Post by JohnSUN-Pensioner »

Use macrorecorder ;)

Code: Select all

Sub HideFormulaBar(Optional showBar As Boolean)
Dim oDoc As Object
Dim oDisp As Object
Dim args(0) As new com.sun.star.beans.PropertyValue
	If IsMissing(showBar) Then showBar = False
	args(0).Name = "InputLineVisible"
	args(0).Value = showBar
	oDoc = ThisComponent.CurrentController.Frame
	oDisp = createUnoService("com.sun.star.frame.DispatchHelper")
	oDisp.executeDispatch(oDoc, ".uno:InputLineVisible", "", 0, args())
End Sub

Sub ShowFormulaBar
HideFormulaBar(True)
End Sub
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
RichieRH
Posts: 36
Joined: Sun Oct 19, 2014 6:16 pm

Re: Hiding The Formula Bar

Post by RichieRH »

why did not I think of that before....... solved
Debian 8 Jessie
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
akhter28
Posts: 5
Joined: Thu Jan 18, 2018 7:03 pm

Re: [Solved] Hiding The Formula Bar

Post by akhter28 »

I want to hide formula not formula bar.
is it possible?
Please guide
OpenOffice 3.1 on Windows Vista
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Hiding The Formula Bar

Post by Zizi64 »

I want to hide formula not formula bar.
is it possible?
Please guide
Do you meant: You want to hide the formulas in the cells? - Use the Cell protection feature.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply