To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104657 Issue #|104657 Summary|problem sorting cells with formula Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|code Assigned to|spreadsheet Reported by|telemaco
------- Additional comments from [email protected] Mon Aug 31 16:04:53 +0000 2009 ------- 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 --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
