[Solved] Hiding The Formula Bar

Creating a macro - Writing a Script - Using the API

[Solved] Hiding The Formula Bar

Postby RichieRH » Fri Oct 31, 2014 1:46 pm

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
RichieRH
 
Posts: 36
Joined: Sun Oct 19, 2014 6:16 pm

Re: Hiding The Formula Bar

Postby JohnSUN-Pensioner » Fri Oct 31, 2014 1:57 pm

Use macrorecorder ;)
Code: Select all   Expand viewCollapse view
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.4, LibreOffice 5.4.2.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
JohnSUN-Pensioner
Volunteer
 
Posts: 761
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Hiding The Formula Bar

Postby RichieRH » Fri Oct 31, 2014 3:28 pm

why did not I think of that before....... solved
Debian 8 Jessie
Linux Mint 17.3 XFCE
Country : Indonesia
Learning is a need
User avatar
RichieRH
 
Posts: 36
Joined: Sun Oct 19, 2014 6:16 pm

Re: [Solved] Hiding The Formula Bar

Postby akhter28 » Mon Jan 29, 2018 9:11 am

I want to hide formula not formula bar.
is it possible?
Please guide
OpenOffice 3.1 on Windows Vista
akhter28
 
Posts: 5
Joined: Thu Jan 18, 2018 7:03 pm

Re: [Solved] Hiding The Formula Bar

Postby Zizi64 » Mon Jan 29, 2018 9:44 am

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests