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.....
[Solved] Hiding The Formula Bar
[Solved] Hiding The Formula Bar
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
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
- JohnSUN-Pensioner
- Volunteer
- Posts: 876
- Joined: Fri Jan 14, 2011 1:21 pm
- Location: Kyiv, Ukraine
Re: Hiding The Formula Bar
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
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
Re: Hiding The Formula Bar
why did not I think of that before....... solved
Debian 8 Jessie
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
Re: [Solved] Hiding The Formula Bar
I want to hide formula not formula bar.
is it possible?
Please guide
is it possible?
Please guide
OpenOffice 3.1 on Windows Vista
Re: [Solved] Hiding The Formula Bar
Do you meant: You want to hide the formulas in the cells? - Use the Cell protection feature.I want to hide formula not formula bar.
is it possible?
Please guide
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.
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.