source/text/scalc/01/func_date.xhp | 12 +++++++----- source/text/shared/00/00000005.xhp | 11 ++++++++++- 2 files changed, 17 insertions(+), 6 deletions(-)
New commits: commit e765079b2b017b6fb450cbc8c283c303c8a52b15 Author: Olivier Hallot <[email protected]> AuthorDate: Wed Jun 24 10:39:14 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Jun 24 20:15:57 2026 +0200 tdf#172320 Add information for DATE() Change-Id: I9859fea2c16112fec98262d9eb0a912c3e52e641 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/207240 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp index e01677d0e2..bb687fa6b3 100644 --- a/source/text/scalc/01/func_date.xhp +++ b/source/text/scalc/01/func_date.xhp @@ -26,19 +26,21 @@ <body> <bookmark branch="index" id="bm_id3155511"><bookmark_value>DATE function</bookmark_value> </bookmark> -<bookmark branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><h1 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> +<bookmark branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/> +<h1 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> </variable></h1> <description id="par_id3153551"><ahelp hid="HID_FUNC_DATUM">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format.</description> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id3150474">DATE(Year; Month; Day)</paragraph> <paragraph role="paragraph" id="par_id3152815"> <emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99.</paragraph> -<paragraph role="paragraph" id="par_id3153222">In <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx.</paragraph> +<note id="par_id3153222">In <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx.</note> <paragraph role="paragraph" id="par_id3155817"> -<emph>Month</emph> is an integer indicating the month.</paragraph> +<emph>Month</emph> is an integer indicating the month. A value between 1 and 12.</paragraph> <paragraph role="paragraph" id="par_id3153183"> -<emph>Day</emph> is an integer indicating the day of the month.</paragraph> -<paragraph role="paragraph" id="par_id3156260">If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type="input">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type="input">=DATE(00;13;31)</item> the result will be 2001-01-31.</paragraph> +<emph>Day</emph> is an integer indicating the day of the month. A value between 1 and 31.</paragraph> +<paragraph role="paragraph" id="par_id3156260">If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <input>=DATE(2000;12;31)</input> the result will be 2000-12-31. If, on the other hand, you enter <input>=DATE(2000;13;31)</input> the result will be 2001-01-31.</paragraph> +<tip id="par_id971782307844974">To avoid ambiguity, always use four digits for years.</tip> <embed href="text/scalc/01/common_func.xhp#IntegerTrunc"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id3152589"> commit 1253770cdf808c74edaa70ac7be783c19410d842 Author: Olivier Hallot <[email protected]> AuthorDate: Wed Jun 24 09:54:28 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Jun 24 20:15:46 2026 +0200 tdf#172313 Define "gamut" in glossary Change-Id: Idaf03d8dbd0fd05269fb85af327a466ef74de2d4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/207234 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/shared/00/00000005.xhp b/source/text/shared/00/00000005.xhp index c3b3dbbb58..1f83b62fdc 100644 --- a/source/text/shared/00/00000005.xhp +++ b/source/text/shared/00/00000005.xhp @@ -143,9 +143,18 @@ </bookmark> <h2 id="hd_id3163710">Formatting</h2> <paragraph id="par_id3163821" role="paragraph">Formatting refers to the visual layout of text using a word-processing or DTP program. This includes defining the paper format, page borders, fonts and font effects, as well as indents and spacing. You can format text <link href="text/shared/00/00000005.xhp#Section7">directly or with Styles</link> provided by $[officename].</paragraph> - </section> +<section id="gamut"> +<bookmark branch="index" id="bm_id471782305234470"> +<bookmark_value>gamut;color scale</bookmark_value> +<bookmark_value>device colors;gamut</bookmark_value> +</bookmark> + <h2 id="hd_id521782304816002">Gamut</h2> + <paragraph role="paragraph" id="par_id831782305019823">From <link href="https://en.wikipedia.org/w/index.php?title=Gamut";>Wikipedia</link>:</paragraph> + <paragraph role="paragraph" id="par_id341782304912864">In color reproduction and colorimetry, a gamut, or color gamut, is a convex set containing the colors that can be accurately represented, that is, reproduced by an output device (for example, a printer or display) or measured by an input device (for example, camera or visual system). Devices with a larger gamut can represent more colors. Similarly, gamut may also refer to the colors within a defined color space, which is not linked to a specific device. A trichromatic gamut is often visualized as a color triangle. A less common usage defines gamut as the subset of colors contained within an image, scene or video.</paragraph> +</section> + <section id="halfwidth"> <bookmark branch="index" id="bm_id911622865848718"> <bookmark_value>half-width;definition</bookmark_value>
