Search code examples
libreoffice-calc

How do I get the formula as text in LibreOffice Calc?


Essentially I’m looking for an equivalent/alternative to the MS Excel Function FORMULATEXT(...) in LO Calc…

In MS Excel, I can do the following:

=FORMULATEXT(B3)

... which will return the function contained in cell B3 as text (great for teaching, notes, etc.)

Microsoft FORMULATEXT Documentation:

https://support.microsoft.com/en-us/office/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8


Solution

  • In Calc it is written as =FORMULA(B3)