Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Equation Rendering Problem (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Favoured: 0
TOPIC: Equation Rendering Problem
#3137
Jake.B (User)
Froglet (Expert Boarder)
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Equation Rendering Problem 5 Years, 4 Months ago Karma: 2  
Hello team,

I have spent the day converting a calculation I had completed in MATHCAD over to Excel + XLC.

Overall, I am very happy with the results. The equations are generally very presentable and the ability to show working is a big advantage over Mathcad IMHO.

I do however have one problem as shown in row 128 of the attached calculation. I have a moderately complicated formula which requires me to take the square root. XLC seems to be having some trouble parsing the equation and formulating an appropriately rendered image of the equation.

Would someone mind having a look and offering some advice?

Many thanks,
Jake
File Attachment:
File Name: Bored_Pier_RevB.xlsm
File Size: 206229
 
Logged Logged  
  The administrator has disabled public write access.
#3138
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1778
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:Equation Rendering Problem 5 Years, 4 Months ago Karma: 494  

Oh dear this has not worked out well at all. It has been a long time since we have had an equation rendering issue to investigate but this certainly seems a worthy case. Please give us a little time to investigate. Thank you very much for reporting this in. In the meantime as a work around may I suggest that you break your equation into parts.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3139
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1778
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:Equation Rendering Problem 5 Years, 4 Months ago Karma: 494  
I have had no problems in building the equation from scratch (see below):

However when debugging you worksheet I have noticed that there are some strange carriage return characters that somehow seem to have crept in. I am at a loss to understand how this has happened and I am still investigating the problem further.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3140
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1778
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:Equation Rendering Problem 5 Years, 4 Months ago Karma: 494  
I have been searching for how the code could introduce these carriage return characters and not finding an answer. But I see that they have been introduced by you. Looking in the formula bar I can see you have carriage return characters:

Simply remove these characters and all the rendering problems will disappear.
 
Logged Logged  
 
Last Edit: 2013/09/23 10:33 By JohnDoyle[Admin].
 
  The administrator has disabled public write access.
#3141
Jake.B (User)
Froglet (Expert Boarder)
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Equation Rendering Problem 5 Years, 4 Months ago Karma: 2  
Hi John,

Thank you very much for solving this one for me. I generally break up my equations into logical blocks to make it easier to see what is happening. It is a relatively easy fix to write it all as one line so will do this going forward. Sorry to cost you so much time tracing the cause of this one down.

Regarding the vertical alignment of the + operator in the equations below, they seem to be a little high (top line by the looks of it). I assume this is just how excel renders equations?

Thanks again John, greatly appreciated.

Regards Jake
 
Logged Logged  
  The administrator has disabled public write access.
#3142
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1778
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:Equation Rendering Problem 5 Years, 4 Months ago Karma: 494  
Jake
There is an equation setting for this too. You can change the default setting using 'XLC Setting' button. Change the 'Equation vertical alignment' from 'top' to 'mid'
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 9 guests and 40 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Real Time Analytics