99 Commits

Author SHA1 Message Date
7590253108 MsgBox not a Statement. tdf#162447
originally from https://ask.libreoffice.org/t/msgbox-statement-vs-function/108929

Change-Id: I62e871b878ec463e9d82a7506124a5c99de7ac28
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/171415
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-08-30 16:45:43 +02:00
e859581bf5 tdf#149786 tdf#161495 VBA objects & properties & methods (WiP)
- ActiveSheet object
- (Calc).ExportAsfixedFormat method

This initiates a documentation help page intended to aggregate MSOffice VBA objects
features that are currently supported.
Change-Id: I679e9a64923b69fd0d1a5ac99d39651fd8353fc7
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168530
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2024-07-06 21:31:28 +02:00
1522a9b569 Fix syntax error
...introduced in 1658fb55defb5a08d3adbd7637745f8a62c58f89 "Update
Basic/Python TOC with Calc samples"

Change-Id: I5be787dfc60bef363757143171484020de7f1288
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168657
Reviewed-by: Stephan Bergmann <stephan.bergmann@allotropia.de>
Tested-by: Jenkins
2024-06-11 08:34:25 +02:00
1658fb55de Update Basic/Python TOC with Calc samples
Change-Id: I1ce9b023b0e90dae868cc323af3e9d0296a66bdc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168534
Tested-by: Jean-Pierre Ledure <jp@ledure.be>
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
Tested-by: Jenkins
2024-06-10 18:51:06 +02:00
cd2824ba5e Document new SF Dataset service
Change-Id: I4e6a792f2cbcbf826f51f5d62e6dad855d4a0bf0
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160035
Tested-by: Jenkins
Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2023-12-01 14:51:21 +01:00
751a65e5be Document SF Toolbar and ToolbarButton services
Change-Id: I57df3b88660198d2432ff73ef1b37025e1b893a3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/159902
Tested-by: Jenkins
Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2023-11-28 15:45:43 +01:00
07d0a97995 Document new SF FormDocument service
Change-Id: I6bcf114d25877f5c69463285f9bddcf0c8339079
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/155783
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2023-08-25 13:34:33 +02:00
5b8658e58d FormatPercent New Basic function / VBA
Change-Id: I0ad4022394632f0d49417bb56ecda641af3b0b42
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146519
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Jenkins
2023-02-13 09:57:05 +00:00
bd899b607e Create TOC with all ScriptForge methods and properties
Change-Id: I32be401689efce0cba70216458bc7c8ba4a405c5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144309
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-17 12:02:57 +00:00
63011fa120 Document the new SF_Datasheet service
This patch creates the help page for the new ScriptForge service named Datasheet. It also updates associated methods that were added to the Base and Database services.

Change-Id: I6611653b77e1ee41f6afacccb2094f19d7178434
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144183
Tested-by: Jenkins
Tested-by: Jean-Pierre Ledure <jp@ledure.be>
Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2022-12-16 14:59:41 +00:00
cf59121b3e tdf114263 DoEvents new help page
Change-Id: I4a031759aa48df9230e4019740a94ca167519792
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141920
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-09 18:12:11 +01:00
021a444733 tdf141474 CreateUnoService accepts keyword arguments
tdf114263 CreateUnoServiceWithArguments new help page

Change-Id: I217746d0817cefcaab7ecb07d30b2c3f2ad8bfff
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141916
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-10-30 14:32:57 +01:00
d6e98a37ec Document the new UnitTest service of the ScriptForge library
This patch also updates the sbasic.tree to include the Region and UnitTest services. I also moved the ScriptForge library so that it appears right below the Advanced Basic Libraries (previously it was inside this section).

Change-Id: I7dfd9080dcd3212d2b53f88480087d48f5dec60c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136548
Tested-by: Jenkins
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-07-01 16:41:25 +02:00
68e39672b4 Toc update to document Python resources
Python modules deserve to be highlited:
- scriptforge
- uno
- msgbox

