Juniper-systems Allegro DOS Manual Manual do Utilizador descarregar pdf (Página 147)

Windows CE Page 4-81

Default values of parameters: Chart(“Type:Bar”, “”Series:Rows”,

“Legend”, “Xaxis”, “Yaxis”, “Xgrid:No”, “Ygrid:Yes”, “AutoScale”).

Example: Sel(a1:c20)

Chart(“Type:XY”, “Title:Sin(x)”, “Xgrid”, “Ygrid”)

Sel(b2:f5)

Chart(“Series:Columns”, “AutoScale:No”)

Clear()

Clears contents in the current selection.

Example: Clear()

ClearFormat()

Clears format in the current selection.

Example: ClearFormat()

ColHide([hideUnhide])

Returns whether the first column of current selection is hidden and

hides (true) or unhides (false) selected columns if hideUnhide is

specified.

Example: Sel(B1:B1)

ColHide(true)

ColWidth([width])

Returns column width of the first column of current selection and sets

width of selected columns if width is specified.

Example: Sel(B1:C1)

ColWidth(100)

Copy()

Copies the current selection to the clipboard.

Example: Sel(A1:A5)

Copy()

Sel(B1)

Paste()

DeleteCells(colsRows)

Deletes cells (true - columns, false - rows).

Example: DeleteCells(true)

FileBox(title [,filter])

Opens a file dialog box with the title and the file type filter.

Example: picture=FileBox(“Pictures”,

“*.jpg,*.gif,*.bmp,*.2bp,*.xbm”)

ShowPicture(picture)

Filter(onOff)

Sets auto filter (true = autofilter on, false = autofilter off). Auto filter

range is the current selection.

Example: Filter(true)

1 2 ... 142 143 144 145 146 147 148 149 150 151 152 ... 273 274

Sem comentários

Juniper-systems Allegro DOS Manual Manual do Utilizador Página 147