Juniper-systems Allegro CX Manual Manual de usuario descargar pdf (Pagina 177)

Allegro CX Owner’s Manual 177

Modiﬁ ed([onOff])

Returns true if the Modiﬁ ed ﬂ ag is true (workbook was modiﬁ ed)

and sets the Modiﬁ ed ﬂ ag to onOff (true or false).

Example:

Modiﬁ ed(false)

MsgBox(text)

Shows the Message Box with the text.

Example:

MsgBox(“Hello”)

Paste([contents, format, skipBlanks, onlyResults])

Pastes the clipboard to the current selection.

Example:

Sel(A1:A5)

Copy()

Sel(B1)

Paste()

All arguments are optional. Paste() function without arguments

works as Edit|Paste menu command. The Paste() function with

arguments works as Edit|Paste Special menu comment. The Default

values for arguments are Paste(true, true, false, false).

Example for paste contents, preserve previous format:

Paste(true, false)

PlaySound([ﬁ lename])

Plays a sound (ﬁ le of type *.wav). If you use this function without

parameter, any currently playing sound is stopped.

Example:

PlaySound(“Song1.wav”)

RangeRef(col1, row1, col2, row2 [, sheetIndex])

Returns the range reference.

Example:

MsgBox(Sum(RangeRef(a1,2,20,2)))

1 2 ... 172 173 174 175 176 177 178 179 180 181 182 ... 303 304

Sin comentarios

Juniper-systems Allegro CX Manual Manual de usuario Pagina 177