Apache OpenOffice (AOO) Bugzilla – Issue 103556
Some characters make the change between Absolute reference and Relative reference by SHIFT+F4 impossible
Last modified: 2013-01-29 21:50:00 UTC
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
Created attachment 63553 [details] reference