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