https://bugs.freedesktop.org/show_bug.cgi?id=65637
--- Comment #12 from Dominique Boutry <[email protected]> --- Going back to the specification : I suppose that SORT works like in EXCEL : - generally speaking, when one moves a cell (let's say from B2 to C2), B2 is updated to C2 in all formulas (all cells) containing "B2", - as an exception, if cell B2 moves due to a SORT, B2 is not updated in all formula containing "B2". So the formulas of the "sum" column in the attachments (whichever in another sheet or the same) are rightly unchanged after the SORT. Please examine the formula on the last line : "=SI(NBVAL(A8:B8)>0;SOMME(A8:B8);NA())". To narrow the pb, I add a NBVAL-only column and a SOMME-only column : both evaluates to the value of A8:B8 before the SORT. Editing these formulas (by adding "+0" at their end) forces a reevaluation, which is then right. To summarize : recomputing of values after a SORT sometimes use values BEFORE the SORT (cached ?). Bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
