To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104038 Issue #|104038 Summary|Sort algorithm in Calc Component|Spreadsheet Version|OOO310m1 Platform|PC URL| OS/Version|Windows NT Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|jackaroo
------- Additional comments from jacka...@openoffice.org Wed Aug 5 23:47:51 +0000 2009 ------- Having selected an area of data (say A4:E20), where column E contains a formula (in this case, A[n] (Date) plus seven, so "the week from the date in column A"), sorting mixes up the formulas in column E. That means, that in the "new" (after sorting) row 15 I find in column E the formula "$A[row<>15]+7". The result is correct for the other row, but that does not help much... So, if I sort the named area of data by column D, for example, the order of all "fixed" data (like text, dates and numbers) rows is correct; yet the references in the E-column containing the formula are a haddock... - Providing obviously false results. I have that on my office PC with Win XP and OOo 3.1. It is reproducable, but I had not had the time yet to see whether I can find a "system in irregularity" here. - Here at home, I run Ubuntu Linux with OOo 2.4 (shame on me, I know), and the same procedure brings the expected result. I made this a "P1"-priority, because this one has hit me unprepared in an important presentation and I was in no way aware of it then. - I want to save others from this experience...! I have searched the archives but found no similar reports. The .ods file can be provided if that helps; I'd like to alter some of the "fixed" data in it first, because it is "life company business". - I will continue examination on my side; unfortunally, at the moment, I don't have too much time left do do that. Thanks in advance, everybody! --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
