source/text/scalc/01/04060109.xhp | 1 +
1 file changed, 1 insertion(+)
New commits:
commit 18924c3c7275e794703997e315910d99395dcd69
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Wed Dec 7 23:33:16 2022 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Wed Dec 7 22:43:24 2022 +0000
Add a note to the STYLE() function to not use it without reason..
Change-Id: I74b30b58bdfbc5a4392f344a2de8a600b2eca030
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143804
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 77d68eddb8..1ae6e7198e 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -416,6 +416,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORLAGE" id="bm_id3154342"
localize="false"/>
<h2 id="hd_id3149425">STYLE</h2>
<paragraph xml-lang="en-US" id="par_id3150826"
role="paragraph"><ahelp hid="HID_FUNC_VORLAGE">Applies a style to the cell
containing the formula.</ahelp> After a set amount of time, another style can
be applied. This function always returns the value 0, allowing you to add it to
another function without changing the value. Together with the CURRENT function
you can apply a color to a cell depending on the value. For example:
=...+STYLE(IF(CURRENT()>3;"red";"green")) applies the style "red" to the
cell if the value is greater than 3, otherwise the style "green" is applied.
Both cell formats, "red" and "green" have to be defined beforehand.</paragraph>
+ <note id="par_id1670450904">The STYLE function should not be used
without compelling reason, its purpose is the use with asynchronous Add-In
functions to visually notify about the availability of a result. In almost all
other cases using conditional formatting instead is a better choice.</note>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149302"
role="code">STYLE("Style" [; Time [; "Style2"]])</paragraph>
<paragraph xml-lang="en-US" id="par_id3150596" role="paragraph">
