To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103556 Issue #|103556 Summary|Some characters make the change between Absolute refer |ence and Relative reference by SHIFT+F4 impossible Component|Spreadsheet Version|DEV300m52 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|amy2008
------- Additional comments from [email protected] Wed Jul 15 05:43:38 +0000 2009 ------- Can reproduce it in OOo3.0 Pls download the attachment for checking. In the attachment, can find function: =VLOOKUP(A7;'a-a'.A1:B5;2;0) a-a is the sheet name which contains a special character, you can also name the sheet as a&a or a^a that contains special characters like "-(){}&^". Select A1 in VLOOKUP, Shift + F4, find it is no change. But if select 'a-a'.A1, Shift + F4, it becomes absolute reference "$'a-a'.$A$1"(without quotes). If rename the sheet "a-a" as "sheeta", then select A1 (not 'sheeta'.A1), Shift + F4, 'sheeta'.A1 becomes absolute reference "$'sheeta'.$A$1"(without quotes). IMO, it works well. What I want to say is sheetname which contains the special characters or not should gives users the same result. Regards Li Meiying --------------------------------------------------------------------- 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]
