https://bugs.freedesktop.org/show_bug.cgi?id=78991
Roberto Fontes <robertofontescam...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |REOPENED
--- Comment #2 from Roberto Fontes <robertofontescam...@gmail.com> ---
Problem Description
When inserting more then one rows before a row containing the sum function, the
sum function automatically includes the number of rows inserted in the range to
be added in the function.
Steps to Produce
1. I position the cursor on cell A5, I select three lines from this line (5)
down, ie, lines 5, 6 and 7.
2. A6 cell contains the following arguments: SUM(A7:A10)
3. I click with the right mouse button on the selected range and choose the
option "insert - entire line" or "insert rows above".
4. Three lines were inserted blank, the contents of lines 5,6 and 7 were
automatically to lines 8, 9 and 10 respectively.
5. The A9 cell went on to inform the following error: ERROR:522.
6. When you click on the A9 cell, the argument of the SUM function
automatically changed to "SUM(A7: A13)".
Current behavior:
SUM(A7:A13)
Expected behavior:
SUM(A10:A13)
Operating System: Windows 7
Version: 4.2.4.2 release
Sorry for my english. I speak very little English. I am a Brazilian citizen and
I speak my language fluently: Portuguese of Brazil.
--
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
