https://bugs.freedesktop.org/show_bug.cgi?id=55048
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Jean-Baptiste Faure <[email protected]> --- In fact this bug report ask for the same problem as bug 81309. It works without using absolute references in version 4.3.4.0.0+ and 4.4.0 alpha but not in versions 4.2.6, 4.1.6 and 4.0.6. Version 4.2.6 gives a result that differ from version 4.1.6 and 4.0.6. What is surprising me is that it works in 4.4.0 alpha whatever the choice made for the configuration option "Update references when sorting range of cells". That said I share the decision of Pierre-Yves in comment #3 if we assume that the range A8:E32 is fixed data and the range A1:E5 is the part dedicated to the computations. Even if the range dedicated to data must evolve, for example adding rows in each subpart, then subtotals (currently E14, E23 and E32) will be moved and the references in A1:E5 must be updated accordingly. Even when absolute references are used in A1:E5 they are updated. For me still NotABug, the right way is to use absolute references when needed. Best regards. JBF -- 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
