I am using 26 sheets each named after one letter of the alphabet, (i.e. A, B, C , D, E,…X, Y, Z).
A 27th sheet named “Alpha” is used to link to each page using “Insert Hyperlink” (or Ctl-K) with 26 cells each having one letter of the alphabet.
The purpose of this is that each page has a list of links of files to open, the name of each file starting with the letter assigned to the page on which it resides.
All of this works flawlessly except for the hyperlinks for the letter C and the letter R.
When I click on the link to the letter C, instead of going the the sheet C, it selects a Column in the “Alpha” page on which these links are. For the letter R, clicking on it selects a Row on the same sheet. So I deduct Calc is using C to refer to “Column”, and R to refer to a “Row” instead of the sheets named C or R.
Is this normal?
In “Insert Hyperlink” (or Ctl-K), is there a special character to avoid the target being interpreted as a column or row and only interpret a worksheet?
My workaround for the moment has been to rename the sheet “C” to “#C” and this works but it would be better if there is another way.
Sincerely,
Dan