Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Over-ride automatic subscripting (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: Over-ride automatic subscripting
#22
Helen_Miller (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Over-ride automatic subscripting 1 Year, 4 Months ago Karma: 13  
Is there anyway to over-ride automatic subscripting when equations are named. I want to have a equation name of q" for a heat transfer calculation and the " character is always being subscripted. Thanks for any help.<br><br>Post edited by: Helen_Miller, at: 2007/02/16 14:21
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#25
JohnDoyle (Admin)
Admin
Posts: 400
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:Over-ride automatic subscripting 1 Year, 4 Months ago Karma: 469  
When an equation is 'named' they are forced to end with the two character " =". Then XLC knows that it is a named cell and it will enforce automatic subscripting. Automatic subscripting forces all characters after the first character to be subscripted. Automatic subscripting is very important particularly if you remove multiplication signs in equations failure to use automatic subscripting could produce ambiguous equations.
I can see in your case that q" could be useful and I suggest you use the following work-around. Enter 'q"=' into the cell (make sure that it is not 'q" =' i.e. missing the space character). Then the cell will not be automatically subscripted.
I may have laboured the point here - delete the space character before the equals character and it will never again be automatically subscripted.
 
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.
#27
Helen_Miller (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Over-ride automatic subscripting 1 Year, 4 Months ago Karma: 13  
Thanks Bo your work around does the trick for me.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply