Karl <k...@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
From 9e0bd490de02e7900c5c7b0c3cd96fa26868fc90 Mon Sep 17 00:00:00 2001
From: Karl O. Pinc <k...@meme.com>
Date: Tue, 7 Jun 2011 10:26:06 -0500
Subject: [PATCH] Patch for bug #36057
"Docs don't mention that time format using [] is needed to show hours non-modulo 24"
Add new paragraph and example table to the help text having to do with time
formatting explaining the use of [].
Note that this patch is very likely wrong. I wasn't able to figure out
how to edit the help text using LibreOffice/OOO. As a result
neither the paragraph nor the table elements have the required id
attributes. Further, the table is slightly odd in that it has
2 lines of headings, the first of which spans the entire table,
and it has an entirely empty column so as to, in effect, have
two tables side by side in order to compare what happens with
and without the use of square braces.
---
helpcontent2/source/text/shared/01/05020301.xhp | 78 +++++++++++++++++++++++
1 files changed, 78 insertions(+), 0 deletions(-)
diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp
index d89091a..b5d1a4c 100644
--- a/helpcontent2/source/text/shared/01/05020301.xhp
+++ b/helpcontent2/source/text/shared/01/05020301.xhp
@@ -902,6 +902,84 @@
</tablerow>
</table>
+<paragraph role="paragraph" xlm-lang="en-US" l10n="U">The display of the hour, minute, and second components of the time is capped at the maximal number of hours in a day (or 12 hour period), minutes in an hour, or seconds in a minute. To suppress this behavior use square brackets, [], as illustrated in the following table.</paragarph>
+<table>
+<tablerow>
+<table cell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U">Display of the value 1 day, 1 hour, 25 minutes, 9 seconds</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U">Format Code</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U">Output Displayed</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U">Format Code</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablehead" xml-lang="en-US" l10n="U">Output Displayed</paragraph>
+</tablecell>
+<tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">HH:MM:09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">01:25:09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">[HH]:MM</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">25:25:09</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">MM:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">25:09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">[MM]:SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">1525:09</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">SS</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">09</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U"></paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="code" xml-lang="en-US" l10n="U">[SS]</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" xml-lang="en-US" l10n="U">91509</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
<paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph>
<paragraph role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph>
<paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph>
--
1.7.2.5
_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice
