Issue 104657 - problem sorting cells with formula
Summary: problem sorting cells with formula
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1
Hardware: PC Windows Vista
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-08-31 17:04 UTC by telemaco
Modified: 2009-09-01 12:34 UTC (History)
1 user (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 telemaco 2009-08-31 17:04:53 UTC 
I have imported a txt file (136 rows)
columns 1,2 contains text
column 3 contain a date
column 4 contain text with numbers (es. "12,8MB") without quote
column 4 is not completely filled
in column 5 I have entered this formula :=VALORE(SINISTRA(D1;LUNGHEZZA(D1)-2)).
I thing it is in english:=value(left(d1;length((d1)-2))
fill down column 5
where cells of column d are empty, in column E result ERR502.
for fast delete formulas with error, I have sorted for column D (up) and column
C (up). (linked ods file is stopped at this point)
after deleted some cells with err502, i tried to sort for column C only.
surprise!
next to some cells not empty in column D, I find err502, and the formula not
refers to cell on the same row, but elsewhere.

on ubuntu 9.04 with openoffice 3.0 it's OK

the ods file is at http://www.dcnet.it/public/badsort.ods
Comment 1 Stefan Weigel 2009-09-01 12:33:53 UTC 
Duplicate of #101690

Fixed in OOo 3.1.1

*** This issue has been marked as a duplicate of 101690 ***
Comment 2 Stefan Weigel 2009-09-01 12:34:42 UTC 
Closing duplicate.