https://bugs.freedesktop.org/show_bug.cgi?id=78856
Priority: medium
Bug ID: 78856
Assignee: [email protected]
Summary: Malfunction insertCells/insertRows and sum function in
spreadsheet
Severity: critical
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: NEW
Version: 4.2.4.2 release
Component: BASIC
Product: LibreOffice
Created attachment 99271
--> https://bugs.freedesktop.org/attachment.cgi?id=99271&action=edit
the attached spreadsheet demonstrates the bug, pls run the script BugDemo
Since several years I am using a LibreOfficeBasic - script to manage my stock
account.
After the installation of XUBUNTU 14.04 (LibreOffice 4.2.3 – rc3 – 0ubuntu2)
there was a malfunction. It persists when I changed to LibreOffice 4.2.4.2 from
the LibreOffice-Homepage.
The bug occurs in connection with the methods
Sheet.insertCells(CellRangeAddress, com.sun.star.sheet.CellInsertMode.DOWN)
or
Sheet.Rows.insertByIndex(x,y)
and
the sum-function.
Given a spreadsheet table with blocks of rows containing the same numbers of
rows and the sum-function for each column of the block in the last rows of a
block. If you want to insert free space on top of the table in order to insert
a new block using one of the above mentioned methods the blocks will be moved
down and the cell addresses in the sum-function should be changed accordingly.
That is true for the second and all following blocks but not for the first one.
The start address of this sum-function is not affected by the movement of the
block.
--
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
