https://bugs.documentfoundation.org/show_bug.cgi?id=97558
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from GerardF <[email protected]> --- Calc use the relative reference of your formula : In G51, you have F49-G50. Means =Substract cell above from the cell one cell left and one cell above. After sorting the formula do the same. This is the normal behavior of Calc. However, you can change this in Options : Go to Tools > Options > LO Calc > General, and check "Update reference when sorting range of cell". -- 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
