Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index





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


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.