View unanswered posts | View active topics It is currently Thu Nov 26, 2020 11:28 am



Reply to topic  [ 3 posts ] 
 Fixture ID 
Author Message
active user

Joined: Fri Jan 22, 2010 5:47 pm
Posts: 63
License: Unlimited
Interface: 2048X
Videocard: Radeon HD4870 x2
Reply with quote
HI LC.

Is it possible to change the Fixture ID.

I am creating a Worksheet in Vectorworks 2009 to export the fixtures information.
The only problem is the fixture ID. The id is not recognized in Excel.
When I kopy the next fixture ID: 2:0103 to Excel it makes 0,1555
I ve I pud a comma like this: '2:0103 in exel it gives a error in LC when i import the Excel sheet.

What I wound is creating a own libery in Vectorworks whit the Fixture ID of LC

HOpe you can help me :D


Mon Aug 23, 2010 6:26 pm
Profile
architector
User avatar

Joined: Thu May 05, 2005 11:02 pm
Posts: 3111
Location: Kiev, Ukraine
License: Unlimited
Videocard: TitanX
Reply with quote
The user ID should be in range 1-65535 or 1.0-99.999


Mon Aug 23, 2010 10:30 pm
Profile WWW
user
User avatar

Joined: Wed Oct 14, 2009 12:22 am
Posts: 25
Location: NYC, USA
License: Unlimited
Videocard: AMD RADEON R9 290X 4
Reply with quote
I cannot be of much help on the LC end of things, but if you are having trouble with MS Excel changing the format of the numbers in the cell, I can probably help with that.

It may be because Excel is treating the information in the cells in the "General" format. This means that if there is a formula or command in the cell, Excel is compute the formula or execute the command. For example, if I entered "09/29/10", it would assume that I am entering a date. When cells' format is "General", Excel also removes any zeros that appear before the rest of a number: "001" becomes "1".

To make all of these things NOT happen, try changing the cell format to "Text" or to "Number" to get the appropriate response.

You can change this option by selecting the cells, columns or rows, then right-clicking and selecting "Format Cells". You can also access the "Format Cells" dialog box from the menu: "Format", "Cells".

FYI, once Excel changes the contents of a cell because of the cell format option selected, you cannot always get the original contents of that cell back. Save your work before you experiment.

I hope that helps.

_________________
Teresa Hull
Visual Workhorse, Inc.


Wed Sep 29, 2010 3:58 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software for PTF.

© L8 LLC l8.ltd         lc.ua