Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LibreOffice - General

Hello, Weekly I download a worksheet from my account, it is in xls format. When I open it either in LibreOffice calc or in Microsoft Office Excell and try to sum a column of numbers, it does not even draw a rectangle arond the cells to sum. Entering manually into the sum formula the first cell and the last cell (=sum(d4:d15)) it gives zero or something else except the sum. Now I define (for the test) another column as numbers, enter manually the figures from each cell into the new column, when finished click on sum, and it works (only on this new column). From anothe account I download a xlsx file, open it in LibreOffice or Excell, sum works fine. Is there some problem with this xls format ? Or, how to make it work ? LibreOffice is updated to 6.0.5, checked also in previous version 6.0.4 - the same. Answers will be appreciated Thanks Motim

click to hide/show revision 2
None

LibreOffice - General

Hello, Weekly I download a worksheet from my account, it is in xls format. When I open it either in LibreOffice calc or in Microsoft Office Excell and try to sum a column of numbers, it does not even draw a rectangle arond the cells to sum. Entering manually into the sum formula the first cell and the last cell (=sum(d4:d15)) it gives zero or something else except the sum. Now I define (for the test) another column as numbers, enter manually the figures from each cell into the new column, when finished click on sum, and it works (only on this new column). From anothe account I download a xlsx file, open it in LibreOffice or Excell, sum works fine. Is there some problem with this xls format ? Or, how to make it work ? LibreOffice is updated to 6.0.5, checked also in previous version 6.0.4 - the same. Answers will be appreciated Thanks Motim