Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 14 Oct 2017 16:13:53 +0200request a featurehttps://ask.libreoffice.org/en/question/2533/request-a-feature/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 MexicoThu, 10 May 2012 06:21:05 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/Comment by cornouws for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=134625#post-id-134625Sorry, but is not appropriate to put ENHANCEMENT or enhancement in the subject line!
<br>Do this in the field 'Severity' (in a bug already filed, after the field 'Importance').
<br>Thanks!Sat, 14 Oct 2017 16:13:53 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=134625#post-id-134625Comment by ROSt52 for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=10742#post-id-10742@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 lineSun, 27 Jan 2013 16:25:55 +0100https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=10742#post-id-10742Answer by Inercina for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=7336#post-id-7336Hello.
I check what you say, for example 3*i51+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 3*I51 + 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.693147Wed, 31 Oct 2012 20:07:14 +0100https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=7336#post-id-7336Comment by qubit for <p>Hello.
I check what you say, for example 3<em>i51+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 3</em>I51 + 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.</p>
<p>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</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=10730#post-id-10730Hi @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!Sun, 27 Jan 2013 09:20:11 +0100https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=10730#post-id-10730Answer by Inercina for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=15760#post-id-15760I 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 MariaFri, 05 Apr 2013 19:11:18 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=15760#post-id-15760Answer by erAck for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=3611#post-id-3611There'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.Thu, 28 Jun 2012 13:17:21 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=3611#post-id-3611Answer by qubit for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=13673#post-id-13673Hi @Inercina,
Please [file an enhancement bug](https://www.libreoffice.org/get-help/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!
Sun, 03 Mar 2013 00:58:13 +0100https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=13673#post-id-13673Answer by Inercina for <p>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.</p>
<p>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.</p>
<p>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</p>
<p>Thanks in advance and best regards
Rosa María -from Mexico</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=4703#post-id-4703I 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.Fri, 10 Aug 2012 02:22:23 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/?answer=4703#post-id-4703Comment by erAck for <p>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: </p>
<p>every time you push the EVALUATE button, one value is sutitued in place and in the next push the function/operation is applied.</p>
https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=5115#post-id-5115Maybe 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?Mon, 20 Aug 2012 23:23:46 +0200https://ask.libreoffice.org/en/question/2533/request-a-feature/?comment=5115#post-id-5115