Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Cells not named (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 0
TOPIC: Cells not named
#242
wes616 (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Cells not named 1 Year, 2 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!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#243
JohnDoyle (Admin)
Admin
Posts: 409
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Cells not named 1 Year, 2 Months ago Karma: 470  
If you attach your spreadsheet I'll take a closer look.
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#244
JohnDoyle (Admin)
Admin
Posts: 409
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Cells not named 1 Year, 2 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.
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#252
JohnDoyle (Admin)
Admin
Posts: 409
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Cells not named 1 Year, 2 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.
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#281
wes616 (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:Cells not named 1 Year, 2 Months ago Karma: 1  
Thanks John!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop