188.8.131.52 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.