markj Posted March 19, 2008 Share Posted March 19, 2008 Here is another mystifying anomaly with vw2008; I have some custom made tools which draw objects, and then write a record into a worksheet to create an object count/item list. The bit that does this is;- setrecord(LnewObj,rfs); SetRfield(Lnewobj,rfs,'Item Code','POST/TS/W'); SetRfield(Lnewobj,rfs,'Description','Tall Post-Square, Wood'); SetRfield(Lnewobj,rfs,'Material','Wood'); The thing all works fine (& always has done!)and fills out the worksheet properly. The problem arises when I try & export the data. When I copy the columns from the worksheet & paste them into an excel spreadsheet, I get an extra blank line between each line of data, which messes up the excel calculation. To make sure it is not an excel problem, I paste the worksheet columns into a word document - you get the same double line spacing. If I paste into notepad it works fine, with no extra lines. Incidentally the 'Export Data' function works OK, and writes a notepad document correctly also. Pasting into a google spreadsheet also produce the double line spacing. This problem only seems to happen with vw2008 on a PC. It was OK with v12.5, and doesn't cause any problems with a mac. Any ideas where the problem lies? Thanks Mark Quote Link to comment
Vectorworks, Inc Employee Hugues Posted March 19, 2008 Vectorworks, Inc Employee Share Posted March 19, 2008 Hi Mark, Thank you for pointing this out. This looks like a text encoding bug in the clipboard. There is nothing wrong on your side. Use the "Export Worksheet" command for now. Thanks Hugues NNA Quote Link to comment
markj Posted March 20, 2008 Author Share Posted March 20, 2008 Thanks for looking! - The 'Export Worksheet' & 'Import Data' into Excel is longwinded & a pain, especially if there are several worksheets on the drawing. It is so much easier to simply copy & paste the data direct. I guess I'll have to copy & paste into notepad and then copy & paste from there into the excel sheet, (which sort of defeats the object of our rather nifty CAD/Excel system!). Thanks again Mark 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.