Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 24 Feb 2013 11:59:04 +0100treatment of mathematical operations on texthttps://ask.libreoffice.org/en/question/13026/treatment-of-mathematical-operations-on-text/**3.6.5.2 build 5b93205**
I have just installed LibreOffice and am trying to migrate my Staroffice .xls spreadsheets.
The .xls spreadsheets are openable with LibreOffice, but there is a problem with the treatment of non-numerical data when mathematical operations are performed.
LibreOffice returns the error #VALUE! when it finds non-numerical data in a cell that is being operated on mathematically (this is correct according to the HELP Manual). StarOffice treats this situation differently, it just ignores the non-numerical data, so the mathematical operation can complete sucessfully.
**EXAMPLE:** In the formula **=SUM(OFFSET(H683,-1,0),C683,-D683,E683)**
If one cell referenced by the formula has something other than a numerical value in it, then
- **LibreOffice** returns #VALUE!
- **StarOffice** ignores the non-numerical cell, and returns the
outcome of the calculation. This is
very useful in large complex
spreadsheets. Is there a way round
this in LibreOffice? I have tried to
find one without success.
Thanks.
petef.Sun, 24 Feb 2013 11:59:04 +0100https://ask.libreoffice.org/en/question/13026/