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?


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.)

  • For clarification, I had previously added a reference to a different feature, which I took back out since that wasn't what you were referring to. For people not familiar with this feature, can you add a sentence or two to the question describing what it does? Users familiar with Calc but less familiar with Excel, might have information to contribute if they understand the nature of the feature. – fixer1234 Jul 12 '15 at 8:03

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).

  • 1
    +1 for your PS. Wasn't aware of that feature and it is useful. – fixer1234 Jul 11 '15 at 18:51
  • Share the knowledge! :-) P.S. (yes, another one here, I abuse of them... and love parentheses as much too) with Mac the keys combination should be Fn + F9 – danicotra Jul 12 '15 at 7:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.