Issue 103556

Summary: Some characters make the change between Absolute reference and Relative reference by SHIFT+F4 impossible
Product: Calc Reporter: amy2008 <amy2008>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, ooo.redflag, peter.junge, zhuangyuelin
Version: DEV300m52Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 84405    
Description Flags
reference none

Description amy2008 2009-07-15 06:43:38 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.

Li Meiying
Comment 1 amy2008 2009-07-15 06:45:30 UTC
Created attachment 63553 [details]