Recent

« previous next »
Pages: [1]

Author Topic: frspread - formula  (Read 2295 times)

kjteng

  • Sr. Member
  • ****
  • Posts: 259
frspread - formula
« on: February 25, 2019, 07:30:30 am »
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? 

Logged

kjteng

  • Sr. Member
  • ****
  • Posts: 259
Re: frspread - formula
« Reply #1 on: February 25, 2019, 07:33:13 am »
attached excel file
Logged

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: frspread - formula
« Reply #2 on: February 25, 2019, 09:39:07 am »
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.
Logged

wp

  • Hero Member
  • *****
  • Posts: 11916
Re: frspread - formula
« Reply #3 on: February 26, 2019, 10:05:35 am »
Should be fixed in the current revision 6019 in fpspreadsheet-svn.
Logged

kjteng

  • Sr. Member
  • ****
  • Posts: 259
Re: frspread - formula
« Reply #4 on: February 26, 2019, 10:59:54 am »
Yeap. Download and tested. TQ.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018