Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 08 Aug 2013 23:41:17 +0200sum will not show value resulthttps://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/I am trying to add a column of figures. I use the Sum function and the function appears in the cell box at the top but nothing appears in the cell on the spreadsheet. Tools|Options|LibreOffice Calc|View has formulas unchecked. If I check it I get the formula but if I uncheck it I get nothing, makes no sense. Any help appreciated.Thu, 08 Aug 2013 23:17:54 +0200https://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/Comment by carnendil for <p>I am trying to add a column of figures. I use the Sum function and the function appears in the cell box at the top but nothing appears in the cell on the spreadsheet. Tools|Options|LibreOffice Calc|View has formulas unchecked. If I check it I get the formula but if I uncheck it I get nothing, makes no sense. Any help appreciated.</p>
https://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/?comment=21258#post-id-21258Please check that the content of the cells are not as text (right-click and "format cells")Thu, 08 Aug 2013 23:32:57 +0200https://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/?comment=21258#post-id-21258Answer by CraigM for <p>I am trying to add a column of figures. I use the Sum function and the function appears in the cell box at the top but nothing appears in the cell on the spreadsheet. Tools|Options|LibreOffice Calc|View has formulas unchecked. If I check it I get the formula but if I uncheck it I get nothing, makes no sense. Any help appreciated.</p>
https://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/?answer=21259#post-id-21259Problem resolved. I found after I closed the spreadsheet and reopened it the values appeared. May have been that the tools options settings did not apply themselves to the spreadsheet until after it had been shut down.Thu, 08 Aug 2013 23:41:17 +0200https://ask.libreoffice.org/en/question/21257/sum-will-not-show-value-result/?answer=21259#post-id-21259