CellsSRC(...

[layla]

Hi,
Any one knows how to access the document that set the values in the
argumnets for "shp.CellsSRC(...)",and when we have something
like:"shp.CellsSRC(...)=-----" what values should we put there and
what does it represent
thanks

 

[Paul Herber]

Hi,
Any one knows how to access the document that set the values in the
argumnets for "shp.CellsSRC(...)",and when we have something
like:"shp.CellsSRC(...)=-----" what values should we put there and
what does it represent
thanks

http://msdn.microsoft.com/en-us/library/aa141916(office.10).aspx
or
http://msdn.microsoft.com/en-us/library/aa215160(office.11).aspx

use any search engine to search for "Visio cellssrc"

 

[layla]

http://msdn.microsoft.com/en-us/library/aa141916(office.10).aspx
orhttp://msdn.microsoft.com/en-us/library/aa215160(office.11).aspx

use any search engine to search for "Visio cellssrc"

--
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio          http://www.electronics.sandrila.co.uk/
Electrical for Visio          http://www.electrical.sandrila.co..uk/
Electronics Packages for Visiohttp://www.electronics-packages.sandrila.co..uk/

Thanks! But still I have problem to figure out what a code such that
AnObject.CellsSRC(, , ).FormulaU = "0" does,what does "0"or any other
number on right means
Any idea(s)

 

[John Goldsmith_Visio_MVP]

This is just a way of writing values to shape cells. All shapes in Visio
have a range of properties that control things like position, size, colour
etc. You can access these properties using the standard UI, through the
shape's respective ShapeSheet or via code (which a lot of the time is simply
reading and writing values to the ShapeSheet).

In your example AnObject.CellsSRC(, , ).FormulaU = "0"

AnObject is your reference to a shape (or page or document)

..CellsSRC returns a (ShapeSheet) cell object, based on the Section, Row and
Column indices that you pass in

..Formula allows you to read or write the contents of the ShapeSheet formula
to the cell object

Finally ="0" is the formula you're writing to the cell. This has meaning if
the cell you're writing to is a colour cell, such as FillForegnd, as 0 will
evaluate to Black, for example.

If you looking to achieve something specific then perhaps you could provide
a little more detail on what that is, but if you just looking to learn how
Visio works, then maybe I could point you to this blog post to get you
going:

http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html

Hope that helps.

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

http://msdn.microsoft.com/en-us/library/aa141916(office.10).aspx
orhttp://msdn.microsoft.com/en-us/library/aa215160(office.11).aspx

use any search engine to search for "Visio cellssrc"

--
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.electronics.sandrila.co.uk/
Electrical for Visio http://www.electrical.sandrila.co.uk/
Electronics Packages for
Visiohttp://www.electronics-packages.sandrila.co.uk/

Thanks! But still I have problem to figure out what a code such that
AnObject.CellsSRC(, , ).FormulaU = "0" does,what does "0"or any other
number on right means
Any idea(s)

 

[layla]

This is just a way of writing values to shape cells.  All shapes in Visio
have a range of properties that control things like position, size, colour
etc.  You can access these properties using the standard UI, through the
shape's respective ShapeSheet or via code (which a lot of the time is simply
reading and writing values to the ShapeSheet).

In your example  AnObject.CellsSRC(, , ).FormulaU = "0"

AnObject is your reference to a shape (or page or document)

.CellsSRC returns a (ShapeSheet) cell object, based on the Section, Row and
Column indices that you pass in

.Formula allows you to read or write the contents of the ShapeSheet formula
to the cell object

Finally ="0" is the formula you're writing to the cell.  This has meaning if
the cell you're writing to is a colour cell, such as FillForegnd, as 0 will
evaluate to Black, for example.

If you looking to achieve something specific then perhaps you could provide
a little more detail on what that is, but if you just looking to learn how
Visio works, then maybe I could point you to this blog post to get you
going:

http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html

Hope that helps.

Best regards

John

John Goldsmith (Visio MVP)www.visualSignals.typepad.co.ukwww.visualSignals.co.uk





Thanks! But still I have problem to figure out what a code such that
AnObject.CellsSRC(, , ).FormulaU = "0" does,what does "0"or any other
number on right means
Any idea(s)- Hide quoted text -

- Show quoted text -

Thanks a lot!Just one more thing about cellsSrc: in "cellsSRC
(section,row,column)" say I am planning to make specific connectors to
a node to be black ("0"),the question is:
1)how do you know what values must be insert for section/row/column
2)how do you "0" is for the coloring,and where you get numbers for red
or blue or..
thanks!

 

[John Goldsmith_Visio_MVP]

Get to know the ShapeSheet by spliting the screen to show the ShapeSheet and
a live shape. You can then edit the shape using normal formatting UI and
see the effects this has on the ShapeSheet (and vica versa of course).

If you want to know the cells 'address' just select a cell in the ShapeSheet
and press the F1 key to view the related Help file.

Colors correspond to the Color Palette (Tools / Color Palette). (You can
also use an RGB formula - again look up ShapeSheet functions in Help.)

You might also be interested in this link:

http://msdn.microsoft.com/en-us/library/aa245244(office.10).aspx

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

Thanks a lot!Just one more thing about cellsSrc: in "cellsSRC
(section,row,column)" say I am planning to make specific connectors to
a node to be black ("0"),the question is:
1)how do you know what values must be insert for section/row/column
2)how do you "0" is for the coloring,and where you get numbers for red
or blue or..
thanks!