Bug 105223 - TIMEVALUE (ORARIO.VALORE in IT) Calc function
Summary: TIMEVALUE (ORARIO.VALORE in IT) Calc function
Status: RESOLVED DUPLICATE of bug 105226
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 105224 (view as bug list)
Depends on:
Blocks:
 
Reported: 2017-01-09 21:25 UTC by gmarco
Modified: 2018-01-23 15:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sample test ods (22.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-01-09 21:25 UTC, gmarco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gmarco 2017-01-09 21:25:01 UTC
Created attachment 130291 [details]
sample test ods

In the attached "Calc timevalue odssample" you can see and verify my tests:
=ORARIO.VALORE("00.00") cannot anyway display as result "12.00.00m." (cell format "H.MM.SS AM/PM" or "HH.MM.SS AM/PM") where "m." stays for antimeridian.
=ORARIO.VALORE("24.00”) cannot anyway display as result "12.00.00m." (cell format "H.MM.SS AM/PM" or "HH.MM.SS AM/PM") where "m." stays for antimeridian.
Further I note that anti and post meridian espress in Calc with the letters "m." and "p." are unusual symbols (in IT we generally use “a.m. or am" and "p.m. or pm" lower or uppercase):
I translate what you can read about at the link http://tp.linux.it/data_ora_valuta.html
TIMEVALUE.
The conventional notation to indicate a time in Italian language is "o:mm:ss"
with the hour expressed in 24-hour format without leading zero.
Expressed in the syntax of the GNU program date(1) becomes: %k:%M:%S
Examples:
13:00:56
4:12
The presence of leading zeros (obtained with dates(1) by replacing the %k with %H) is allowed in case you have the need for alignment issues or ordering.
It should be noted, that only for the alignment motivation, the agreement for date(1) provides for the possibility to use the "_" and "-" modifiers to hide some digit.
Consult the man page for more information.
In case you must use the 12-hour format, morning and afternoon should be rendered as "a.m." and "p.m.". Any other expression (AM/PM or A.M./P.M and so on) is to be avoided.
Also in case you must use the 12-hour format, the issue date(1) to use for the hour is %-I
Comment 1 Buovjaga 2017-01-13 18:40:14 UTC
Luca: what do you think?
Comment 2 gmarco 2017-01-13 22:05:44 UTC
(In reply to Buovjaga from comment #1)

Hi Buovjaga,
why this post (#105223) as mine was and is #105224?
Comment 3 Buovjaga 2017-01-14 09:31:41 UTC
*** Bug 105224 has been marked as a duplicate of this bug. ***
Comment 4 Buovjaga 2017-01-14 09:32:19 UTC
(In reply to gmarco from comment #2)
> (In reply to Buovjaga from comment #1)
> 
> Hi Buovjaga,
> why this post (#105223) as mine was and is #105224?

Because you apparently posted it twice.
Comment 5 Winfried Donkers 2018-01-23 15:36:02 UTC

*** This bug has been marked as a duplicate of bug 105226 ***