https://bugs.documentfoundation.org/show_bug.cgi?id=89402
--- Comment #3 from Wolfgang <j...@psilosoph.de> --- Tested with V 4.4.0.3 on Windows 8.1 here The bug was discussed under a different aspect in http://en.libreofficeforum.org/node/10277. There was first disclosed an issue with the specification under http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.pdf#page=47&zoom=auto,129.6,606.8 . In compliance with this specification the formula did not include the content of the adjacent cell above it after insertion of a row immediately above the formula and entering a number into the new empty cell of the same column. After save/reload or after minimal editing of the formula without changing it the new addend was included. This is not clearly a bug but in any case a flaw of the specification. Behaviour unchanged insofar since StarOffice 5.2. ( I did, of course not check with all the versions since.) "Recalculation of the formula containing an automatic range not triggered by the insertion of a row." NOT in compliance with the specification is the observation of @m.a.riosv that insertion of a row breaking up the range already added and entering a number into the gap created will recalculate the sum - but now exluding the addend immediately above the formula. See attached for more detail. Please try again! It should not be likely that this is restricted to the Win build. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs