Inhoud

# Lijst met alle ScriptForge-methodes en -eigenschappen

Deze helppagina toont alle methoden en eigenschappen die beschikbaar zijn in de ScriptForge-bibliotheek per service met links naar de bijbehorende documentatie.

De Basic-broncode voor alle ScriptForge-services is beschikbaar via Applicatiemacro's en dialoogvensters en wordt gedistribueerd in meerdere bibliotheken: ScriptForge, SFDatabases, SFDialogs, SFDocuments, SFUnitTests en SFWidgets. Het Python-gedeelte van de broncode is beschikbaar in het bestand program\scriptforge.py in de installatiemap van LibreOffice.

## ScriptForge.Array-service

De lijst met methodes in de service Array
Append AppendColumn AppendRow Contains ConvertToDictionary Copy CountDims Difference ExportToTextFile ExtractColumn ExtractRow | Flatten ImportFromCSVFile IndexOf Insert InsertSorted Intersection Join2D Prepend PrependColumn PrependRow RangeInit | Reverse Shuffle Slice Sort SortColumns SortRows Transpose TrimArray Union Unique

## SFDocuments.Base-service

De methoden in de service Base
CloseFormDocument FormDocuments Forms GetDatabase | IsLoaded OpenFormDocument OpenQuery OpenTable | PrintOut SetPrinter

Deze service ondersteunt ook de methoden en eigenschappen die zijn gedefinieerd in de Document-service, waaronder methoden die generiek zijn voor alle documentsoorten.

## ScriptForge.Basic-service

De lijst met methoden in de service Basic
CDate CDateFromUnoDateTime CDateToUnoDateTime ConvertFromUrl ConvertToUrl CreateUnoService CreateUnoStruct DateAdd | DateDiff DatePart DateValue Format GetDefaultContext GetGuiType GetPathSeparator GetSystemTicks | GlobalScope.BasicLibraries GlobalScope.DialogLibraries InputBox MsgBox Now RGB Xray

Lijst met eigenschappen in de Basic-service
IDABORT IDCANCEL IDIGNORE IDNO IDOK IDRETRY IDYES MB_ABORTRETRYIGNORE | MB_DEFBUTTON1 MB_DEFBUTTON2 MB_DEFBUTTON3 MB_ICONEXCLAMATION MB_ICONINFORMATION MB_ICONQUESTION MB_ICONSTOP MB_OK | MB_OKCANCEL MB_RETRYCANCEL MB_YESNO MB_YESNOCANCEL StarDesktop ThisComponent ThisDatabaseDocument

## SFDocuments.Calc-service

Lijst met methoden in de Calc-service

A1Style
Activate
Charts
ClearAll
ClearFormats
ClearValues
CompactLeft
CompactUp
CopySheet
CopySheetFromFile
CopyToCell
CopyToRange
CreateChart
CreatePivotTable
DAvg

DCount
DMax
DMin
DSum
ExportRangeToFile
Forms
GetColumnName
GetFormula
GetValue
ImportFromCSVFile
ImportFromDatabase
InsertSheet
MoveRange
MoveSheet
Offset

OpenRangeSelector
PrintOut
Printf
RemoveDuplicates
RemoveSheet
RenameSheet
SetArray
SetCellStyle
SetFormula
SetValue
ShiftDown
ShiftLeft
ShiftRight
ShiftUp
SortRange

Lijst met eigenschappen in de Calc-service
CurrentSelection FirstCell FirstColumn FirstRow Height LastCell | LastColumn LastRow Range Region Sheet SheetName | Sheets Width XCellRange XSheetCellCursor XSpreadsheet

Deze service ondersteunt ook de methoden en eigenschappen die zijn gedefinieerd in de Document-service, waaronder methoden die generiek zijn voor alle documentsoorten.

## SFDocuments.Chart-service

Lijst met methoden in de Chart-service
ExportToFile | Resize

Lijst met eigenschappen in de Chart-service
ChartType Deep Dim3D Exploded Filled | Legend Percent Stacked Title XTitle | YTitle XChartObj XDiagram XShape XTableChart

