Reference a formula instead of a value?

[medicengonzo]

Is it possible to refrence a formula in a cell instead of the value result of said cell?

For example:

I have the formula =sum(A1:A5) in the cell A1. In cell B1 i would like to reference the formula in A1 so instead of getting the result of the sum I get the string =sum(A1:B5)

Is this possible in LibreCalc?

[mikekaganski]

Guess what? This will do: =FORMULA(A1)

[medicengonzo]

Nice! Is there any way i can get it without the = sign? I mean sum(A1:A5). I am trying to use it in another formula.

[mikekaganski]

=MID(FORMULA(A1);2;65535)

[medicengonzo]

Exactly what I needed! Thanks