Define global variables

Question

I am trying to test some algorithms in LibreOffice Calc, and I would like to have some global variables visible in all cells / sheets. I searched the Internet, and everything I saw is so mysterious and verbose!

I would appreciate if you could give me simple noob instructions (1 2 3 ...) on how I can do this.

Answer 1

Using custom functions should be the most flexible solution for defining constants. In the following case, I assume that the current Calc spreadsheet file is called test1.ods. Replace it with the real file name in the following steps:

• Calc → → → LibreOffice Basic:

  

• test1.ods New...:

  

• OK (Module1 ).

  

  IDE:

  

• End Sub :

Function Var1()
    Var1 = "foo"
End Function

Function Var2()
    Var2 = 42
End Function

IDE :

5. CTRL + S .

, (: , ). . LO Calc test1.ods, :

=Var1()

LO Var1(), . , . :

=Var2() * 2

LO 84.

Answer 2

→ → . name "MyVar1" 5. , "foo". .

=MyVar1 * 2 .

Answer 3

,

, , "" , .