## SFDatabases.Database-service

Lijst met methoden in de databaseservice
CloseDatabase Commit CreateDataset DAvg DCount DMin | DMax DSum DLookup GetRows OpenFormDocument OpenQuery | OpenSql OpenTable Rollback RunSql SetTransactionMode

Lijst met eigenschappen in de Databaseservice
Queries Tables | XConnection | XMetaData

## SFDatabases.Dataset-service

Lijst met methoden in de Dataset-service
CloseDataset CreateDataset Delete ExportValueToFile GetRows | GetValue Insert MoveFirst MoveLast | MoveNext MovePrevious Reload Update

Lijst met eigenschappen in de Dataset-service
BOF DefaultValues EOF Fields Filter | Orderby ParentDatabase RowCount RowNumber Source | SourceType UpdatableFields Values XRowSet

## SFDatabases.Datasheet-service

Lijst met methodes in de Datasheet-service
Activate CloseDatasheet CreateMenu | GetText GetValue GoToCell | RemoveMenu Toolbars

Lijst met eigenschappen in de Datasheet-service
ColumnHeaders CurrentColumn CurrentRow DatabaseFileName Filter | LastRow OrderBy ParentDatabase Source | SourceType XComponent XControlModel XTabControllerModel

## SFDialogs.Dialog-service

Lijst met methoden in de Dialog Service

Activate
Center
Controls
CloneControl
CreateButton
CreateCheckBox
CreateComboBox
CreateCurrencyField
CreateDateField
CreateFileControl
CreateFixedLine

CreateFixedText
CreateFormattedField
CreateGroupBox
CreateHyperlink
CreateImageControl
CreateListBox
CreateNumericField
CreatePatternField
CreateProgressBar
CreateRadioButton
CreateScrollBar

CreateTableControl
CreateTextField
CreateTimeField
CreateTreeControl
EndExecute
Execute
GetTextsFromL10N
Resize
OrderTabs
SetPageManager
Terminate

Lijst met eigenschappen in de Dialog-service
CANCELBUTTON Caption Height Modal Name OKBUTTON OnFocusGained OnFocusLost | OnKeyPressed OnKeyReleased OnMouseDragged OnMouseEntered OnMouseExited OnMouseMoved OnMousePressed OnMouseReleased | Page Visible Width XChartObj XDiagram XDialogModel XDialogView XTableChart

## SFDialogs.DialogControl-service

Lijst met methoden in de service DialogControl
AddSubNode AddSubTree CreateRoot | FindNode Resize SetFocus | SetTableData WriteLine

Lijst met eigenschappen in de DialogControl-service
Cancel Caption ControlType CurrentNode Default Enabled Format ListCount ListIndex | Locked MultiSelect Name Page Parent Picture RootNode RowSource | Text TipText TripleState Value Visible XControlModel XControlView XTreeDataModel

## ScriptForge.Dictionary-service

Lijst met methoden in de woordenboekservice
Add ConvertToArray ConvertToJson ConvertToPropertyValues | Exists ImportFromJson ImportFromPropertyValues Item | Remove RemoveAll ReplaceItem ReplaceKey

Lijst met eigenschappen in de Dictionary-service
Count | Items | Keys

## SFDocuments.Document-service

Lijst met methoden in de Documentenservice
Activate CloseDocument CreateMenu DeleteStyles Echo ExportAsPDF | ImportStylesFromFile PrintOut RemoveMenu RunCommand Save SaveAs | SaveCopyAs SetPrinter Style Toolbars XStyle

Lijst met eigenschappen in de Document-service
CustomProperties Description DocumentProperties DocumentType ExportFilters FileSystem ImportFilters | IsBase IsCalc IsDraw IsFormDocument IsImpress IsMath IsWriter | Keywords Readonly StyleFamilies Subject Title XComponent XDocumentSettings

## ScriptForge.Exception-service

Lijst met methoden in de uitzonderingsservice
Clear Console ConsoleClear ConsoleToFile | DebugDisplay DebugPrint PythonPrint | PythonShell Raise RaiseWarning

