Issue 86599 - Calc crashes, spreadsheet data corruption deleting rows in autofilter
Summary: Calc crashes, spreadsheet data corruption deleting rows in autofilter
Status: CLOSED DUPLICATE of issue 82341
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-03-01 18:51 UTC by mmarseglia
Modified: 2008-03-04 12:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
deleting rows while autofilter results in calc crash and data corruption (18.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-03-01 18:52 UTC, mmarseglia 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description mmarseglia 2008-03-01 18:51:26 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?".
Comment 1 mmarseglia 2008-03-01 18:52:41 UTC 
Created attachment 51839 [details]
deleting rows while autofilter results in calc crash and data corruption
Comment 2 ooo 2008-03-04 12:16:23 UTC 
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 ***
Comment 3 ooo 2008-03-04 12:16:54 UTC 
Closing.