diff options
| -rw-r--r-- | source/text/shared/01/05020301.xhp | 274 |
1 files changed, 251 insertions, 23 deletions
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp index 7bc68721ea..40d62d0493 100644 --- a/source/text/shared/01/05020301.xhp +++ b/source/text/shared/01/05020301.xhp @@ -716,7 +716,7 @@ <paragraph id="hd_id3149929" role="heading" level="3" xml-lang="en-US">Entering Dates</paragraph> <paragraph id="par_id3148397" role="paragraph" xml-lang="en-US">To enter a date in a cell, use the Gregorian calendar format. For example, in an English locale, enter 1/2/2002 for Jan 2, 2002.</paragraph> -<paragraph id="par_id3153274" role="paragraph" xml-lang="en-US">All date formats are dependent on the locale that is set in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph> +<paragraph id="par_id3153274" role="paragraph" xml-lang="en-US">All date formats are dependent on the locale that is set in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language settings - Languages</emph>. For example, if your locale is set to 'Japanese', then the Gengou calendar is used. The default date format in <item type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph> <paragraph id="par_id3153795" role="paragraph" xml-lang="en-US">To specify a calendar format that is independent of the locale, add a modifier in front of the date format. For example, to display a date using the Jewish calendar format in a non-Hebrew locale, enter: [~jewish]DD/MM/YYYY.</paragraph> @@ -787,7 +787,7 @@ </tablerow> </table> -<paragraph id="par_id3152419" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">If you perform a calculation that involves one or more cells using a date format, the result is formatted according to the following mappings: +<paragraph id="par_id3152419" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">If you perform a calculation that involves one or more cells using a date format, the result is formatted according to the following mappings: </caseinline></switchinline></paragraph> <switch select="appl"> <case select="CALC"> @@ -885,7 +885,7 @@ </case> </switch> -<paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. +<paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. </caseinline></switchinline></paragraph> <switch select="appl"> <case select="CALC"> @@ -1054,6 +1054,30 @@ </tablerow> <tablerow> <tablecell> + <paragraph id="par_id130820161753317270" role="tablecontent" xml-lang="en-US">Hebrew</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753311497" role="tablecontent" xml-lang="en-US">Hebrew characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753301830" role="tablecontent" xml-lang="en-US">Arabic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753306722" role="tablecontent" xml-lang="en-US">Arabic-Indic characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> <paragraph id="par_id130820161753301290" role="tablecontent" xml-lang="en-US">Thai</paragraph> </tablecell> <tablecell> @@ -1066,10 +1090,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753301830" role="tablecontent" xml-lang="en-US">Arabic</paragraph> + <paragraph id="par_id130820161753301831" role="tablecontent" xml-lang="en-US">Hindi</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753306722" role="tablecontent" xml-lang="en-US">Indic characters</paragraph> + <paragraph id="par_id130820161753306723" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> </tablecell> <tablecell> </tablecell> @@ -1078,10 +1102,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753309518" role="tablecontent" xml-lang="en-US">Hindi</paragraph> + <paragraph id="par_id130820161753309518" role="tablecontent" xml-lang="en-US">Odia</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753301434" role="tablecontent" xml-lang="en-US">Hindi characters</paragraph> + <paragraph id="par_id130820161753301434" role="tablecontent" xml-lang="en-US">Odia (Oriya) characters</paragraph> </tablecell> <tablecell> </tablecell> @@ -1090,10 +1114,202 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753317270" role="tablecontent" xml-lang="en-US">Hebrew</paragraph> + <paragraph id="par_id180820161926246858" role="tablecontent" xml-lang="en-US">Marathi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926248586" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926241975" role="tablecontent" xml-lang="en-US">Bengali</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926246091" role="tablecontent" xml-lang="en-US">Bengali characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926256261" role="tablecontent" xml-lang="en-US">Punjabi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926257295" role="tablecontent" xml-lang="en-US">Punjabi (Gurmukhi) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926254282" role="tablecontent" xml-lang="en-US">Gujarati</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926258664" role="tablecontent" xml-lang="en-US">Gujarati characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192625454" role="tablecontent" xml-lang="en-US">Tamil</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926253837" role="tablecontent" xml-lang="en-US">Tamil characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192625217" role="tablecontent" xml-lang="en-US">Telugu</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192625475" role="tablecontent" xml-lang="en-US">Telugu characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926251185" role="tablecontent" xml-lang="en-US">Kannada</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192625183" role="tablecontent" xml-lang="en-US">Kannada characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926265921" role="tablecontent" xml-lang="en-US">Malayalam</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192626103" role="tablecontent" xml-lang="en-US">Malayalam characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926264168" role="tablecontent" xml-lang="en-US">Lao</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926262520" role="tablecontent" xml-lang="en-US">Lao characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926264242" role="tablecontent" xml-lang="en-US">Tibetan</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926264284" role="tablecontent" xml-lang="en-US">Tibetan characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926265624" role="tablecontent" xml-lang="en-US">Burmese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926265398" role="tablecontent" xml-lang="en-US">Burmese (Myanmar) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926273825" role="tablecontent" xml-lang="en-US">Khmer</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926273240" role="tablecontent" xml-lang="en-US">Khmer (Cambodian) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192627382" role="tablecontent" xml-lang="en-US">Mongolian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926276923" role="tablecontent" xml-lang="en-US">Mongolian characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926273435" role="tablecontent" xml-lang="en-US">Nepali</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926274450" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926279875" role="tablecontent" xml-lang="en-US">Dzongkha</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926276833" role="tablecontent" xml-lang="en-US">Tibetan characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926272903" role="tablecontent" xml-lang="en-US">Farsi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926271122" role="tablecontent" xml-lang="en-US">East Arabic-Indic characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> <tablecell> - <paragraph id="par_id130820161753311497" role="tablecontent" xml-lang="en-US">Hebrew letters</paragraph> + <paragraph id="par_id180820161926287716" role="tablecontent" xml-lang="en-US">Church Slavic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926281396" role="tablecontent" xml-lang="en-US">Cyrillic characters</paragraph> </tablecell> <tablecell> </tablecell> @@ -1160,6 +1376,18 @@ <paragraph id="par_id130820161753323580" role="tablecontent" localize="false" xml-lang="en-US">CAL 2/8/8 [DBNum2]</paragraph> </tablecell> </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926289664" role="tablecontent" xml-lang="en-US">Hebrew</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926288708" role="tablecontent" xml-lang="en-US">Hebrew numbering</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> </table> @@ -1415,10 +1643,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753365289" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + <paragraph id="par_id150820161449152401" role="tablecontent" xml-lang="en-US">Chinese</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753368507" role="tablecontent" xml-lang="en-US">modern short Kanji text</paragraph> + <paragraph id="par_id150820161449154907" role="tablecontent" xml-lang="en-US">short lower case text</paragraph> </tablecell> <tablecell> </tablecell> @@ -1427,10 +1655,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id13082016175336526" role="tablecontent" xml-lang="en-US">Korean</paragraph> + <paragraph id="par_id130820161753365289" role="tablecontent" xml-lang="en-US">Japanese</paragraph> </tablecell> <tablecell> - <paragraph id="par_id13082016175336224" role="tablecontent" xml-lang="en-US">informal lower case text</paragraph> + <paragraph id="par_id130820161753368507" role="tablecontent" xml-lang="en-US">modern short Kanji text</paragraph> </tablecell> <tablecell> </tablecell> @@ -1439,10 +1667,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id150820161449152401" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + <paragraph id="par_id13082016175336526" role="tablecontent" xml-lang="en-US">Korean</paragraph> </tablecell> <tablecell> - <paragraph id="par_id150820161449154907" role="tablecontent" xml-lang="en-US">short lower case text</paragraph> + <paragraph id="par_id13082016175336224" role="tablecontent" xml-lang="en-US">informal lower case text</paragraph> </tablecell> <tablecell> </tablecell> @@ -1471,35 +1699,35 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753363281" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + <paragraph id="par_id150820161449158539" role="tablecontent" xml-lang="en-US">Chinese</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753366963" role="tablecontent" xml-lang="en-US">traditional short Kanji text</paragraph> + <paragraph id="par_id150820161449151367" role="tablecontent" xml-lang="en-US">short upper case text</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753361880" role="tablecontent" localize="false" xml-lang="en-US">[DBNum4]</paragraph> </tablecell> <tablecell> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id130820161753376004" role="tablecontent" xml-lang="en-US">Korean</paragraph> + <paragraph id="par_id130820161753363281" role="tablecontent" xml-lang="en-US">Japanese</paragraph> </tablecell> <tablecell> - <paragraph id="par_id130820161753375830" role="tablecontent" xml-lang="en-US">informal upper case text</paragraph> + <paragraph id="par_id130820161753366963" role="tablecontent" xml-lang="en-US">traditional short Kanji text</paragraph> </tablecell> <tablecell> + <paragraph id="par_id130820161753361880" role="tablecontent" localize="false" xml-lang="en-US">[DBNum4]</paragraph> </tablecell> <tablecell> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id150820161449158539" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + <paragraph id="par_id130820161753376004" role="tablecontent" xml-lang="en-US">Korean</paragraph> </tablecell> <tablecell> - <paragraph id="par_id150820161449151367" role="tablecontent" xml-lang="en-US">short upper case text</paragraph> + <paragraph id="par_id130820161753375830" role="tablecontent" xml-lang="en-US">informal upper case text</paragraph> </tablecell> <tablecell> </tablecell> @@ -1608,4 +1836,4 @@ </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |