[Libreoffice-commits] help.git: help3xsl/online_transform.xsl source/text

2022-11-10 Thread Olivier Hallot (via logerrit) 
 help3xsl/online_transform.xsl  |2 +-
 source/text/shared/00/0002.xhp |2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

New commits:
commit 05ca41502856e01755d7de748789cdfefd5e6d16
Author: Olivier Hallot 
AuthorDate: Thu Nov 10 13:16:14 2022 -0300
Commit: Olivier Hallot 
CommitDate: Thu Nov 10 18:05:52 2022 +0100

tdf#150909 Fix regression: HTML entities badly rendered

The "branding" XSL template is applied to every text in the Help to
replace %PRODUCTNAME or [$officename] by the correct product name.
It must not escape HTML entities such as  or other.

Reverted previous workaround in xhp page.

Change-Id: I1f7da19ca2899d92917504f162ba497bd9c787bb
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142555
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index 6176574c33..c398e97a5e 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -900,7 +900,7 @@
 
 
 
-
+
 
 
 
diff --git a/source/text/shared/00/0002.xhp 
b/source/text/shared/00/0002.xhp
index b54a974f98..0cfbc9b60a 100644
--- a/source/text/shared/00/0002.xhp
+++ b/source/text/shared/00/0002.xhp
@@ -190,7 +190,7 @@
 
 
 Tags
-HTML pages contain 
certain structural and formatting instructions called tags. Tags are code words 
enclosed by brackets in the document description language HTML. Many tags 
contain text or hyperlink references between the opening and closing brackets. 
For example, titles are marked by the tags  h1  at the beginning and 
 /h1  at the end of the title. Some tags only appear on their own such 
as  br  for a line break or  img ...  to link a 
graphic.
+HTML pages contain 
certain structural and formatting instructions called tags. Tags are code words 
enclosed by brackets in the document description language HTML. Many tags 
contain text or hyperlink references between the opening and closing brackets. 
For example, titles are marked by the tags h1 at the beginning and 
/h1 at the end of the title. Some tags only appear on their own such as 
br for a line break or img ... to link a graphic.

[Libreoffice-commits] help.git: help3xsl/online_transform.xsl source/text

2022-09-17 Thread Olivier Hallot (via logerrit) 
 help3xsl/online_transform.xsl |3 
 source/text/scalc/01/05120200.xhp |1 
 source/text/scalc/01/05120300.xhp |2 
 source/text/scalc/01/05120400.xhp |  115 +-
 4 files changed, 115 insertions(+), 6 deletions(-)

New commits:
commit 7c924256f4ea9c328d7b384b2cff31829399decd
Author: Olivier Hallot 
AuthorDate: Sat Sep 17 16:25:34 2022 -0300
Commit: Olivier Hallot 
CommitDate: Sat Sep 17 22:35:55 2022 +0200

tdf119421 - More on conditional formatting/Icon sets

+ Housekeeping
+ handle icon images in the XSLT
+ Fill missing information on Icon Sets.

Change-Id: Iaab3e1231ad4a2212adfc1d353a593cc116c7978
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140108
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index fa28ad0ff..6176574c3 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -1182,6 +1182,9 @@
 
 
 
+
+
+
 
 
 
diff --git a/source/text/scalc/01/05120200.xhp 
b/source/text/scalc/01/05120200.xhp
index 90c9c5d15..0ca166372 100644
--- a/source/text/scalc/01/05120200.xhp
+++ b/source/text/scalc/01/05120200.xhp
@@ -16,7 +16,6 @@
 
 
 
-
 
 Condition - Formula 
is
 Applies 
the selected style to the cell when the formula expression in the text box in 
the right is not zero.
diff --git a/source/text/scalc/01/05120300.xhp 
b/source/text/scalc/01/05120300.xhp
index 7e2327e7b..451cd0995 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -16,7 +16,6 @@
 
 
 
-
 
 Condition - Date 
is
 Applies the 
selected style to the cell when the cell contents is formatted as date and the 
condition is one of the available date interval in the dropdown 
list.
@@ -46,6 +45,5 @@
 This 
year, Last year and Next year: applies the cell style if the cell date 
contents is in this year, last year and next year respectively.
 
 
-
 
 
diff --git a/source/text/scalc/01/05120400.xhp 
b/source/text/scalc/01/05120400.xhp
index c6136ed96..ab288871e 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -45,35 +45,144 @@
 
 
 Icon Set
-It is 
desired to plot the position of a value relative to the thresholds. The set of 
icons will help to indicate the thresholds and choose the type of icons. 
Available icon sets are:
+Add an 
icon to the cell based on the value relative to the specified thresholds. 
Several icon sets are available.
+Available Icon Sets
 
 
 3, 
