Issue 104067 - CALC Data Sort Problem
Summary: CALC Data Sort Problem
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-08-06 21:47 UTC by jedunnjr
Modified: 2009-08-07 06:54 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jedunnjr 2009-08-06 21:47:00 UTC 
I just upgraded to OpenOffice version 3.1.  In sorting a table of rows, CALC
does not now update formulas in the row.  For example, say row 95 was created
with a formula such as (F95-E95)/D95.  The table is sorted and the just created
row ends up as row 8.  The formula remains (F95-E95)/D95 resulting in the wrong
value being displayed.  In 3.0.1 and in Microsoft Excel, the equation is updated
to: (F8-E8)/D8.
Comment 1 Rainer Bielefeld 2009-08-07 06:52:23 UTC 
Known problem.

*** This issue has been marked as a duplicate of 101690 ***
Comment 2 Rainer Bielefeld 2009-08-07 06:54:03 UTC 
@jedunnjr:
Thank you for your attention!