https://bugs.documentfoundation.org/show_bug.cgi?id=140691
--- Comment #11 from b. <[email protected]> ---
Created attachment 171360
--> https://bugs.documentfoundation.org/attachment.cgi?id=171360&action=edit
sample comparing different operand sequences affecting the sum
did a little more investigation, and found something what blocks consistent
sheets in calc ...
calc has no fixed order how it calculates ranges,
from experiments with three operands i concluded column by column from right to
left and in the column bottom up,
but attached sheet tells me - already with 4 operands - it's somehow not a
fixed one-way work through the stack, and additional reacting on free cells
between the operands,
this blocks:
ex$el compatibility,
any efforts to gain better results by operand ordering, what can! be done in
ex$el,
thus in this point calc is weak against excel, and weak in itself, which may
contribute to plenty other irritations,
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
