Karl <kop@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 <kop@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
Context
- [Libreoffice] Patch to help text to document use of [] in time formats · Karl O. Pinc
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.