Issue 103556 - Some characters make the change between Absolute reference and Relative reference by SHIFT+F4 impossible
Summary: Some characters make the change between Absolute reference and Relative refer...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: DEV300m52
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Blocks: 84405
  Show dependency tree
Reported: 2009-07-15 06:43 UTC by amy2008
Modified: 2013-01-29 21:50 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

reference (7.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-15 06:45 UTC, amy2008
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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]