https://bugs.freedesktop.org/show_bug.cgi?id=77080
Priority: high
Bug ID: 77080
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Area of summation (and of other formula) is changed in
wrong manner when inserting rows
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: stef...@michalek.de
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
When inserting rows in some distance to the cell containing summation, then the
summation area is changed in severely wrong manner - totally unexpected.
See examples (calc files and screenshot)
1) Summations in row 5 and in row 9 (each column E)
2) Marking some row numbers at the left border and choosing "insert rows" in
the right-mouse-click context menue (and inserting nummer "5" in one of the new
cells) shows correct and expected behaviour: the summations are not affected.
3) Marking as much row numbers at the left border, that row 5 also is marked
(to insert 4 rows above former row 3) - then the summation area is enlarged,
wrongly including rows 5 to 8 (new counting), even though rows 7 and 8 are not
changed, only transferred downwards.
Expected behaviour: row 9 is not changed, relative adresses in the summation
should still relate only to this row itself (before: row 5, afterwards: row 9)
with no change into an rectangle area.
4) Marking more row numbers at the left border and choosing "insert rows" leads
to an even stranger behaviour: the summation area is enlarged, containing other
blocks of numbers now.
I proposed severity "major" and priority "high", since this behaviour really
affected some complex spreasheets of mine during the last months.
1) Totally wrong numbers arised (apparently in random manner)
2) It was not easy to identify the source of that confusion.
3) And even with that knowledge now - it is still much work to check all
summations within the spreadsheet that could have been affected when inserting
some rows.
--
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
