Issue 102065 - Sort not properly moving formulas with associated data
Summary: Sort not properly moving formulas with associated data
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-05-19 15:06 UTC by jtahrens
Modified: 2009-05-19 20:01 UTC (History)
2 users (show)

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


Attachments
Prepopulated data to illustrate sort issue (25.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-19 15:08 UTC, jtahrens
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jtahrens 2009-05-19 15:06:23 UTC
It appears the Sort function does not always copy the proper formulas with
certain columns when doing a sort.

To replicate:

- Open the attached file.
- Notice that row 1 (Lowe's) column D has formula "=-C1/2"
- Notice that row 30 (Seattle City Light) column D has the formula "=-C30/2"
- Select cells A1 - E30
- From the Data menu, select Sort
- in the Sort By drop down, select "Column B", Ascending
- in the Then By drop down, select "column A", Ascending
- Click OK

- Notice "Seattle City Light" moved to row 28. The You would expect the formula
to now be "=-C28/2", but it is not.
- Notice "Lowe's" has moved to row 4, but the formula in column C now says
"-C19/2" (you would expect "-C4/2")
Comment 1 jtahrens 2009-05-19 15:08:00 UTC
Created attachment 62373 [details]
Prepopulated data to illustrate sort issue
Comment 2 Regina Henschel 2009-05-19 20:00:58 UTC
duplicate to issue 101690.

*** This issue has been marked as a duplicate of 101690 ***
Comment 3 Regina Henschel 2009-05-19 20:01:24 UTC
closing duplicate