Issue 104067

Summary:	CALC Data Sort Problem
Product:	Calc	Reporter:	jedunnjr <jedunnjr>
Component:	programming	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, rainerbielefeld_ooo_qa
Version:	OOo 3.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	Unknown
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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!