To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105588
Issue #|105588
Summary|Formulas inside an area are not reassigned when you so
|rt that area by a column
Component|Spreadsheet
Version|OOo 3.1
Platform|PC
URL|
OS/Version|Windows, all
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P1
Subcomponent|viewing
Assigned to|spreadsheet
Reported by|yamirhorta
------- Additional comments from yamirho...@openoffice.org Sun Oct 4 11:33:27
+0000 2009 -------
When you try to sort an area with formulas inside it, then the formulas are not
reassigned.
See example bellow:
- The unsorted area has 8 rows (alternating one filled and one blank)
- The area has 4 columns:
column A with the key I need to sort
column B and C with values
column D with a formula pointing to B and C (ie =B1*C1)
- When you select that area A1:D7 and sort it by column A, then the formulas
in column D are not reasigned propertly. They remain with the original values.
The result in column D is then wrong, because the formulas area pointing to
other cells than the original ones.
This error was not present in version 3.0.
You can find bellow a copy/paste of the example document.
Mind column D has formulas pointing to column B and C (ie D1=B1*C1).
I'll try to attach an example calc-document.
Regards,
Yamir Horta
Unsorted area
The area I need to sort is marked bellow
Column D has some formulas pointing to the area I need to sort
a 1 2 2
b 2 3 6
c 3 4 12
d 4 5 20
When I sort that area by column A, then the formulas in column D are not
reassigned,
so they remain untouched and the result ind column D is wrong
a 1 2 2
b 2 3 12
c 3 4 0
d 4 5 0
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