Change-Id: I6d0cad668527b17b1f3ca898d5001768cb30a318
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135947
Tested-by: Jenkins
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-06-24 16:08:35 +02:00
385b2a1c99 Basic help extra x-links
Change-Id: I875e5027de98d23e1644aaa5cfbce0a124f543b2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130677
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-03-02 14:17:44 +01:00
401fb641af tdf#114263 tdf#141474 tdf#147262 CallByName() function new help page
Change-Id: I99ed22b86b04a3ae4338e0c2ab49dbd594032ac6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129607
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2022-02-18 01:16:57 +01:00
cc8821b427 Fix typo
Change-Id: I9ee453c0ca7c2bb990e024a4881ef7940d2df35c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129309
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-02-02 00:27:07 +01:00
d5322f2e28 tdf#146847 Integer Division (\) operator help page
Change-Id: I90505e2412eb53b3423407af52d6b358801c41f8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128543
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-01-31 14:12:12 +01:00
9de15af089 Create documentation for SFWidgets.Menu service
Change-Id: Iaf0d10c2a1100d78098a99c93a2479d31b0f412b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128947
Tested-by: Jenkins
Reviewed-by: Alain Romedenne
2022-01-28 14:53:20 +01:00
fb0af5ca08 tdf#145725 VBA mode for RGB functions and warnings
+ Added a RGB [VBA] page specific to VBA mode for RGB stressing
  differences
+ placed warnings on Red vs Blue color interchange in VBA mode
+ Refactored here and there.

Change-Id: I0556babb7c3a4bd3eeff1bfe6993624aa0e78d6d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127098
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-12-20 13:10:45 +01:00
9ae4ee41e4 Refactor help tree files
This patch applies "xmlling --format" to all *.tree files in helpcontent2/source/auxiliary.

The reason for this refactoring is that these files' indentation is very messy and it makes it harder to maintain and update the files. Also, the indentation used here relies on Tabs whereas XHP files use two blank spaces as indentation.

So this refactoring also applies 2 blank spaces as indentation to the tree files.

Change-Id: I54366d6efd011a09baf45c3b74c089bd9b0401f1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125718
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-11-24 14:33:42 +01:00
5ce3e1b6c3 Create PopupMenu service documentation
Change-Id: I511221e68e9504a5c9e5e6c00bb31047a6ccf11b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124982
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2021-11-18 15:30:10 +01:00
3445df8b37 Create help page for SF_Chart service
Change-Id: Ie244e4416d2b523dfe460701297f6ecfc81f964d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124195
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2021-10-29 22:41:46 +02:00
28499f409a tdf#145067 Document the Basic Collection object
Change-Id: I0ea7be144cca78b48ab3dfd07426ad679b07b26b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123398
Tested-by: Jenkins
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2021-10-14 19:52:24 +02:00
152530c436 Create documentation for Basic "New" operator
Change-Id: I11157f8db43811a107eb5270db5b39c351b37dcc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123159
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-10-11 02:05:24 +02:00
7f942a62c3 Create a guide on Calc macros on reading and writing cell values
This patch also creates a new entry in the Calc tree menu to store all pages about Calc macros. Currently there are only two, but in future patches new pages will be added.

Change-Id: Iac55c87d1159f4163ba3150e83160b4156d0d0f6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122936
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2021-10-07 21:28:32 +02:00
82e70eb6ef tdf#143687 Document the "IS" Basic keyword
This patch also improves related help pages about the functions IsObject and EqualUnoObjects.

Change-Id: I5f16596ed057c1104d5fa2650299861741bd7b2e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123153
Tested-by: Jenkins
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2021-10-07 19:37:03 +02:00
62f7c4a827 SFDocuments.Writer new service - WiP
Change-Id: Ia3da307c224aaea53d6a0e2067a78db113119b50
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121770
Tested-by: Jenkins
Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2021-09-27 16:56:32 +02:00
9b8c44b49d Create guide about Calc macros to format cell borders
This patch is a follow-up to a previous revert:
https://gerrit.libreoffice.org/c/help/+/121554

This patch uses the correct path for the new file "calc_borders.xhp".

Change-Id: I4eb72db1ef8f5d964905be46dcb645dbd4e28e67
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121556
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-03 17:50:08 +02:00
844431301f Revert "Create guide about Calc macros to format cell borders"
This reverts commit ce0d3ff57a732b1f89f88b5f0c4cbb22e0d050c3.

Reason for revert: new file in wrong position

Change-Id: Icebc9502ad250493c704d309eefeb388f6118c11
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121554
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-03 14:09:43 +02:00
ce0d3ff57a Create guide about Calc macros to format cell borders
Change-Id: Ia7bbbf25322775e3a291fcb474079b2e2bc4e41e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121461
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-09-03 13:59:57 +02:00
0b7cde3aab Create help page for the Development Tools feature
Change-Id: Ib392399fa71c27ce6be7fca8c55985d75519ea87
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/119855
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-03 01:39:29 +02:00
ff452e27c1 ScriptForge method signatures
Change-Id: I5c29d5c08a8c5bd46ca45dc1d17449a0ae4789b8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116910
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2021-06-21 19:32:01 +02:00
693c6bf5fa Add SF services to the Help tree
Change-Id: Ifbd98abbfde88ea293bd920cbcd0f12c8b399a91
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117131
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-14 23:06:19 +02:00
9fffc3e09d ThisDatabaseDocument new help page
Change-Id: I9ad35913bbc5fef9208b3a9ea5eb9be01f882131
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116463
Tested-by: Jenkins
Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
2021-06-09 16:49:57 +02:00
68a8e252d2 tdf#124066 Help for VBA StrConv function
1) LCID codes linked to LibreOffice internal LCID file
2) Examples borrowed from QA tests

