Apache OpenOffice (AOO) Bugzilla – Issue 86599
Calc crashes, spreadsheet data corruption deleting rows in autofilter
Last modified: 2008-03-04 12:16:54 UTC
Platform tree@MARVIN:~$ apt-cache showpkg openoffice.org-core Package: openoffice.org-core Versions: 1:2.3.0-1ubuntu5.3 tree@MARVIN:~$ uname -a Linux MARVIN 2.6.22-14-generic #1 SMP Tue Feb 12 07:42:25 UTC 2008 i686 GNU/Linux Description Deleting rows while in autofilter mode causes calc to crash and corrupts data in the spreadsheet. Reproduced using two different spreadsheets. Occurs if the spreadsheet is sorted or unsorted. Spreadsheet 106 rows of data 9 columns of data columns contain multiple formats: text, dates, currency, numbers and formulas. 1) Set autofilter. 2) Filter on any element in column 3) Select all rows by clicking on row number, holding shift, selecting last row. Rows may be contiguous, ie. 1-7, or non-contiguous, ie. 1,3,5,7. 4) Right mouse click, click Delete Rows 5) Unfilter by clicking on column, select "all". After navigating a few seconds, using sidebars, calc crashes. 6) Recovery starts. Recovery successful. 7) Data is corrupted. Deleted rows still exist. Formulas based on cells in previously deleted rows error. Example, Col.B is a date field. Col.C previously contained the formula, "MONTH(B1)", now cell contains "MONTH(B#REF!)" and evaluates as "#NAME?".
Created attachment 51839 [details] deleting rows while autofilter results in calc crash and data corruption
Sounds pretty much like yet another incarnation of infamous Ubuntu madness. This is not an upstream issue, please check the Ubuntu bug tracking system. *** This issue has been marked as a duplicate of 82341 ***
Closing.