To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110588
------- Additional comments from [email protected] Sun Apr 4 10:45:06 +0000 2010 ------- I can see now that the issue is more complex, because of the behaviour of non-absolute links. Another file, example2.ods is attached below. Select A3:D10, then choose Data|Sort, choose Column A. This has links to other cells in the same sheet. These links are in column B. The consequence of the sort algorithm is to change the links in this case, because they maintain a fixed offset to the cell containing the link. (Sort by column C to reset this sheet). The sort routine seems to have different rules for movings different types of links, but it is unpredictable for the user. As originally identified, non-absolute links to another file do not get moved at all by the sort routine when their row is moved. Perhaps the behaviours can be looked at. There is no warning to users of what rule is being applied, and it can even vary within a single sort event. The most obvious way a sort should work is to move whole rows together, not altering the source references of any links, just moving the cells containing the links with the row they are in. This is what a user would naturally expect to happen. However, are non-absolute links stored as offsets? If so, perhaps the offsets should be recalculated by the sort routine when moving rows? --------------------------------------------------------------------- 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]
