Issue 82015

Summary:

Cell's references lost when ordering

Product:

Calc

Reporter:

pjimenezo <pjimenezo>

Component:

code

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 2.0

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Example	none

Description pjimenezo 2007-09-27 13:30:29 UTC

When ordering rows that in some of the cells contain references to cells that
are within the ordered rank, those references correctly do not stay, without
mattering if they are absolute or relative. For example:
________________________
| | A | B | C |
------------------------------------------
| 1 | Australia | = C3 | valor1 |
------------------------------------------
| 2 | Canada | = C1 | valor2 |
------------------------------------------
| 3 | Belgium | = C2 | valor3 |
------------------------------------------

If we ordered alphabetically by the column "A", we obtain:
________________________
| | A | B | C |
------------------------------------------
| 1 | Australia | = C3 | valor1 |
------------------------------------------
| 2 | Belgium | = C1 | valor3 |
------------------------------------------
| 3 | Canada | = C2 | valor2 |
------------------------------------------
where one sees that the formulas of column B have not moved when ordering.
If we had worked with absolute references, after ordering we had obtained
exactly the same, the formulas remain where they are. On the other hand, if the
references are external to the rank that is ordered, everything goes well, but
if soon we ordered that other rank of cells, the references return to disorder
themselves.

Comment 1 pjimenezo 2007-09-27 13:36:21 UTC

Created attachment 48549 [details]
Example

Comment 2 frank 2007-11-22 13:39:13 UTC

this sounds like a double or at least related to Issue 81349 . Therefore closed
as such.

Frank

*** This issue has been marked as a duplicate of 81349 ***

Comment 3 frank 2007-11-22 13:39:34 UTC

closed double