hong Posted February 23, 2005 Share Posted February 23, 2005 I made a linear object and had to read default linelength data to worksheet. On my object pane, I see linelength following unit setup per file which is ft-in. But in worksheet it all comes in as inches. Is this the way it is? If so, is there a way to convert to ft-in again in worksheet? Quote Link to comment
Guest Posted April 1, 2005 Share Posted April 1, 2005 When the Units are set to "Feet and Inches", the worksheet reports dimensions in Inches. This is the way it has always been. You can setup a formula for a worksheet cell to display a value in feet, but it will assume that Units are set to "Feet and Inches" and will fail if the user changes the Units setting to something else. If there is a linear plug-in object named "MyScale" in the drawing and you use Create Report to create a worksheet that lists those objects, then the following worksheet cell formula will display the length in feet and inches, not inches. =((MyScale.LineLength)/12) The Number format for the cell must be set to Dimension also. This should display 2'3 3/4" instead of 27.75. Jeff Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.