summaryrefslogtreecommitdiff
path: root/wizards
AgeCommit message (Collapse)Author
2023-11-02'new Character' is deprecated in JavaNoel Grandin
replace with Character.valueOf Change-Id: I9938db0fce6490eba6f4900efc3c139a1b71d120 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/158786 Tested-by: Jenkins Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2023-11-02'new Double' is deprecated in JavaNoel Grandin
replace with Double.valueOf Change-Id: If5be8e500e31ebf9d5fb20ea7dd474677d7c74ff Reviewed-on: https://gerrit.libreoffice.org/c/core/+/158785 Tested-by: Jenkins Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2023-11-02'new Float' is deprecated in JavaNoel Grandin
replace with Float.valueOf Change-Id: Ib6408b24dac2953789d0ec67e73b8be8aefca252 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/158784 Tested-by: Jenkins Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2023-10-06Fix typosAndrea Gelmini
Change-Id: I70b570b74c793418ec6e045d454d20107675b9a6 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157601 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-10-06Fix typoAndrea Gelmini
Change-Id: I0ece1c462f3b493273cf70e32a78b718f0255ed7 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157602 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-10-06Fix typoAndrea Gelmini
Change-Id: Ib459277f1c535304a863d1061acf7b261e37aa7f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157605 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-10-06Fix typo in codeAndrea Gelmini
Change-Id: I7bfff7c50e9b97fec7d2100a542849360bb48e90 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157603 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-10-06Fix typoAndrea Gelmini
Change-Id: I0b557b4bc7e6b5ba569b2fce7bf8aee5e407e4ca Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157604 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-10-04ScriptForge (SFDocuments) Styles managementJean-Pierre Ledure
Introduction of new properties and methods: - StyleFamilies List of available style families All document types except Base - XStyle(family, stylename) UNO representation of given style All document types except Base - Styles(family, [namepattern, used, userdefined, parentstyle, category) A list of styles matching the given criteria All document types except Base - DeleteStyles(family, styleslist) Suppress the user-defined styles in the list All document types except Base and FormDocument - ImportStylesFromFile(filename, families, overwrite) Load styles from a closed file Calc and Writer only Example: to delete unused styles: a = doc.Styles("ParagraphStyles", used := False) doc.DeleteStyles("ParagraphStyles", a) All functionalities are available from Basic and Python scripts. Documentation has to be completed. Change-Id: I2533c14912257b58feb42bb11ff9d151c7b9531a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157563 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-10-02ScriptForge (SF_Session) validate Recipient arg of SendMailJean-Pierre Ledure
When the Recipient argument is absent when calling session.SendMail(...) or is not a string, an error message is raised, as should, but its content is wrong. The error message is now corrected. Change-Id: I248b6ce55c85a4b956f834c8e1ea7d0df40ab233 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157488 Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2023-09-28ScriptForge (SF_Base) tdf#156599 Error message when loading a formJean-Pierre Ledure
Error occurs in SF_Base.IsLoaded(...) "Object variable not set" When user scripts run the method repeatedly from nearly simultaneous events, it might happen that the _FormDocuments private variable is not initialized. Simultaneous calls may be interpreted as internal calls. Internal calls do not execute the "Check" part of the published API. Hence the failing initialization. Solution: force the initialization of that specific variable at each run. Change-Id: I489cbaed7b8e57d6876b7af4b26f5be0beb3db69 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/157374 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-09-03ScriptForge - Upgrade version number (7.6 => 24.2)Jean-Pierre Ledure
Change-Id: I0e7ceeafcf4c5a802249125e6be44a71adb1456b Reviewed-on: https://gerrit.libreoffice.org/c/core/+/156480 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-09-03ScriptForge (SF_Document) new XDocumentSettings propertyJean-Pierre Ledure
The XDocumentSettings property returns a com.sun.star.XXX.DocumentSettings UNO object. XXX = sheet, text, drawing or presentation It gives access to a bunch of UNO internal properties, specific to the document(s type. The property is available in Basic and Python user scripts. An update of the SF_Document service help page is required. Change-Id: I9d6db473c91ac5b1814def9cd100e874aa5490cd Reviewed-on: https://gerrit.libreoffice.org/c/core/+/156475 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-08-22Fix typoAndrea Gelmini
Change-Id: Ide2a33e282b575caf14374d7ae8034da41a6ed63 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155942 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-08-22Fix typoAndrea Gelmini
Change-Id: I05e93bd2c9ca3a270e07a4c0c7d09e4d3d6cea81 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155941 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-08-21ScriptForge - fix tdf#156836 Abort on MoveFirst()Jean-Pierre Ledure
The incident occurs when a move (last(), first(), next()) within the form's resultset is done from a Basic script immediately after the opening of the document containing the form. The insertion of a Wait 1 statement prevents the occurrence of the incident by interrupting very shortly the Basic process. Change-Id: I5e798db6e3f9ffaeeef38fb9badd008cbb190d1f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155897 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-08-20ScriptForge - Refactor Python <=> Basic protocolJean-Pierre Ledure
Incremental changes had made the code in SF_PythonHelper.xba scriptforge.py (which manage the protocol between the Python user scripts and the ScriptForge services implemented in Basic) less readable and efficient. Next features have been reviewed: - dict instances may be passed as arguments and returned. Conversions are done on-th-fly. - dates may be passed as arguments and returned. Conversions are done on-th-fly. The lists of hardcoded methods have been removed. - 2D arrays in standard modules may be passed as arguments and returned. Conversions are done on-th-fly. The lists of hardcoded methods have been removed. - The hardcoded list of methods requiring a post- processing has been reduced. - Methods in standard modules, when not returning an array, are also executed with CallByName(). - The unused 'localProperties' attribute in Python services has been removed. - Flags about arrays in standard modules have been adapted in filesystem.Files() filesystem.SubFolders() session.UnoMethods() session.UnoProperties() string.SplitNotQuoted() string.Wrap() ui.Documents() - The platform.UserData property became a usual property. Dictionaries are admitted as arguments and return values. As a consquence next functions are supported in Python as well: session.GetPDFExportOpetions() session.SetPDFExportOptions() document, calc, writer.CustomProperties document, calc, writer.DocumentProperties These changes require an update of the help pages. Non-regression tests were run with success. All changes are transparent for existing scripts. Change-Id: Iae7a1f5090c590209cd3cb2314c919c44736eba9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155860 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-08-09SCriptForge (SFDatabases) manage database credentialsJean-Pierre Ledure
When not embedded, databases usually require user and password to grant access to scripts. When the access was refused, so far the execution was stopped brutally with an error message provided by LO internal code. This was made visible during some tests with a MySql database server. The code to be reviewed is located in the creation of the "database" service. This service has the sungularity that it can be called from several other service instances. As from this commit unsuccessful tentatives to login to a database from code are rejected with a clean SF error message. The different scenarios to create a database service have been (re)tested. Change-Id: I695d108242872d27671688af76916784908aeebe Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155507 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-30ScriptForge (SF_Session) fix SendMail() w/o attachmentJean-Pierre Ledure
Fix error message when no attachment passed to the method. Execution continues now without trouble. Change-Id: I447af45db97f086963027c131c6b5fb9dab93c7a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155066 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-30Fix typoAndrea Gelmini
Change-Id: I7ac33586a01a65e20143ec1e853c6720de453d35 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155054 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-29ScriptForge (SF_Platform) new UserData propertyJean-Pierre Ledure
The UserData property lists the content of the "User Data" oage of the Options dialog. The content is returned: - in Basic: in a SF_Dictionary instance - in Python: in a dict[] instance. The list of the available keys is: city, company, country, email, encryptionkey, encrypttoself, fax, firstname, homephone, initials, lastname, officephone, position, postalcode, signingkey, state, street, title Many are different from the UNO/priginal values to make them more user understandable. This commit will require an update of the SF_Platform help page. Both Basic and Python user scripts are supported. Change-Id: If645579ee9109a1b8180da5a5f3a71979bb5ca59 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/155024 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-23ScriptForge (SF_FileSystem) Fix typosJean-Pierre Ledure
Typos in comment lines Change-Id: I5e92417af0c9fb1f6f4d240a5a7731c9efa5230d Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154802 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-23Fix typoAndrea Gelmini
Change-Id: I2a14c233aa09aec55b18dae2d4018a07c012ab52 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154795 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-23Fix typoAndrea Gelmini
Change-Id: Ia6252da165d734b752ea6cad96f8014556bb4bfd Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154796 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-22ScriptForge (SF_FileSystem) IncludeSubfolders argumentJean-Pierre Ledure
In the FileSystem service, the - SubFolders() - Files() methods receive an optional argument IncludeSubfolders (Boolean). That argument determines whether or not only the given FolderName is explored or also its subfolders up to the bottom of the folders structure. The argument must be used with caution as the number of returned folders or files may increase rapidly. anThis could consume excessive process time. This patch will require an update of the help page about the filesystem service. The new argument is available both for Basic and Python user scripts. Change-Id: Id2a96cd63cb51f8681f20a203a711b47a636fc3a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154763 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-21Sync ScriptForge pt.po translationRafael Lima
Change-Id: I67075b3ae5e57b8924e12770d835a83513147da3 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154536 Tested-by: Jenkins Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2023-07-19ScriptForge (FormDocument) fix tdf#156356 Variable not definedJean-Pierre Ledure
Change-Id: I4bbd4b05ca42ccde4b83eb55a1f1ae80ebca9680 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154592 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2023-07-15Fix typoAndrea Gelmini
Change-Id: I04d3440d121e6305b3435964b88d221bf4bce221 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154486 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15Fix typoAndrea Gelmini
Change-Id: If33699080b8f56998416b87db1e75e91b0ed18ed Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154485 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15Fix typoAndrea Gelmini
Change-Id: I62c3e5394e52591df08e2f6acd826718dc1a0cbd Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154484 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15Fix typoAndrea Gelmini
Change-Id: I5e1093f05a9916991304a178a73d81c073883479 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154483 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15Fix typoAndrea Gelmini
Change-Id: I7a1afd67e976abe504f859f0f5561ac5ebc6df98 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154482 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15Fix typoAndrea Gelmini
Change-Id: If692d47efd95e3383734b91ea72d4d665503b3d2 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154481 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-15ScriptForge (SF_FileSystem) support document(s internal file structureJean-Pierre Ledure
1. The SF_Document services (document, base, calc, formdocument, writer) receive a new FileSystem property that returns the "root" of the component's file structure under the format: "vnd.sun.star.tdoc:/XXX" XXX being the document's identifier. The implementation does not use the RuntimeUID (UNO property of the OfficeDocument service) which is optional and, f.i. not present for Base documents. Instead the css.frame.TransientDocumentsDocumentContentFactory service is used. 2. The SF_FileSystem and SF_TextStream modules have been reviewed to support the new context. Next restrictions have been met: - The FileNaming property is always cnsidered as 'URL' - CompareFiles() is not applicable - GetFileLen() always returns zero - HashFile() is not applicable - Normalize() always returns the input string unchanged - PickFile() is not applicable - PickFolder() is not applicable Additionally, - CreatetextFile() - OpenTextFile() in write or append modes copy or initialize the file in a temporary storage and write it back in the document when it is being closed. The process is transparent for the user. 3. The GetTempName() method accepts an option Extension argument, for better convenience. The new functionalities are available in Basic and Python. Changes require an update of the help documentation. Change-Id: Ibf8dd9983656923cf6ab43d9f48398dc4d1e6307 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154443 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-13Fix typoAndrea Gelmini
Change-Id: If127e00bab20839021afe82df555083bbae72ab0 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154384 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Julien Nabet <serval2412@yahoo.fr>
2023-07-08ScriptForge - (SF_Calc) fix typo in CopyToRange() methodJean-Pierre Ledure
Change-Id: I07db487d94c2d0a8f2ec5955f6e94b00911d25c4 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/154214 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-07-04Fix typosAndrea Gelmini
Change-Id: I1049c2bec21caa751a37708023338a1449dc5539 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/153953 Reviewed-by: Julien Nabet <serval2412@yahoo.fr> Tested-by: Jenkins
2023-05-27Fix typoAndrea Gelmini
Change-Id: Id0d9335df80539877d1ee27e57e98b0a6aae75db Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152337 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-27Fix typoAndrea Gelmini
Change-Id: I989d9a915c61186b4fd9132f70b916b3dfd7f202 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152338 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-26ScriptForge (SF_Dialog) new CloneControl() methodJean-Pierre Ledure
Duplicate an existing control of any type in the actual dialog. The duplicated control is left unchanged. The new control can be relocated. Args: SourceName: the name of the control to duplicate ControlName: the name of the new control. It must not exist yet. Left, Top: the coordinates of the new control expressed in "Map AppFont" units. Returns: an instance of the SF_DialogControl class or Nothing The method is available from Basic and Python user scripts This change will require an update of the SF_Dialog help page. Change-Id: I5c2a5404a14ad60b2d4df2ac7eabbf0ddd843170 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152333 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-05-24ScripForge (SF_Dialog) new OrderTabs() methodJean-Pierre Ledure
Set the tabulation index f a series of controls. The sequence of controls are given as an array of control names from the first to the last. Next controls will not be accessible (anymore ?) via the TAB key if >=1 of next conditions is met: - if they are not in the given list - if their type is FixedLine, GroupBox or ProgressBar - if the control is disabled Args: TabsList: an array of valid control names in the order of tabulation. Start: the tab index to be assigned to the 1st control in the list. Default = 1. Increment: the difference between 2 successive tab indexes. Default = 1. Returns: True when successful. The method is available from Basic and Python user scripts This change will require an update of the SF_Dialog help page. Change-Id: Ie854227691c4e182b49a521b1285deaa4de3d1ff Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152166 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
2023-05-22Fix typoAndrea Gelmini
Change-Id: Ic3f79113f09be10f6ff33183b09f80e269f77f93 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152122 Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-22Fix typoAndrea Gelmini
Change-Id: I6fab6b5c40eb9668df72ea01a2d158eabdc99f86 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152121 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-22ScriptForge (SFDialogs: create dialogs on-the-flyJean-Pierre Ledure
A dialog service is returned by next statement dialog = CreateScriptService("newdialog", dialogname, place) All properties and methods applicable to predefined dialogs are available for such new dialogs. In particular the series of CreateXXX() methods for the addition of ne dialog controls. The functionality is available from Basic and Python user scripts. An update of the SFDialogs.SF_Dialog help page is required. A display rendering unstability (flickerings, delays, ..) has been observed when (all conditions must be met) - the user script is run from Python - from inside the LibreOffice process - the dialog is non-modal Change-Id: Id3f311cd04497fd79712ce712bdb2724b5caa861 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/152071 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2023-05-20ScriptForge New method dialog.CreateHyperlink()Jean-Pierre Ledure
Method (Dialog service) CreateHyperlink(controlname, place, border, multiline, align, verticalalign) completes the set of available methods for dynamic DialogControl creation. Cfr. https://gerrit.libreoffice.org/c/core/+/151896 Change-Id: I162075ea39efdd2e1189fe8b16ac05316e6a13ff Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151954 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2023-05-18Fix typoAndrea Gelmini
Change-Id: Ia737462375311bb8642a9326a2980111e3ef7064 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151953 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-18Fix typoAndrea Gelmini
Change-Id: Ie097c4afad429ed23a616658502e3936afaea86a Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151951 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-18Fix typoAndrea Gelmini
Change-Id: I1a18149550cdfbaf7537213bdf41734751503598 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151950 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-18Fix typoAndrea Gelmini
Change-Id: I101861eaa810dc6e2f92a57ddc4e247a76a4b558 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151949 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-05-18Fix typoAndrea Gelmini
Change-Id: I372395970887c4201e973aa0583c288714fdbf6f Reviewed-on: https://gerrit.libreoffice.org/c/core/+/151947 Tested-by: Julien Nabet <serval2412@yahoo.fr> Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
generated by cgit (git 2.34.1) at 2024-12-26 10:04:42 +0000