Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 07 Mar 2018 20:34:47 +0100why does the sum feature in spreadsheet only show ### for totalhttps://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/ sum feature in spreadsheet not showing totalWed, 28 Feb 2018 02:42:01 +0100https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/Comment by librebel for <p>sum feature in spreadsheet not showing total</p>
https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?comment=147737#post-id-147737try if you make the cell wider.Wed, 28 Feb 2018 03:06:49 +0100https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?comment=147737#post-id-147737Answer by ChristopherThomas for <p>sum feature in spreadsheet not showing total</p>
https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?answer=147774#post-id-147774Increase the column widthWed, 28 Feb 2018 12:51:33 +0100https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?answer=147774#post-id-147774Answer by Cuadtigers for <p>sum feature in spreadsheet not showing total</p>
https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?answer=148487#post-id-148487The sum function does not work it only shows the formula in the column or #####. Just to double check myself, I even read the manual to make sure I did it right since this is a variation of Excel. I had to forward a document from one computer to the one with Excel for a summation. =sum(#:#) where # is your data, does not compute. Even if you hand enter all the numbers the old fashioned way with =#+#+#. Nada. But the exact same function in Excel worked in seconds. Seems to be a problem with the function.
Wed, 07 Mar 2018 16:57:01 +0100https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?answer=148487#post-id-148487Comment by floris v for <p>The sum function does not work it only shows the formula in the column or #####. Just to double check myself, I even read the manual to make sure I did it right since this is a variation of Excel. I had to forward a document from one computer to the one with Excel for a summation. =sum(#:#) where # is your data, does not compute. Even if you hand enter all the numbers the old fashioned way with =#+#+#. Nada. But the exact same function in Excel worked in seconds. Seems to be a problem with the function. </p>
https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?comment=148513#post-id-148513Toggle display of formulas to get the result.Wed, 07 Mar 2018 20:34:47 +0100https://ask.libreoffice.org/en/question/147734/why-does-the-sum-feature-in-spreadsheet-only-show-for-total/?comment=148513#post-id-148513