diff options
| author | Eike Rathke <erack@redhat.com> | 2022-12-07 23:33:16 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2022-12-07 22:43:24 +0000 |
| commit | 18924c3c7275e794703997e315910d99395dcd69 (patch) | |
| tree | 6da216a42a62ce77964dbc861bee04717a6d1213 | |
| parent | tdf#152022 Improve comments description in Help (diff) | |
| download | help-18924c3c7275e794703997e315910d99395dcd69.tar.gz help-18924c3c7275e794703997e315910d99395dcd69.zip | |
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 <erack@redhat.com>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 1 |
1 files changed, 1 insertions, 0 deletions
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"> |