Issue 105588 - Formulas inside an area are not reassigned when you sort that area by a column
Summary: Formulas inside an area are not reassigned when you sort that area by a column
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 3.1
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-10-04 12:33 UTC by yamirhorta
Modified: 2009-10-04 18:05 UTC (History)
2 users (show)

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


Attachments
Example of how to see the error submited (12.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-04 12:37 UTC, yamirhorta
no flags Details
bugdoc showing correct sort (12.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-04 14:34 UTC, tomwb
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description yamirhorta 2009-10-04 12:33:27 UTC
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
Comment 1 yamirhorta 2009-10-04 12:37:07 UTC
Created attachment 65117 [details]
Example of how to see the error submited
Comment 2 tomwb 2009-10-04 14:33:29 UTC
Sorts ok using using OOO311 en_US on Vista SP2.

Attaching bugdoc showing correct sort.

TomW
Comment 3 tomwb 2009-10-04 14:34:29 UTC
Created attachment 65122 [details]
bugdoc showing correct sort
Comment 4 Regina Henschel 2009-10-04 18:04:49 UTC
Yes, that is a bug in OOo3.1. It has already been fixed in OOo3.1.1. Please use
the newest version of OOo. http://download.openoffice.org/index.html

*** This issue has been marked as a duplicate of 101690 ***
Comment 5 Regina Henschel 2009-10-04 18:05:35 UTC
closing, duplicate and already fixed