4 or 5 - arrows
+
+Color arrow up
+Color arrow slightly up
+Color arrow same
+Color arrow slightly down
+Color arrow down
+
 
 
 3, 
4 or 5 - gray arrows
+
+Gray arrow up
+Gray arrow slightly up
+Gray arrow same
+Gray arrow slightly down
+Gray arrow down
+
 
 
 3 
- flags
+
+Yellow flag
+Red flag
+Green flag
+
 
 
 3 
- traffic lights 1 and 2 (two different designs)
+
+Yellow traffic light 1
+Red traffic light 1
+Green traffic light 1
+
+
+Yellow traffic light 2
+Red traffic light 2
+Green traffic light 2
+
 
 
-3 
- symbols (square, triangle, circle)
+3 - Smileys 
1 and 2
+
+Yellow positive smiley
+Yellow neutral smiley
+Yellow negative smiley
+
+
+Green positive smiley
+Yellow neutral smiley
+Red negative smiley
+
+
+
+3 
- symbols 
+
+Shape triangle
+Shape diamond
+Shape circle
+
+
+Exclamation mark
+Cross
+Check mark
+
+
+Empty star
+Half star
+Full star
+
+
+Triangle up
+Same
+Triangle down
+
 
 
 4 
- circles from red to black
+
+Dark red
+Light red
+Light gray
+Dark gray
+
 
 
 4 
or 5 - ratings
+
+Empty

[Libreoffice-commits] help.git: help3xsl/online_transform.xsl source/text

2022-02-05 Thread Olivier Hallot (via logerrit) 
 help3xsl/online_transform.xsl |   39 ++-
 source/text/scalc/01/12080500.xhp |   76 ++
 2 files changed, 49 insertions(+), 66 deletions(-)

New commits:
commit c4c67afc5f5ac8ada17f82a248eba33c8bd0c520
Author: Olivier Hallot 
AuthorDate: Sat Feb 5 06:51:12 2022 -0300
Commit: Olivier Hallot 
CommitDate: Sat Feb 5 15:31:37 2022 +0100

Drop last 00/0004.xhp#wie and simplify XSLT

Change-Id: I85d2da067db208f806b78020a9ca95889444ce0d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/129519
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index 4f75de400..a6ce8255b 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -419,11 +419,6 @@
 
 
 
- 
-
-
-
-
 
 
 
@@ -481,10 +476,6 @@
 
 
 
- 
-
-
-
 
 
 
@@ -528,10 +519,6 @@
 
 
 
- 
-
-
-
 
 
 
@@ -1437,20 +1424,18 @@
 
 
 
- 
-
-
-
-
-
- 
-
-
- 
-[ not 
found].
-
-
-
+
+
+
+
+
+ 
+
+
+ 
+[ not 
found].
+
+
 
 
 
diff --git a/source/text/scalc/01/12080500.xhp 
b/source/text/scalc/01/12080500.xhp
index f6dfedc58..35e0b4e1d 100644
--- a/source/text/scalc/01/12080500.xhp
+++ b/source/text/scalc/01/12080500.xhp
@@ -1,7 +1,4 @@
 
-
-
-
 
-
-   
+
 
 
 AutoOutline
@@ -30,62 +26,64 @@
 
 
 
-AutoOutline
+AutoOutline
 If the selected cell range contains formulas or 
references, $[officename] automatically outlines the 
selection.
 
-
+
+
+
 For example, 
consider the following table:
 
 
-
-January
+
+January
 
-
-February
+
+February
 
-
-March
+
+March
 
-
-1st 
Quarter
+
+1st 
Quarter
 
-
-April
+
+April
 
-
-May
+
+May
 
-
-June
+
+June
 
-
-2nd 
Quarter
+
+2nd 
Quarter
 
 
 
-
-100
+
+100
 
-
-120
+
+120
 
-
-130
+
+130
 
-
-350
+
+350
 
-
-100
+
+100
 
-
-100
+
+100
 
-
-200
+
+200
 
-
-400
+
+400

[Libreoffice-commits] help.git: help3xsl/online_transform.xsl source/text

