A ScriptForge programkönyvtár
Open and select container.
A ScriptForge könyvtárak a Basic makrókból vagy Python parancsfájlokból meghívható LibreOffice makro parancsfájlok bővíthető gyűjteményét alkotják.
• Basic macros require to load ScriptForge library using the following statement:
GlobalScope.BasicLibraries.loadLibrary("ScriptForge")
• Python scripts require an import from scriptforge module:
from scriptforge import CreateScriptService
Invoking ScriptForge services
The described modules and classes are invoked from user scripts as "Services". A generic constructor of those services has been designed for that purpose for each language.
The Dispose method is available in all services and should be called to free up resources after usage:
GlobalScope.BasicLibraries.LoadLibrary("ScriptForge")
Set oSvc = CreateScriptService("servicename"[, arg0, arg1, ...])
' ...
oSvc.Dispose()
from scriptforge import CreateScriptService
svc = CreateScriptService('servicename'[, arg0, arg1, ...])
# ...
svc.Dispose()
Services provided by the ScriptForge library
Egydimenziós (vektorok) és kétdimenziós (mátrixok) tömbök manipulálására és transzformálására szolgáló módszerek gyűjteménye. Ez magában foglalja a halmazműveleteket, a rendezést, a szöveges fájlokból való importálást és a szöveges fájlba való exportálást.
Arrays with more than two dimensions cannot be used with the methods in this service, the only exception being the CountDims method that accepts Arrays with any number of dimensions.
The Base service provides a number of methods and properties to facilitate the management and handling of LibreOffice Base documents.
Ez a szolgáltatás szorosan kapcsolódik a Document szolgáltatáshoz, amely általános módszereket biztosít a LibreOffice dokumentumok kezeléséhez, beleértve a Base dokumentumokat is. Ezért a Base szolgáltatás kibővíti a Document szolgáltatást, és további, a Base dokumentumokra jellemző metódusokat biztosít, lehetővé téve a felhasználók számára, hogy:
-
Get access to the database contained in a Base document.
-
Open form documents stored in a Base document.
-
Check if a form document from a Base document is currently loaded.
The ScriptForge.Basic service proposes a collection of LibreOffice Basic methods to be executed in a Python context. Basic service methods reproduce the exact syntax and behaviour of Basic builtin functions.
The SFDocuments shared library provides a number of methods and properties to facilitate the management and handling of LibreOffice documents.
The SFDocuments.Calc service is a subclass of the SFDocuments.Document service. All methods and properties defined for the Document service can also be accessed using a Calc service instance.
The Calc service is focused on:
-
Handling sheets within a Calc document (copy, insert, move, etc)
-
Exchanging data between Basic data structures and Calc ranges
-
Copying and importing massive amounts of data
The Chart service provides a set of properties and methods to handle charts in Calc documents. With this service it is possible to:
-
Access chart objects in Calc documents and manipulate their properties.
-
Create and insert new charts into a Calc document.
-
Export charts as image files.
The Database service provides access to databases either embedded or described in Base documents. This service provides methods to:
-
Get access to data in database tables.
-
Run SELECT queries and perform aggregate functions.
-
Run SQL action statements such as INSERT, UPDATE, DELETE, etc.
The Dataset service is used to represent tabular data produced by a database. With this service it is possible to:
The Datasheet service allows to visualize the contents of database tables as well as the results of queries and SQL statements using Base's Data View. Additionally, this service allows to:
-
Add custom menus to the data view.
-
Access values in specific positions of the data view.
-
Position the cursor in a specific cell of the data view.
The Dialog service contributes to the management of dialogs created with the Basic Dialog Editor or dialogs created on-the-fly. Each instance of the current class represents a single dialog box displayed to the user.
The DialogControl service manages the controls belonging to a dialog defined with the Basic Dialog Editor. Each instance of the current service represents a single control within a dialog box.
The focus is set on getting and setting the values displayed by the controls of the dialog box. Formatting is accessible via the XControlModel and XControlView properties.
Note that the unique DialogControl.Value property content varies according to the control type.
Különös figyelmet fordítunk a fa vezérlőelemekre. Egy fát könnyen fel lehet tölteni, akár áganként, akár egyszerre több ággal. A fa vezérlőelem feltöltése történhet statikusan vagy dinamikusan.
A dictionary is a collection of key-item pairs
The SFDocuments library provides methods and properties to facilitate the management and manipulation of LibreOffice documents.
Methods that are applicable for all types of documents (Text Documents, Sheets, Presentations, etc) are provided by the SFDocuments.Document service. Some examples are:
The Exception service is a collection of methods to assist in code debugging in Basic and Python scripts and in error handling in Basic scripts.
In Basic scripts, when a run-time error occurs, the methods and properties of the Exception service help identify the error context and allow to handle it.
The FileSystem service includes routines to handle files and folders. Next are some examples of the features provided by this service:
-
Verify whether a file or folder exists.
-
Create and delete folders and files.
-
Launch dialog boxes to open/save files.
-
Access the list of files in a folder, etc.
The Form service provides methods and properties to manage forms in LibreOffice documents. This service supports forms in Base, Calc and Writer documents and allows to:
-
Open and activate forms.
-
Navigate through records shown by the form.
-
Get access to the controls inside the form.
-
Get access to subforms of a parent form.
A FormControl szolgáltatás hozzáférést biztosít egy űrlaphoz, alűrlaphoz vagy a FormDocument táblázatvezérlőhöz tartozó vezérlőkhöz. A FormControl szolgáltatás minden egyes példánya az űrlap egyetlen vezérlőelemére utal. Ez a szolgáltatás lehetővé teszi a felhasználók számára, hogy:
-
Get and set the properties of the control represented by the FormControl instance.
-
Access the current value displayed by the control.
-
Set the focus on the desired control.
The FormDocument service allows to access form documents stored in LibreOffice Base documents.
Egy Base dokumentumban a meglévő űrlapdokumentumok a felhasználói felületen a menüpont kiválasztásával tekinthetők meg. Minden űrlapdokumentum egy vagy több űrlapból állhat, beleértve a fő űrlapot és más alűrlapokat.
Ez a szolgáltatás számos módszert kínál a karakterláncok fordításához kapcsolódóan, a program forráskódját minimálisan befolyásolva. A L10N szolgáltatás által biztosított módszerek elsősorban a következőkre használhatók:
A Menu szolgáltatással menük hozhatók létre és távolíthatók el a LibreOffice dokumentumablak menüsorából. Minden egyes menübejegyzés egy parancsfájlhoz vagy egy UNO-parancshoz társítható. Ez a szolgáltatás a következő képességeket biztosítja:
-
Creation of menus with custom entries, checkboxes, radio buttons and separators.
-
Decoration of menu items with icons and tooltips.
The Platform service provides a collection of properties about the current execution environment and context, such as:
-
The hardware platform (architecture, CPU count, machine type, etc)
-
Operating system information (OS type, release, version, etc)
-
A LibreOffice verzió
-
The current user name
The PopupMenu service can be used to create popup menus that can be associated with events or executed by scripts. This service provides the following capabilities:
-
Creation of popup menus with custom entries, checkboxes and radio buttons.
-
Decoration of menu items with icons and tooltips.
The Region service provides a collection of properties and methods to handle locale and region-related aspects of programming, such as:
-
Accessing locale and region-dependent settings such as number formatting, currency and timezones.
-
Converting timezones and calculate Daylight Saving Time (DST) offsets.
-
Transforming numbers into text in any supported language.
A Services modul fő célja, hogy hozzáférést biztosítson a CreateScriptService metódushoz, amely a felhasználói parancsfájlokban meghívható a ScriptForge keretrendszerrel megvalósított szolgáltatáspéldányok létrehozására.
The Session service gathers various general-purpose methods about:
The String service provides a collection of methods for string processing. These methods can be used to:
-
Validate the contents of strings
-
Format strings by trimming, justifying or wrapping their contents
-
Use regular expressions to search and replace substrings
-
Apply hash algorithms on strings, etc.
The TextStream service is used to sequentially read from and write to files opened or created using the ScriptForge.FileSystem service.
The methods OpenTextFile and CreateTextFile from the FileSystem service return an instance of the TextStream service.
The Timer service measures the amount of time it takes to run user scripts.
A Timer measures durations. It can be:
-
Started, to indicate when to start measuring time.
-
Suspended, to pause measuring running time.
-
Resumed, to continue tracking running time after the Timer has been suspended.
-
Restarted, which will cancel previous measurements and start the Timer at zero.
The Toolbar service allows to retrieve information related to the toolbars available for a specific document window. With this service it is possible to:
The ToolbarButton service allows to retrieve information related to the toolbar buttons available in a given toolbar. With this service it is possible to:
The UI (User Interface) service simplifies the identification and the manipulation of the different windows composing the whole LibreOffice application:
-
Ablak kiválasztása
-
Windows moving and resizing
-
Állapotsor beállításai
-
Display of a floating progress bar
-
Creation of new windows
-
Access to the underlying "documents"
The UnitTest service provides a framework for automating unit tests using the Basic language, including the ability to:
-
Aggregate test cases into test suites and unit tests.
-
Share setup and shutdown code among test cases.
-
Report test results using the Console.
The SFDocuments shared library provides a number of methods and properties to facilitate the management and handling of LibreOffice documents.
Some methods are generic for all types of documents and are inherited from the SF_Document module, whereas other methods that are specific for Writer documents are defined in the SF_Writer module.
Note: Other ScriptForge undescribed modules are reserved for internal use. Their content is subject to change without notice.
All ScriptForge Basic routines or identifiers that are prefixed with an underscore character "_" are reserved for internal use. They are not meant be used in Basic macros or Python scripts.
