asked 2012-05-10 06:21:05 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
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
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!
answered 2012-06-28 13:17:21 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
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.
answered 2012-10-31 20:07:14 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
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
answered 2013-04-05 19:11:18 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
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
answered 2012-08-10 02:22:23 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-10 06:21:05 +0200
Seen: 226 times
Last updated: Apr 05
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
@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
ROSt52 ( 2013-01-27 16:25:55 +0200 )edit