Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 15 Sep 2019 06:14:52 +0200Libre calc problemhttps://ask.libreoffice.org/en/question/208690/libre-calc-problem/ I have inserted a graph, I have the table with all the data needed and have made the graph from it. The problem here is that most of the data is 'averages' some of which have several decimal points. Most of these can be reduced to 2 decimal points, except one in particular. It has about 5 decimal places and when I try to reduce the amount of places the cell goes immediately to ### this is peculiar to only this one cell, all the others just work as expected. Can someone out there explain what I am doing wrong in this cell.?
Thanks for your consideration in this matter.
Rod.Sun, 15 Sep 2019 05:38:38 +0200https://ask.libreoffice.org/en/question/208690/libre-calc-problem/Comment by robleyd for <p>I have inserted a graph, I have the table with all the data needed and have made the graph from it. The problem here is that most of the data is 'averages' some of which have several decimal points. Most of these can be reduced to 2 decimal points, except one in particular. It has about 5 decimal places and when I try to reduce the amount of places the cell goes immediately to ### this is peculiar to only this one cell, all the others just work as expected. Can someone out there explain what I am doing wrong in this cell.?
Thanks for your consideration in this matter.
Rod.</p>
https://ask.libreoffice.org/en/question/208690/libre-calc-problem/?comment=208691#post-id-208691What do you see in the cell with ### if you make it wider?Sun, 15 Sep 2019 06:14:52 +0200https://ask.libreoffice.org/en/question/208690/libre-calc-problem/?comment=208691#post-id-208691