[Libreoffice-bugs] [Bug 124643] Calc - skips existing sum cell if I create a new sum containing the existing cell(using mouse for selecting cells)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jan 24 10:54:36 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=124643

--- Comment #7 from b. <newbie-02 at gmx.de> ---

just tested, still buggy in 6.4.0.2, 

would be nice if someone with skills and knowledge about the code could care
for it, 

perhaps it's quite easy ... as it's only a small 'isolated' functionality to
suggest the selected range for the formula, instead of a part of it if it
already contains a formula? 

looks as if it fails as well with manually entered formulas as with 'wizard
inserted', 

looks as if it fails only with formulas referencing a range, regardless if
represented by 'start:end' or enumeration (A1;A2;A3), 

but doesn't fail with distinct summation - 'A1+A2+A3', 

and fails only if one of the formulas (SUM, MIN, MAX, AVERAGE, COUNT) which are
offered by the wizard is found into the list of operands, if you have a
'=PRODUCT(Xi:Yn)' into the operands they are evaluated correctly, 

reg. 

b.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200124/1dbe32f9/attachment.htm>


More information about the Libreoffice-bugs mailing list