Issue 103419 - Sorting data has problems when empty records are present (formulas)
Summary: Sorting data has problems when empty records are present (formulas)
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-08 17:12 UTC by sapid
Modified: 2009-07-21 09:20 UTC (History)
2 users (show)

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

Attachments
Timing data from iTunes download. Sort error when blank rows are included. (16.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-08 17:14 UTC, sapid 		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 sapid 2009-07-08 17:12:08 UTC 
I have a table with open rows to separate sections.  When I sort, some formulas
then refer to incorrect cells.  There is no problem when the data records are
contiguous. In the attached file there are two worksheets, one with delineated
sections and the other, contiguous records.  Select the data then sort by KB/s.
 The formulas refer to the wrong row.  The problem starts at row 14, the row
where the first blank line was in the unsorted data.
Comment 1 sapid 2009-07-08 17:14:36 UTC 
Created attachment 63439 [details]
Timing data from iTunes download.  Sort error when blank rows are included.
Comment 2 kpalagin 2009-07-21 09:19:33 UTC 
Seems to be dup of http://www.openoffice.org/issues/show_bug.cgi?id=101690

*** This issue has been marked as a duplicate of 101690 ***
Comment 3 kpalagin 2009-07-21 09:20:03 UTC 
closing dup.