Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Automatic Subscripting and Equation Numbering (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: Re:Automatic Subscripting and Equation Numbering
#210
zept (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Automatic Subscripting and Equation Numbering 1 Year, 2 Months ago Karma: 1  
Hi

I'm enjoying trying out an interseting add-in.

If I type "ud=" and use the name button, I don't get automatic subscripting as suggested (because there's no space before the equals sign)

If I type "u(d)=" and use the name button, I get the first bracket and the d subscripted, which wasn't what I intended.

I can go back and reformat the cell Format>Cells etc. but the above behaviour is unexpeceted.

Also how do I set, reset and turn off equation numbering?

cheers zept
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#211
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:Automatic Subscripting and Equation Numbering 1 Year, 2 Months ago Karma: 469  
Thanks for you first post zept and welcome to the site.
1) The name button simply formats a cell (i.e. automatically subscripts) it appends " =" to the cell and right justifies the cell. On every 'redraw worksheet equations' XLC will check that this cell continues to be formatted in this way. Most of the time this is the behaviour you need.
From time to time it is not what you need, your example being a good case of this. So now you need to name your cell manually and append it with "=" (notice that the space character is missing). XLC will not try to make this cell conform to the automatic subscripting standard. In your case enter "u(d)=" into the cell and right justify the cell if you want - that's it - you don't use the 'name' button at all. XLC will drag this name with the its particular format into equations. see the diagram below:

2) You will see that there is a formula in cell C3 containing an EQS() function. The parameters of this function for the equation control string. Change "EqnPrefix=Eqn." "EqnPrefix=" to turn off equation numbering. The defaults for the equation control string are set using the 'about XLC and settings' button.

I hope this helps.
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/01/11 16:16 By JohnDoyle.
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#213
zept (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:Automatic Subscripting and Equation Numbering 1 Year, 2 Months ago Karma: 1  
Thanks for that.

I've figured out the EQS settings but my settings dialog looks like this:

Which setting is which?

zept
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#214
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:Automatic Subscripting and Equation Numbering 1 Year, 2 Months ago Karma: 469  
Weird it should look like this:

Judging by the number of settings you have on the form you are running an old version of XLC. Try downloading and installing the latest version I have set the colours on the form as fixed colours rather than windows system colours in the latest version 06.07 so this should fix your problem. Thanks for reporting this in Zept!
 
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.
Go to top Post Reply