Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Re:Division line in the formula with OVD()/UND() (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:Division line in the formula with OVD()/UND()
#1165
mguter ()
User Offline Click here to see the profile of this user
Division line in the formula with OVD()/UND() 3 Months, 4 Weeks ago Karma: 1  
Division line does not display in the formula with OVD()/UND() or displayed as an arrow. What do I do wrong?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1166
JohnDoyle ()
Please support us with an XLC Pro Subscription.
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:Division line in the formula with OVD()/UND() 3 Months, 4 Weeks ago Karma: 470  
You have to attach a spreadsheet showing the problem so I can investigate.
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/07/24 00:51 By JohnDoyle.
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#1167
mguter ()
User Offline Click here to see the profile of this user
Re:Division line in the formula with OVD()/UND() 3 Months, 4 Weeks ago Karma: 1  
I am resending the file. I am not sure if my previous post went through.
File Attachment:
File Name: OVD.xls
File Size: 340480
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1170
JohnDoyle ()
Please support us with an XLC Pro Subscription.
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:Division line in the formula with OVD()/UND() 3 Months, 3 Weeks ago Karma: 470  
I am back in the office on August 11th - I'll get back to you then when I can investigate this fully.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#1173
mguter ()
User Offline Click here to see the profile of this user
Re:Division line in the formula with OVD()/UND() 3 Months, 3 Weeks ago Karma: 1  
I think I figured it out.
The line representation depends on Autoshape Defaults Settnig.
Here is the new one: when there are two or more radicals with OVD/UND in the equation, they loose part of the sign (except the last one) - see attached file.
File Attachment:
File Name: SQRT_missing_line.xls
File Size: 22016
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1179
JohnDoyle ()
Please support us with an XLC Pro Subscription.
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:Division line in the formula with OVD()/UND() 3 Months, 1 Week ago Karma: 470  
Well done mguter you have found a bug for me. I have managed to fix the problem and I'll include it in the next release of XLC. It may be a few weeks before I can manage to get it out - I am just back from my summer break with a mountain of work to clear. Please bear with me and thanks again for reporting in the problem.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop