Request a feature

[Inercina]

Hello, I want to request a Feature for Calc, the Formula Evaluator because I need for checking if the formula do the operations in the correct order or no, the evaluator in excel puts the formula in the screen and the cells involved (b7, 4 example), then change the cells by the numbers in cells and make the mathematical operations step by step, thus we can see if I missed a parenthesis or the cause of a wrong result.

I must close Calc and open excel to the formula evaluation; is the only thing I miss from excel, now I can edit faster in LibreOffice than in Microsoft; thus I must close open close open for having the formulas right in a faster way without checking with the calculator.

I tried to attach the image, but I recieved a window with the text:
TypeError: data is undefined.
My e-mail for sending the image is rosemeer@yahoo.com.mx

Thanks in advance and best regards
Rosa María -from Mexico

[ROSt53]

@Inercina Did you ever place your enhancement request?
If not you can do so in a bug report and place the word “enhancement” as the first word in the subject line

[cornouws]

Sorry, but is not appropriate to put ENHANCEMENT or enhancement in the subject line!

Do this in the field ‘Severity’ (in a bug already filed, after the field ‘Importance’).

Thanks!

[erAck]

There’s the Formula Wizard you can invoke also on an existing cell formula, under menu Insert Function or Ctrl+F2 or click on the f(x) icon. In the wizard the Structure tab page displays the nesting levels of the expressions, and if in the Formula window you click on a function name or travel with the cursor within a function’s arguments you see the partial result displayed.

[qubit1]

Hi @Inercina,

Please file an enhancement bug and provide as much information about this new feature as possible. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!

[Inercina]

I tried that, but it does not solve the function step by step, the window only show me the final result, not how I went to the result.
I refer to:
excel = Select the cell that contains the formula, and on the Formulas tab, in the Formula Auditing group, click Evaluate Formula:

every time you push the EVALUATE button, one value is sutitued in place and in the next push the function/operation is applied.

[erAck]

Maybe you missed the “if in the Formula window you click on a function name or travel with the cursor within a function’s arguments you see the partial result displayed” part of the above answer?

[Inercina]

Hello.
I check what you say, for example 3i51+LN(j51)/(i52+j52), when i put the cursor on LN(j51) I have the value of logarithm (0.693147) but I was expecting the step resolution of whole formula, for example
initial 3I51 + LN(J51)/(I52+J52); push EVALUATE button (Eb)
3*5+LN(J51)/(I52+J52)
15+LN(J51)/(I52+J52), push Eb 15+LN(2)/(I52+J52), push Eb 15+0.6931471806/(I52+J52), push Eb 15+0.6931471806/(9+1), 15+0.6931471806/(10), 15+0.06931471806, push Eb 15.6931471806
The initial cell direction is gradually sustituted by the cell value, the operation made and all partial results are showed, but all not only LN(2), also multiplications, divisions, sustractios.

That is the only thing I miss from excell, it saves me hours of checking sheets (engineering calculations, used many times but sheet cannot have misstakes)
Thanks, have a nice day and best regards.
15+0.693147

[qubit1]

Hi @Inercina, Did you find an answer to your question – your comment here is a little unclear to me, and I wanted to double-check with you before I resolved this answer as correct. Thanks!

[Inercina]

I found some similar in OpenOffice help selecting part of the equation and pulsing F9, but I receive the partial result; that really helps,but 4 understanding I think I must send a screen-shot to the developers to request; is the only thing that I miss from microsoft office, in all other things I prefer the way of LibreOffice. May be this is not the adequate place to put this ENHANCEMENT, please advice me.
Thank you very much 4 your comments. Best regards and have a nice weekend.
Rosa Maria