# treatment of mathematical operations on text [closed]

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