Excel – LibreOffice Calc equivalent to Excel “Evaluate Formula” feature

libreoffice-calcmicrosoft excelopenoffice-calcworksheet-function

Excel has an "Evaluate Formula" feature (it's located in the Excel Formulas ribbon among the Formula Auditing group, as shown in the picture below).

Excel's "Evaluate Formula" feature

Is there an equivalent to that Excel feature in LibreOffice Calc?

EDIT:

Following fixer1234 suggestion, I add a link to a site showing an example of how the Excel "Evaluate Formula" feature works. This way, users familiar with Calc but less familiar with Excel, may better understand what the matter is about and more easily contribute information.

In the example you can notice what I call the step-by-step "evolution" of the formula. In fact, with every step of the evaluation process, part of the formula is replaced with its actual result till the reaching of the final result. (This may come very handy when dealing with particularly long formulas.)

Best Answer

I'm answering my own question with what I know so far, anyone who can provide better solutions/news about new Calc features, really welcome!


As far as I know, what comes closest in Calc to Excel "Evaluate Formula" is the "Formula Wizard" (you can open it by selecting the cell containing the formula you want to check out and hitting Ctrl+F2 or by clicking on the "fx" icon in the formula bar).

It's not that bad at all but it's not exactly the same thing yet; in fact the process differs in the way you don't view the same Excel's step by step "evolution" of the formula but a step by step "evaluation" of it.

P.S.: For completeness about the matter I'll add that what works the same way in either Excel and in Calc, instead, is the partial evaluation of a formula that can be done by selecting a portion of a formula in the formula bar and hitting F9 (in this case, you'll obtain the calculated result only for the highlighted section of the formula).