2021-04-14 Thread Olivier Hallot (via logerrit) 
 help3xsl/online_transform.xsl  |   32 
 source/text/scalc/01/04060104.xhp  |   32 
 source/text/scalc/01/04060106.xhp  |3 +--
 source/text/scalc/01/04060107.xhp  |2 +-
 source/text/scalc/01/04060109.xhp  |   16 
 source/text/scalc/01/04060110.xhp  |2 +-
 source/text/scalc/01/04060111.xhp  |   24 
 source/text/scalc/01/04060112.xhp  |   33 +++--
 source/text/scalc/01/04060116.xhp  |2 +-
 source/text/scalc/01/04060118.xhp  |3 ++-
 source/text/scalc/01/04060119.xhp  |2 +-
 source/text/scalc/01/04060120.xhp  |   14 +++---
 source/text/scalc/01/04060181.xhp  |2 +-
 source/text/scalc/01/04060182.xhp  |2 +-
 source/text/scalc/01/04060183.xhp  |2 +-
 source/text/scalc/01/04060184.xhp  |2 +-
 source/text/scalc/01/04060185.xhp  |2 +-
 source/text/scalc/01/func_color.xhp|2 +-
 source/text/scalc/01/func_countifs.xhp |2 +-
 source/text/scalc/01/func_sumifs.xhp   |2 +-
 20 files changed, 89 insertions(+), 92 deletions(-)

New commits:
commit 26e5265ade24d7eeeaf7d120e0dbcb4cbc598fed
Author: Olivier Hallot 
AuthorDate: Wed Apr 14 19:31:31 2021 -0300
Commit: Olivier Hallot 
CommitDate: Thu Apr 15 00:36:30 2021 +0200

Fix sort order of Calc functions

Change-Id: I8237b0d52b8b0f29fc35196d34648ed7b51669d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114113
Tested-by: Jenkins
Reviewed-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index d30add9d9..b7502f6f4 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -595,28 +595,28 @@
 
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
 
@@ -629,28 +629,28 @@
 
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
-
+
 
 
 
diff --git a/source/text/scalc/01/04060104.xhp 
b/source/text/scalc/01/04060104.xhp
index c0c8b2761..27ae5b206 100644
--- a/source/text/scalc/01/04060104.xhp
+++ b/source/text/scalc/01/04060104.xhp
@@ -144,7 +144,7 @@
   
 
 
-
+
 
 
 
@@ -211,7 +211,7 @@
   
 
 
-Other spreadsheet 
applications may accept localized values for the Type parameter, but %PRODUCTNAME Calc will only accept 
the English values.
+Other spreadsheet applications may accept localized 
values for the Type parameter, but %PRODUCTNAME 
Calc will only accept the English values.
 
 
 =INFO("release") returns the product release number of the 
%PRODUCTNAME in use.Do not translate "release"
@@ -359,7 +359,7 @@
 mw inserted "recognizing..." and "formula cells;"
 
 
-ISFORMULA
+ISFORMULA
 Returns TRUE if a cell is a formula 
cell.
 
 
@@ -379,7 +379,7 @@
 
 
 
-ISEVEN
+ISEVEN
 Returns TRUE if the value is an even integer, or FALSE 
if the value is odd.
 
 
@@ -402,7 +402,7 @@
 
 
 
-ISEVEN_ADD
+ISEVEN_ADD
 Tests for even numbers. Returns 1 if the number 
divided by 2 returns a whole number.
 
 
@@ -423,7 +423,7 @@
 mw added "cell contents;"
 
 
-ISNONTEXT
+ISNONTEXT
 Tests if the cell contents are text or numbers, and 
returns FALSE if the contents are text.
 If an error 
occurs, the function returns TRUE.
 
@@ -445,7 +445,7 @@
 mw added "blank..." and "empty cells;"
 
 
-ISBLANK
+ISBLANK
 Returns TRUE if the reference to a cell is 
blank. This function is used to determine if the content of a cell is 
empty. A cell with a formula inside is not empty.
 
 
@@ -466,7 +466,7 @@
 mw added "number formats;" and "logical..."
 
 
-ISLOGICAL
+ISLOGICAL
 Tests for a logical value (TRUE or 
FALSE).
 If an error 
occurs, the function returns FALSE.
 
@@ -487,7 +487,7 @@
 mw added "#N/A ..."
 
 
-ISNA
+ISNA
 Returns TRUE if a cell contains the #N/A (value not 
available) error value.
 If an error 
occurs, the function returns FALSE.
 
@@ -507,7 +507,7 @@
 
 
 
-IFNA
+IFNA
 Returns the value if the cell does not contains the #N/A 
(value not available) error value, or the alternative value if it 
does.
 
 
@@ -527,7 +527,7 @@
 
 
 
-ISTEXT
+ISTEXT
 Returns TRUE if the cell contents refer to 
text.
 If an error 
occurs, the function returns FALSE.
 
@@ -548,7 +548,7 @@
 
 
 
-ISODD
+ISODD
 Returns TRUE if the value is odd, or FALSE if the 
number is even.
 
 
@@ -570,7 +570,7 @@
 
 
 
-ISODD_ADD
+ISODD_ADD
 Returns

[Libreoffice-commits] help.git: help3xsl/online_transform.xsl source/text wiki-to-help/test2.xml

