Jump to content

WORKSHEET TUTORIALS


Recommended Posts

The criteria that you need you won't find in most tutorials.

* click on a cell

* To have the count of all sheet layer viewports paste in the edit bar: =COUNT(ST=506)

* To have the count of all design layer viewports paste in the edit bar: =COUNT(PON='NNA_DesignLayerViewport')

* To have the count of all symbols paste in the edit bar:

=COUNT(T=15)

* To have the count of all symbols named "Symbol-1" paste in the edit bar:

=COUNT(S='Symbol-1')

If you want more infos, you need to set up a database. Create a database:

* select a row on the left (where there is a row number),

* right-click on Win, or cntrl-click on Mac

* select the menu-item "Database"

* a "Criteria" dialog appears.

* confirm with "OK". It doesn't matter what you set listed, because you will override it now.

Now, and only NOW, you can see the criteria string for the database in the upper edit field.

You must edit that criteria string.

If you don't see the criteria string (because you clicked somewhere else by mistake, for example), you must call the menu item "Edit Criteria": after confirming the dialog (useless for you), then you can see and edit the string again.

The "Criteria" dialog is just for beginners, you don't get anywhere with that.

Criteria are the most powerful thing in VW, on my opinion, and it pays off greatly, investing a couple of hours in learning them.

Now paste these in the criteria field:

* to list all design layer viewports:

=DATABASE(( (PON='NNA_DesignLayerViewport') ))

* to list all sheet layers viewports

=DATABASE(( (ST=506) ))

* to list both together you can mix:

=DATABASE(((ST=506) | (PON='NNA_DesignLayerViewport')))

After you set up a proper criteria, you can request infos in the singular cells

* make sure that "Database Headers" is activated. This you find in the first menu up left, clicking on the arrow, just below the red cross.

* select a cell where the number is not divided with a dot. That is a header.

* to have the name paste: =N

* to have the layer where it resides paste: =L

* to have the class where it belongs paste: =C

there is a lot that you can do with these functions. Personally I never saw any better or simpler list than the one that you find in the documentation:

Check the VW help for

* "Worksheets" and

* Retrieving Object Attributes: here you get all these things like "L" for layers and "C" for class.

* Operators and so on

* Worksheet Functions

There is a large number of search criteria that are listed under "Search Criteria Tables" in the VectorScript documentation. Why are they only there, I don't know.

orso

Edited by _c_
Link to comment

I remember well when I learned criteria.

Initially I always avoided them, looking at them they scared me to death.

Then one day I decided to go through them.

The fact is that in shortest time I found them clear and easy. I think that it takes a couple of hours. The code you don't remember any way, but it doesn't matter: the documentation is always available.

They just LOOK scary, but they are not.

orso

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...