Jump to content
Developer Wiki and Function Reference Links ×

Problem with worksheets/clipboard?


markj

Recommended Posts

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

Link to comment
  • Vectorworks, Inc Employee

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

Link to comment

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

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...