frspread - formula
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
kjteng · 2019-02-25 06:30

In Excel, A1+A2+A3+A4+A5 will return #value if one of these cell
contains non numeric data.
fpspread seems to behave differently and only give #value when the
last cell is not numeric?

----------------------------------------------------------------------
kjteng · 2019-02-25 06:33

attached excel file

----------------------------------------------------------------------
wp · 2019-02-25 08:39

They are pretty inconsistent because SUM(C2:C6) does not yield the
#VALUE error value, but simply ignores the non-numeric cells, i.e.
adds them as being 0.

The real problem for fpspreadsheet I think is that, even when
C2+C3+C4+C5+C6 were allowed to ignore the non-numeric cells, the sum
is not correct: cell C7 should show 14, but not 12! I'll have a look.

----------------------------------------------------------------------
wp · 2019-02-26 09:05

Should be fixed in the current revision 6019 in fpspreadsheet-svn.

----------------------------------------------------------------------
kjteng · 2019-02-26 09:59

Yeap. Download and tested. TQ.