Yes, I have also experienced this.  In addition to crashing the
spreadsheet data is also corrupted.

Platform
[EMAIL PROTECTED]:~$ apt-cache showpkg openoffice.org-core
Package: openoffice.org-core
Versions: 
1:2.3.0-1ubuntu5.3 

[EMAIL PROTECTED]:~$ 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?".

** Attachment added: "test spreadsheet.ods"
   http://launchpadlibrarian.net/12379876/test%20spreadsheet.ods

-- 
Remove rows when using Autocomplete crashes OpenOffice Calc
https://bugs.launchpad.net/bugs/123324
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to