Ask Your Question

Is there a way to evaluate a function in Calc? [closed]

asked 2014-09-18 22:55:03 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to identify problems in nested functions and currently talking the spreadsheet to Excel to evaluate (step into debug) my daisy chained formula's.

I would really like to know if there is something in available in Calc comparable to this function in Excel or if I need to submit a feature request.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 22:33:16.735405

1 Answer

Sort by » oldest newest most voted

answered 2014-09-19 10:28:29 +0100

JPL gravatar image

You can try:

  • hit F9 while selecting a portion of your formula in the formula editor
  • use the excellent so-called "function wizard" which is available by pressing one of the buttons located at the left of the formula editor.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-18 22:55:03 +0100

Seen: 3,668 times

Last updated: Sep 19 '14