Change-Id: I1b00a1901f32de0243b518de39abd633ba08eadc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116684
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-07 19:36:15 +02:00
140f7c8bd3 Basic Toc cleanup - pt. 2
- reordering
- adding missing topics

Change-Id: Ie049e96f7849f2b96d56a189cdb163c089eb8fe8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113644
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-15 11:45:15 +02:00
f44cc1049d BASIC Toc cleanup
Relocated topics are
- Generating random numbers
- (deletion) Comparison operators
- Numeric functions
- Trigonometric functions
- Further statements

Change-Id: I2ed75e20f790273460be56fab62ad6cc6e357397
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113366
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-04-01 19:43:52 +02:00
268d92a454 (ScriptForge) SFDialogs library sf_Dialog sf_control new pages
- sf_calc unmuting L10N

Change-Id: I3799952c29f21570e6faa81c5b1b27bc28786fb5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109674
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-02-03 23:37:42 +01:00
165f2eb082 ScriptForge library modules - WiP
- sf_array page restored after being overwritten
- self-links in both pages on H1 tag

Change-Id: I9c3d47447124d5c7199a03c9a7d76e0e337244ef
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107695
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-12-17 13:53:39 +01:00
090116c279 tdf#134xxx DefErr syntax diagram
- toc update
- prefix dupe usage fixed - letter 'k'
- DefErr diagram

Change-Id: Ib3bd1b5907eae42b088d0b0b39d3e5f70dc0c43d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103971
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-10-09 18:02:44 +02:00
78dc9c1d05 tdf#131416 Basic Syntax Diagrams for Defxxx statements
- Basic language ref . toc additions
- Letter range option addition
- DefBool-based refactoring

Change-Id: I5744c63e9c21ad5ff2801cd03a119fd2c747fef3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/103056
Tested-by: Jenkins
Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-29 12:28:19 +02:00
5b2fdb324a tdf#136112 Date/Time are LibO Basic functions not statements
- Documenting Date/Date$, Time/Time$ as functions
- Date Time not be mentioned as statements in help

Change-Id: I828c4df92a2ae2347c8b057451ac7922eac896bf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101954
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-09-03 18:19:56 +02:00
290bab91da tdf#131416 How to read syntax diagrams
Change-Id: Ic8ec05c75658f600f5ea1509acb482cc3db5d796
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/98343
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-09 17:26:05 +02:00
b6f441acbe Basic advanced libraries brief descriptions
Change-Id: I4bdfd0983e52e8741b9082f0bc6dfa1a35b16510
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97582
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-02 13:17:34 +02:00
fcf75206c5 Basic compiler/runtime options aggregation
- Base
- Explicit
- ClassModule
- Compatible
- Private Module
- VBASupport

Change-Id: If5edfe93a744d847bc387d868cbb26292b60ea0a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96493
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-17 23:57:21 +02:00
7af288d0fa tdf#134032 Calling Calc function from basic
Change-Id: I7c3c64e0df4d89b46e49afb869f3e2de0825a6e2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96485
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-06-17 13:38:36 +02:00
099f7cea6b tdf#131416 Syntax diagrams
- Erase: syntax + new examples + x-refs
- Managing flow of control: Do, If, While diagrams

- Basic Syntax Diagrams (WiP) cheatsheet:
  https://wiki.documentfoundation.org/User:LibreOfficiant/BasicSyntax

Change-Id: I68e03ccf8169d59e56f9a2e5b10b4bf09d8b217b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/93529
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-11 02:00:00 +02:00
6522d1a261 tdf#131416 Syntax diagrams
- Print & Select Case statements
- GoSub,GoTo, On…GoSub/GoTo statements
  - section reuse + x-refs

Change-Id: I785d46013d7e8e9f571b2a2d2abaa3e2e41d223f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/93376
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-05 19:59:53 +02:00
115422426e tdf#131416 Basic Subroutines help pages
- Function, Property & Sub statements
- Public, Private are keywords, Global removed from diagrams:
  -  Global=Public as Basic libraries remain in memory
- Basic toc & index

Change-Id: If107f4d148b4da399dd03d1b18ea3da5454bb9ac
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92784
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-04 16:16:43 +02:00