[Libreoffice-bugs] [Bug 40033] "Automatic" array formulas

[bugzilla-daemon at freedesktop.org]

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

--- Comment #3 from Reto <reto.schoch at gmail.com> 2011-09-20 12:44:00 PDT ---
(In reply to comment #2)
> Perhaps I need to clarify: The "dragging" of "=SUM(…)" works fine. I'm looking
> for "dragging" of /array/ formulas like
> "{=SUM((A1:A100>=90)*(A1:A100<=120)*(A1:A100))}". does that work on your LO
> 3.4, Jeffrey?

I tried it on LO 3.4.3 and it does not work neither. Having the array formula
in cell D1 and dragging it to D2 I get an error like #NAME? in both cells
because the function changes to "sum" instead of "SUM". Beside, it looks like
it would not copy incrementially but expand the array to the next cell.

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