Ask Your Question
0

request a feature [closed]

asked 2012-05-10 06:21:05 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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

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 2015-10-28 02:58:47.403335

Comments

@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 gravatar imageROSt52 ( 2013-01-27 16:25:55 +0100 )edit

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!

cornouws gravatar imagecornouws ( 2017-10-14 16:13:53 +0100 )edit

5 Answers

Sort by » oldest newest most voted
1

answered 2013-03-03 00:58:13 +0100

qubit gravatar image

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!

edit flag offensive delete link more
3

answered 2012-06-28 13:17:21 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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.

edit flag offensive delete link more
0

answered 2013-04-05 19:11:18 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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

edit flag offensive delete link more
0

answered 2012-08-10 02:22:23 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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.

edit flag offensive delete link more

Comments

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?

erAck gravatar imageerAck ( 2012-08-20 23:23:46 +0100 )edit
0

answered 2012-10-31 20:07:14 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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

edit flag offensive delete link more

Comments

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!

qubit gravatar imagequbit ( 2013-01-27 09:20:11 +0100 )edit

Question Tools

Stats

Asked: 2012-05-10 06:21:05 +0100

Seen: 1,056 times

Last updated: Apr 05 '13