Lijst met eigenschappen in de Exception-service
Description | Number | Source

## ScriptForge.FileSystem-service

Lijst met methoden in de service FileSystem
BuildPath CompareFiles CopyFile CopyFolder CreateFolder CreateTextFile DeleteFile DeleteFolder ExtensionFolder | FileExists Files FolderExists GetBaseName GetExtension GetFileLen GetFileModified GetName GetParentFolderName | GetTempName HashFile MoveFile MoveFolder Normalize OpenTextFile PickFile PickFolder SubFolders

Lijst met eigenschappen in de FileSystem-service
ConfigFolder ExtensionsFolder FileNaming HomeFolder | InstallFolder Subject TemplatesFolder TemporaryFolder | Title UserTemplatesFolder XComponent

## SFDocuments.Form-service

Lijst met methoden in de formulierservice
Activate CloseFormDocument Controls GetDatabase | MoveFirst MoveLast MoveNext MoveNew | MovePrevious Requery SubForms

Lijst met eigenschappen in de Form-service
AllowDeletes AllowInserts AllowUpdates BaseForm Bookmark CurrentRecord Filter LinkChildFields LinkParentFields Name | OnApproveCursorMove OnApproveParameter OnApproveReset OnApproveRowChange OnApproveSubmit OnConfirmDelete OnCursorMoved OnErrorOccurred OnLoaded OnReloaded | OnReloading OnResetted OnRowChanged OnUnloaded OnUnloading OrderBy Parent RecordSource XForm

## SFDocuments.FormControl-service

Lijst met methoden in de service FormControl
Controls | SetFocus

Lijst met eigenschappen in de FormControl-service

Action
Caption
ControlSource
ControlType
Default
DefaultValue
Enabled
Format
ListCount
ListIndex
ListSource
ListSourceType
Locked
MultiSelect
Name
OnActionPerformed

OnAdjustmentValueChanged
OnApproveAction
OnApproveReset
OnApproveUpdate
OnChanged
OnErrorOccurred
OnFocusGained
OnFocusLost
OnItemStateChanged
OnKeyPressed
OnKeyReleased
OnMouseDragged
OnMouseEntered
OnMouseExited
OnMouseMoved

OnMousePressed
OnMouseReleased
OnResetted
OnTextChanged
OnUpdated
Parent
Picture
Required
Text
TipText
TripleState
Value
Visible
XControlModel
XControlView

## SFDocuments.FormDocument-service

Lijst met methoden in de service FormDocument
CloseDocument | Forms | PrintOut

## ScriptForge.L10N-service

De methoden in de service L10N
AddText AddTextsFromDialog | ExportToPOTFile | GetText

Lijst met eigenschappen in de L10N-service
Folder | Language | Locale

## SFWidgets.Menu-service

Lijst met methoden in de menuservice
AddCheckBox | AddItem | AddRadioButton

Lijst met eigenschappen in de Menu-service
ShortcutCharacter | SubmenuCharacter

## ScriptForge.Platform-service

Lijst met eigenschappen in de Platform-service
Architecture ComputerName CPUCount CurrentUser Extensions FilterNames Fonts | FormatLocale Locale Machine OfficeLocale OfficeVersion OSName OSPlatform | OSRelease OSVersion Printers Processor PythonVersion SystemLocale UserData

## SFWidgets.PopupMenu-service

Lijst met methoden in de service PopupMenu
AddCheckBox AddItem | AddRadioButton | Execute

Lijst met eigenschappen in de PopupMenu-service
ShortcutCharacter | SubmenuCharacter

## ScriptForge.Region-service

Lijst met methoden in de service Regio
DSTOffset LocalDateTime | Number2Text TimeZoneOffset | UTCDateTime UTCNow

Lijst met eigenschappen in de Region-service
Country Currency DatePatterns DateSeparator DayAbbrevNames | DayNames DayNarrowNames DecimalPoint Language ListSeparator | MonthAbbrevNames MonthNames MonthNarrowNames ThousandSeparator TimeSeparator

