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