Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 08 Nov 2017 13:49:44 +0100Can Calc use Math to show Formulas?https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.
When I edit the same equation in Calc it shows the operators and cell references like this:
=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))
It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.
The page www.libreoffice.org/discover/math/ says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.
Can Math be used to graphically display a formula already entered into a Calc cell?Mon, 30 Oct 2017 12:36:44 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/Comment by Mike Kaganski for <p>When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.</p>
<p>When I edit the same equation in Calc it shows the operators and cell references like this:</p>
<pre><code>=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))
</code></pre>
<p>It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.</p>
<p>The page <a href="http://www.libreoffice.org/discover/math/">www.libreoffice.org/discover/math/</a> says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.</p>
<p>Can Math be used to graphically display a formula already entered into a Calc cell?</p>
https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136484#post-id-136484No, the Math object can be inserted into a Calc document in the same way as into Writer document, but it's not a calculatable object; just an object to design math formatting.
Also, Math's syntax is incompatible with Calc formulas.Mon, 30 Oct 2017 12:39:20 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136484#post-id-136484Comment by David.Cheshire for <p>When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.</p>
<p>When I edit the same equation in Calc it shows the operators and cell references like this:</p>
<pre><code>=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))
</code></pre>
<p>It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.</p>
<p>The page <a href="http://www.libreoffice.org/discover/math/">www.libreoffice.org/discover/math/</a> says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.</p>
<p>Can Math be used to graphically display a formula already entered into a Calc cell?</p>
https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136485#post-id-136485Thanks, I thought that might be the case.
It would be nice to have a way of graphically displaying Calc formulas, that would make the input of complex formulas easier.Mon, 30 Oct 2017 13:18:18 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136485#post-id-136485Comment by Lupp for <p>When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.</p>
<p>When I edit the same equation in Calc it shows the operators and cell references like this:</p>
<pre><code>=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))
</code></pre>
<p>It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.</p>
<p>The page <a href="http://www.libreoffice.org/discover/math/">www.libreoffice.org/discover/math/</a> says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.</p>
<p>Can Math be used to graphically display a formula already entered into a Calc cell?</p>
https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136494#post-id-136494As a rudimentary tool you may use the multiline-mode in the formula bar. As long as you are writing there, you can even insert line breaks (by Ctrl+Enter). They will be cancelled, however, when the formula is finally entered. Spaces survive.Mon, 30 Oct 2017 14:29:43 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=136494#post-id-136494Answer by ajlittoz for <p>When I edit a formula in Writer it shows the equation graphically in the document, which helps to identify errors.</p>
<p>When I edit the same equation in Calc it shows the operators and cell references like this:</p>
<pre><code>=(1+C$3*$B10)*(1-C$5*$B10)/SQRT((1+C$4*$B10)^3*(1-C$6*$B10-C$7*$B10^2))
</code></pre>
<p>It is not so easy to spot errors in this. It would be useful if Calc were able to display the formula graphically in equation form like Writer does.</p>
<p>The page <a href="http://www.libreoffice.org/discover/math/">www.libreoffice.org/discover/math/</a> says "Math is LibreOffice's formula editor, and can be invoked in your text documents, spreadsheets, presentations and drawings, " and I know that Math can be linked into Calc to enter graphical formulas into the sheet as illustrations rather than working equations.</p>
<p>Can Math be used to graphically display a formula already entered into a Calc cell?</p>
https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?answer=136555#post-id-136555There is a cheat trick which could provide something more or less close to what you request.
To insert a formula in a blank cell or edit an existing formula: select the cell and `Insert`->`Function...` or `Ctrl`+`F2`.
Then go to the `Structure` tab in the dialog. You edit the formula in the *Formula* box with the tree structure displayed in the *Structure* box at left.
This is rather rudimentary but may help.
*If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.*
Tue, 31 Oct 2017 08:14:18 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?answer=136555#post-id-136555Comment by David.Cheshire for <p>There is a cheat trick which could provide something more or less close to what you request.</p>
<p>To insert a formula in a blank cell or edit an existing formula: select the cell and <code>Insert</code>-><code>Function...</code> or <code>Ctrl</code>+<code>F2</code>.</p>
<p>Then go to the <code>Structure</code> tab in the dialog. You edit the formula in the <em>Formula</em> box with the tree structure displayed in the <em>Structure</em> box at left.</p>
<p>This is rather rudimentary but may help.</p>
<p><em>If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.</em></p>
https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=137376#post-id-137376Thanks, I hadn't seen that Function Wizard. It is not clear to me what the Structure box is supposed to show, but if you copy the formula from my original question and paste it into the Formula box, the display in the Structure window is not very helpful. (It's a real formula, not just random.)Wed, 08 Nov 2017 13:49:44 +0100https://ask.libreoffice.org/en/question/136483/can-calc-use-math-to-show-formulas/?comment=137376#post-id-137376