## ScriptForge.Session-service

Lijst met methoden in de service Session
ExecuteBasicScript ExecuteCalcFunction ExecutePythonScript GetPDFExportOptions HasUnoMethod | HasUnoProperty OpenURLInBrowser RunApplication SendMail SetPDFExportOptions | UnoMethods UnoProperties UnoObjectType WebService

Lijst met eigenschappen in de Session-service
SCRIPTISAPPLICATION SCRIPTISEMBEDDED SCRIPTISOXT | SCRIPTISPERSONAL SCRIPTISPERSOXT | SCRIPTISSHARED SCRIPTISSHAROXT

## ScriptForge.String-service

De lijst met methodes in de service String

Capitalize
Count
EndsWith
Escape
ExpandTabs
FilterNotPrintable
FindRegex
HashStr
HtmlEncode
IsADate
IsAlpha
IsAlphaNum
IsAscii
IsDigit
IsEmail

IsFileName
IsHexDigit
IsIBAN
IsIPv4
IsLike
IsLower
IsPrintable
IsRegex
IsSheetName
IsTitle
IsUpper
IsUrl
IsWhitespace
JustifyCenter
JustifyLeft

JustifyRight
Quote
ReplaceChar
ReplaceRegex
ReplaceStr
Represent
Reverse
SplitLines
SplitNotQuoted
StartsWith
TrimExt
Unescape
Unquote
Wrap

Lijst met eigenschappen in de Dictionary-service
sfCR sfLF | sfCRLF sfNEWLINE | sfTAB

## ScriptForge.TextStream-service

Lijst met methoden in de TextStream-service
CloseFile ReadAll | ReadLine SkipLine | WriteBlankLines WriteLine

Lijst met eigenschappen in de TextStream-service
AtEndOfStream Encoding | FileName IOMode | Line NewLine

## ScriptForge.Timer-service

Lijst met eigenschappen in de Timer-service
Continue Restart | Start Suspend | Terminate

Lijst met eigenschappen in de Timer-service
Duration IsStarted | IsSuspended SuspendDuration | TotalDuration

## ScriptForge.Toolbar-service

Lijst met methoden in de Toolbar-service
ToolbarButtons |  |

Lijst met eigenschappen in de Toolbar-service
BuiltIn Docked HasGlobalScope | Name ResourceURL | Visible XUIElement

## ScriptForge.ToolbarButton-service

Lijst met methoden in de ToolbarButton-service
Execute |  |

Lijst met eigenschappen in de ToolbarButton-service
Caption Height Index OnClick | Parent TipText Visible | Width X Y

## ScriptForge.UI-service

Lijst met methoden in de UI-service
Activate CreateBaseDocument CreateDocument (*) GetDocument Maximize | Minimize OpenBaseDocument OpenDocument (*) Resize | RunCommand SetStatusBar (*) ShowProgressBar WindowExists

Lijst met eigenschappen in de UI-service
ActiveWindow Documents Height | MACROEXECALWAYS MACROEXECNEVER MACROEXECNORMAL | Width X Y

## ScriptForge.UnitTest-service

Lijst met methoden in de service UnitTest
AssertAlmostEqual AssertEqual AssertFalse AssertGreater AssertGreaterEqual AssertIn AssertIsInstance AssertIsNothing AssertLike | AssertNotRegex AssertIsNull AssertLess AssertLessEqual AssertNotAlmostEqual AssertNotEqual AssertNotIn AssertNotInstance AssertNotLike | AssertNotNothing AssertNotNull AssertRegex AssertTrue Fail Log ReportError RunTest SkipTest

Lijst met eigenschappen in de UnitTest-service
LongMessage ReturnCode | Verbose | WhenAssertionFails

## ScriptForge.Writer-service

D'oh! You found a bug (text/sbasic/shared/03/sf_writer.xhp#methods_toc not found).

Verwante onderwerpen

De ScriptForge bibliotheek

Python-scripts met ScriptForge