Gaspar Potocnik Posted June 6, 2014 Share Posted June 6, 2014 Is there anyway to have dual dimensions in Reports? I'm looking to have X and Y coordinates of symbols in both meters and feet. Thanks Quote Link to comment
michaelk Posted June 6, 2014 Share Posted June 6, 2014 Yes. The worksheet will always want to show dimensions in document units. So you will need to do the conversion math. Imperial to metric is easy. It's just a conversion factor. Metric to imperial is more difficult, but not impossible. Basically it's like this: 1. Conversion factor to get inches. 2. ## DIV 12 to get feet 3. ## MOD 12 to get inches. Square this result and take the square root to avoid a negative value. (you don't want both the feet and inches to be negative) 4. Concatenate the two values with the imperial dimension formatting. I'll attach an example of each. If you want to see how it's done, there is a webinar that should be posted to VSS soon. Until then you can see it here: http://verysmallgroup.com/santa-barbara-vectorworks/movies-and-stuff/worksheet-webinar-3.html hth mk Quote Link to comment
Gaspar Potocnik Posted June 7, 2014 Author Share Posted June 7, 2014 Michael, thanks for your answer, made it happen. Just one thing, in your video you are using " , " to space the CONCAT values, that didn't work for me, I had to usa " ; ", the same you are using in your files, is that a version issue? Thanks again, and BTW great videos! Quote Link to comment
michaelk Posted June 7, 2014 Share Posted June 7, 2014 Gaspar Glad you got it to work. I've never heard of using a semi colon. Are you using a localized version? 2014? 2013? If you go to Paste Function? and then click on CONCAT, does the message at the bottom of the window say comma or semi colon? mk Quote Link to comment
Gaspar Potocnik Posted June 7, 2014 Author Share Posted June 7, 2014 I'm using 2014, don't if it is localized... When I go into the paste function it shows commas, but it doesn't work. Also, when I opened your file it had semi colons, not commas... Quote Link to comment
michaelk Posted June 7, 2014 Share Posted June 7, 2014 Is your version in Spanish or English? Quote Link to comment
Gaspar Potocnik Posted June 7, 2014 Author Share Posted June 7, 2014 English... Quote Link to comment
michaelk Posted June 8, 2014 Share Posted June 8, 2014 I looked at the file you sent back to me: Commas. Strange mk 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.