diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2017-05-17 20:25:39 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@edx.srv.br> | 2017-05-18 15:24:05 +0200 |
| commit | 9b2ab190af0db946c0ceb57d45ac6778fcfc2e6e (patch) | |
| tree | 1f358f04e9e7da7e37b52b1e8ca7ac7ae23cdfec /source/text/scalc | |
| parent | 6f947c50faf2969405749fc118659d9d9934eb91 (diff) | |
Fix several mistakes flagged by translators
Change-Id: If2e081fa32ec82250514c59d820adb5fa071669b
Reviewed-on: https://gerrit.libreoffice.org/37743
Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/func_weekday.xhp | 6 | ||||
| -rw-r--r-- | source/text/scalc/01/func_workday.intl.xhp | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/source/text/scalc/01/func_weekday.xhp b/source/text/scalc/01/func_weekday.xhp index 1bfaa7dc1e..30012968c3 100644 --- a/source/text/scalc/01/func_weekday.xhp +++ b/source/text/scalc/01/func_weekday.xhp @@ -133,15 +133,15 @@ </table> <paragraph id="par_id3156188" role="note" xml-lang="en-US">These values apply only to the standard date format that you select under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item> -</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><emph/><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</paragraph> +</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</paragraph> <paragraph id="hd_id3153836" role="heading" level="3" xml-lang="en-US">Examples</paragraph> <paragraph id="par_id3150317" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY("2000-06-14")</item> returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4).</paragraph> <paragraph id="par_id3153174" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY("1996-07-24";2)</item> returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3).</paragraph> <paragraph id="par_id3153525" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY("1996-07-24";1)</item> returns 4 (the Type parameter is 1, therefore Sunday is day number 1. July 24, 1996 was a Wednesday and therefore day number 4).</paragraph> -<paragraph id="par_id050220170616006699" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY("</item><item type="literal">2017</item><item type="literal">-0</item><item type="literal">5</item><item type="literal">-</item><item type="literal">02</item><item type="literal">";1</item><item type="literal">4</item><item type="literal">)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)</paragraph> +<paragraph id="par_id050220170616006699" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY("2017-05-02";14)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)</paragraph> <paragraph id="par_id3150575" role="paragraph" xml-lang="en-US"><item type="literal">=WEEKDAY(NOW())</item> returns the number of the current day.</paragraph> <paragraph id="par_id3150588" role="tip" xml-lang="en-US">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type="literal">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></paragraph> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/01/func_workday.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp index 855cc68dcf..635dc3479f 100644 --- a/source/text/scalc/01/func_workday.intl.xhp +++ b/source/text/scalc/01/func_workday.intl.xhp @@ -54,8 +54,8 @@ <paragraph id="par_id241020160012178562" role="paragraph" xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;7;F3:J3)</item> returns January 15, 2017 with weekend parameter 7.</paragraph> <paragraph id="par_id241020160012176149" role="paragraph" xml-lang="en-US">To define Sunday only the weekend day, use the weekend parameter 11.</paragraph> <paragraph id="par_id241020160012181455" role="paragraph" xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;11;F3:J3)</item> returns January 9, 2017.</paragraph> -<paragraph id="par_id24102016001218469" role="paragraph" xml-lang="en-US">Alternatively, use the weekend string “0000001” for Sunday only weekend.</paragraph> -<paragraph id="par_id241020160012183680" role="paragraph" xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;“0000001”;F3:J3)</item> returns January 9, 2017.</paragraph> +<paragraph id="par_id24102016001218469" role="paragraph" xml-lang="en-US">Alternatively, use the weekend string "0000001" for Sunday only weekend.</paragraph> +<paragraph id="par_id241020160012183680" role="paragraph" xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3;"0000001";F3:J3)</item> returns January 9, 2017.</paragraph> <paragraph id="par_id241020160012181870" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – Weekday and Holidays – by leaving them out:</paragraph> <paragraph id="par_id241020160012182048" role="paragraph" xml-lang="en-US"><item type="literal">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017.</paragraph> |