Cells not named (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: Cells not named
|
|
|
|
Cells not named 1 Year, 6 Months ago
|
Karma: 1
|
|
Hi All,
I'm having some issues, when I go to "show formula" with the "named" cells, not showing up as a named cell. It seems to correct the problem if i put a space between the letter and equal... "X =" instead of "X=". The thing is, it doens't happen all the time.
Thanks!
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Cells not named 1 Year, 6 Months ago
|
Karma: 470
|
|
If you attach your spreadsheet I'll take a closer look.
|
|
|
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Cells not named 1 Year, 6 Months ago
|
Karma: 470
|
|
I have done a quick test and it seems you are correct. If a named cell is one character long there must be a space before the = sign. This is a bug I'll put it on my 'ToDo' list in the mean time you will have to use "x =" and not "x=". Please note that for names longer than one character you can omit the space when you want to tell XLC not to automatically subscript the name.
|
|
|
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Cells not named 1 Year, 6 Months ago
|
Karma: 470
|
|
Wes616, I have fixed the bug - download and install the latest version. Thanks for reporting this in - it helps to make the code more robust for all users.
|
|
|
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Cells not named 1 Year, 6 Months ago
|
Karma: 1
|
|
Thanks John!
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|
Forum 
