https://bugs.documentfoundation.org/show_bug.cgi?id=106763
Bug ID: 106763
Summary: EDITING
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dloch...@d2.net.au
Created attachment 132138
--> https://bugs.documentfoundation.org/attachment.cgi?id=132138&action=edit
Four rows are adjusted correctly or not, as noted in the comments.
This bug is so simple I wonder whether I misunderstand something but, if not, I
think it's critical. It may be related to #42261 from Winfried Donkers.
The attachment illustrates the problem. The four rows 6-9 containing value "1"
are summed with =SUM($B$6:$B$9). If one right-clicks on row-5 "Add Rows Above"
the formula is correctly adjusted to =SUM($B$7:$B$10). However the same
operation on row-6 results in the formula =SUM($B$6:$B$10) which sums five
rows. I would expect it to also adjust the range to $B$7:$B$10.
This problem was first identified when a macro using:
oActSheet.insertCells (oCellRangeAddress,
com.sun.star.sheet.CellInsertMode.ROWS)
failed to work as expected though in a more complex way.
Regards,
David Lochrin
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs