Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 20 Aug 2017 15:39:10 +0200Calc cells shows only formula and not product/outputhttps://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/Hello,
Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.
This is very strange and frustrating, can anyone help with fixing this? Thanks!Fri, 16 Mar 2012 03:23:15 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/Answer by moggi for <p>Hello,</p>
<p>Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.</p>
<p>This is very strange and frustrating, can anyone help with fixing this? Thanks!</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=1257#post-id-1257You need to disable the checkbox in Options->LibreofficeCalc->View->FormulaFri, 16 Mar 2012 14:07:10 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=1257#post-id-1257Comment by avamk for <p>You need to disable the checkbox in Options->LibreofficeCalc->View->Formula</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=1613#post-id-1613@moggi It worked, thanks! I don't remember checking the box in the first place, though...Sat, 31 Mar 2012 06:04:06 +0200https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=1613#post-id-1613Comment by Triggerhousinggroup for <p>You need to disable the checkbox in Options->LibreofficeCalc->View->Formula</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=124638#post-id-124638On Mac OS X 10.12.6, the mouse chant is *Preferences->LibreOffice Calc->View->Formulas*. That might help someone frantically searching for the *Options* button...Sun, 20 Aug 2017 15:39:10 +0200https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=124638#post-id-124638Answer by Franz for <p>Hello,</p>
<p>Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.</p>
<p>This is very strange and frustrating, can anyone help with fixing this? Thanks!</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=24924#post-id-24924Changing the formatting helped me! Thanks! (Can't vote you up - not enough points...)Thu, 07 Nov 2013 05:58:46 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=24924#post-id-24924Answer by jofilho for <p>Hello,</p>
<p>Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.</p>
<p>This is very strange and frustrating, can anyone help with fixing this? Thanks!</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=1244#post-id-1244Hi, see your cells format. Maybe they are formated as **Text**. In this case, formulas doesn't work. So, change it and try again.Fri, 16 Mar 2012 05:13:24 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=1244#post-id-1244Comment by Andy for <p>Hi, see your cells format. Maybe they are formated as <strong>Text</strong>. In this case, formulas doesn't work. So, change it and try again.</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=24568#post-id-24568Change it to what?Tue, 29 Oct 2013 12:06:16 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=24568#post-id-24568Comment by selivan for <p>Hi, see your cells format. Maybe they are formated as <strong>Text</strong>. In this case, formulas doesn't work. So, change it and try again.</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=64244#post-id-64244Worked for me, thanks. I even signed in to upvote it, but it's impossible with novice karma < 5 :(Wed, 10 Feb 2016 18:38:56 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=64244#post-id-64244Comment by fulldecent for <p>Hi, see your cells format. Maybe they are formated as <strong>Text</strong>. In this case, formulas doesn't work. So, change it and try again.</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=70078#post-id-70078Thanks, upvoting by comment!Wed, 18 May 2016 14:42:10 +0200https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?comment=70078#post-id-70078Answer by harryg123 for <p>Hello,</p>
<p>Since updating to (I think) LibreOffice 3.5.0 (and now 3.5.1) on Mac OS X 10.6.8, all my Calc spreadsheet formulas continue to work, but their cells no longer show the results! Instead, the cells show the formula. I tried copy a paste special with numbers only from the formula into another cell, and the formula's output gets pasted.</p>
<p>This is very strange and frustrating, can anyone help with fixing this? Thanks!</p>
https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=29928#post-id-29928I am running Libreoffice Calc 4.0.2.2 under Linux Mint 15 Cinnamon on a 4GB RAM Intel i3 machine. When "Show Formula" is checked, the formuala appears, but not the result. Unchecked, I see the result. As expected.
HOWEVER
I also run LibreOffice 4.0.0.3 for Windows in a Windows XP virtual machine. In this case, when Show Formula is checked, l get the result. When it is NOT checked, all I see is the formula.
Is this a bug or a feature?Sun, 16 Feb 2014 06:41:43 +0100https://ask.libreoffice.org/en/question/1240/calc-cells-shows-only-formula-and-not-productoutput/?answer=29928#post-id-29928