Issue 102065

Summary:

Sort not properly moving formulas with associated data

Product:

Calc

Reporter:

jtahrens <openoffice>

Component:

code

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues, rb.henschel

Version:

OOO310m11

Keywords:

oooqa

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Prepopulated data to illustrate sort issue	none

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