2018-04-16 Thread dennisroczek 
 help3xsl/online_transform.xsl |2 -
 source/text/sbasic/shared/03131600.xhp|2 -
 source/text/sbasic/shared/03132500.xhp|4 +-
 source/text/sbasic/shared/main0601.xhp|4 +-
 source/text/scalc/01/04060101.xhp |2 -
 source/text/scalc/01/04060107.xhp |2 -
 source/text/scalc/01/04060110.xhp |4 +-
 source/text/scalc/01/04060111.xhp |9 ++
 source/text/scalc/01/04060182.xhp |2 -
 source/text/scalc/01/04060185.xhp |4 +-
 source/text/scalc/01/exponsmooth_embd.xhp |2 -
 source/text/scalc/01/statistics.xhp   |   20 +++---
 source/text/scalc/01/statistics_regression.xhp|2 -
 source/text/scalc/guide/database_filter.xhp   |7 ++--
 source/text/scalc/guide/database_sort.xhp |7 ++--
 source/text/shared/00/0021.xhp|2 -
 source/text/shared/01/0211.xhp|4 +-
 source/text/shared/01/06040400.xhp|2 -
 source/text/shared/explorer/database/dabawiz02access.xhp  |2 -
 source/text/shared/explorer/database/main.xhp |2 -
 source/text/shared/explorer/database/migrate_macros.xhp   |2 -
 source/text/shared/explorer/database/rep_navigator.xhp|6 ++--
 source/text/shared/guide/assistive.xhp|2 -
 source/text/shared/guide/digital_signatures.xhp   |2 -
 source/text/shared/guide/digitalsign_receive.xhp  |   14 -
 source/text/shared/guide/ms_import_export_limitations.xhp |2 -
 source/text/shared/guide/scripting.xhp|7 ++--
 source/text/shared/guide/start_parameters.xhp |4 +-
 source/text/shared/optionen/01010200.xhp  |2 -
 source/text/swriter/guide/numbering_lines.xhp |2 -
 source/text/swriter/guide/numbering_paras.xhp |2 -
 wiki-to-help/test2.xml|6 ++--
 32 files changed, 66 insertions(+), 70 deletions(-)

New commits:
commit b7ecf6294f9caa8454ebcc9c2d6f33ac64ff9e78
Author: dennisroczek 
Date:   Tue Apr 3 23:38:42 2018 +0100

replace http links with https equivalents

* mainly http://wiki.documentfoundation.org
* http://en.wikipedia.org
* http://api.libreoffice.org

Change-Id: I3587d8d5e6a6de4a7c7013920b9e135e4adc977c
Reviewed-on: https://gerrit.libreoffice.org/52354
Tested-by: Jenkins 
Reviewed-by: Olivier Hallot 
Tested-by: Olivier Hallot 

diff --git a/help3xsl/online_transform.xsl b/help3xsl/online_transform.xsl
index 6db51ccaf..b96cb1948 100644
--- a/help3xsl/online_transform.xsl
+++ b/help3xsl/online_transform.xsl
@@ -295,7 +295,7 @@
 
 
 
-http://www.libreoffice.org/imprint; 
target="_blank">Impressum (Legal Info) | http://www.libreoffice.org/privacy; target="_blank">Privacy Policy | 
http://www.documentfoundation.org/statutes.pdf; 
target="_blank">Statutes (non-binding English translation) - http://www.documentfoundation.org/satzung.pdf; target="_blank">Satzung 
(binding German version) | Copyright information: Unless otherwise 
specified, all text and images on this website are licensed under the http://www.libreoffice.org/download/license/; target="_blank">Mozilla 
Public License v2.0. “LibreOffice” and “The Document Foundation” are 
registered trademarks of their corresponding registered owners or are in actual 
use as trademarks in one or more countries. Their respective logos and icons 
are also subject to international copyright laws. Use thereof is explained in 
our http://wiki.documentfoundation.org/TradeMark_Policy; target
 ="_blank">trademark policy. LibreOffice was based on OpenOffice.org.
+https://www.libreoffice.org/imprint; 
target="_blank">Impressum (Legal Info) | https://www.libreoffice.org/privacy; target="_blank">Privacy Policy | 
https://www.documentfoundation.org/statutes.pdf; 
target="_blank">Statutes (non-binding English translation) - https://www.documentfoundation.org/satzung.pdf; target="_blank">Satzung 
(binding German version) | Copyright information: Unless otherwise 
specified, all text and images on this website are licensed under the https://www.libreoffice.org/download/license/; target="_blank">Mozilla 
Public License v2.0. “LibreOffice” and “The Document Foundation” are 
registered trademarks of their corresponding registered owners or are in actual 
use as trademarks in one or more countries. Their respective logos and icons 
are also subject to international copyright laws. Use thereof is explained in