[Libreoffice-bugs] [Bug 39687] Missing parameters in formula is 0 value

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=39687

--- Comment #5 from xdmx <dmx404 at gmail.com> 2011-08-01 10:58:03 PDT ---
(In reply to comment #3)
> (In reply to comment #2)
> > when I use the AVERAGE
> > formulae with A1:10, A3: 20, A2: empty, I do not get Error nor 10. Instead, I
> > get 15
> 
> Yes, if you use this formula :
> =AVERAGE(A1;A3)
> 
> But if there is a syntax error in your formula :
> 
> =AVERAGE(A1;A3;)
> 
> you can't get err511, but a wrong result.

Ahhhhhhhh, I think I now know what happens. If using ;; (converted to ,,)
AVERAGE() for example sees the empty cell inbetween A1 and A3 too and because
this cell is set to 0, the average of 10, 0 and 20 is 10 !!! And the some ; you
add, the some zero's are included.
And this doesn't happen when using a :
Maybe the reason you get errors on older versions is that the cells were
uninitialized instead of 0 ?!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.