Table of contents
Collapse the table of content
Expand the table of content

Shape.GetFormulasU Method (Visio)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns the formulas of many cells.


expression . GetFormulasU( SRCStream() , formulaArray() )

expression A variable that represents a Shape object.


NameRequired/OptionalData TypeDescription
SRCStream()RequiredIntegerA stream identifying cells to be queried.
formulaArray()RequiredVariantOut parameter. An array that receives formulas of queried cells.

Return Value



The GetFormulasU method is like the FormulaU property of a Cell object, except you can use it to obtain the formulas of many cells at once rather than one cell at a time. The GetFormulasU method is a specialization of the GetResults method, which can be used to obtain cell formulas or results. Setting up a call to the GetFormulasU method involves slightly less work than setting up the GetResults method.

You can use the GetFormulasU method to get formulas of any set of cells.

SRCStream() is an array of 2-byte integers. For Shape objects, SRCStream() should be a one-dimensional array of 3 n 2-byte integers for some n >= 1. GetFormulasU interprets the stream as:

{sectionIdx, rowIdx, cellIdx}n

where sectionIdx is the section index of the desired cell, rowIdx is its row index and cellIdx is its cell index.

If the GetFormulasU method succeeds, formulaArray() returns a one-dimensional array of n variants indexed from 0 to n - 1. Each variant returns a formula as a string. formulaArray() is an out parameter that is allocated by the GetFormulasU method, which passes ownership back to the caller. The caller should eventually perform the SafeArrayDestroy procedure on the returned array. Note that the SafeArrayDestroy procedure has the side effect of clearing the variants referenced by the array's entries, hence deallocating any strings the GetFormulas method returns. (Microsoft Visual Basic and Visual Basic for Applications take care of this for you.) The GetFormulasU method fails if formulaArray() is Null .

Note Beginning with Microsoft Visio 2000, you can use both local and universal names to refer to Visio shapes, masters, documents, pages, rows, add-ons, cells, hyperlinks, styles, fonts, master shortcuts, UI objects, and layers. When a user names a shape, for example, the user is specifying a local name. Beginning with Microsoft Office Visio 2003, the ShapeSheet spreadsheet displays only universal names in cell formulas and values. (In prior versions, universal names were not visible in the user interface.)

As a developer, you can use universal names in a program when you don't want to change a name each time a solution is localized. Use the GetFormulas method to get more than one formula when you are using local syntax. Use the GetFormulasU method to get more than one formula when you are using universal syntax.

© 2018 Microsoft