Bug 131846 - "HH:MM:SS,0" doesn't work
Summary: "HH:MM:SS,0" doesn't work
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-03 08:06 UTC by contacto.atezllan
Modified: 2020-04-03 13:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
In this image you can see field format configuration (32.70 KB, image/png)
2020-04-03 08:08 UTC, contacto.atezllan 		Details
In the next image you can see the result of putting the values. They all end in .0 (18.67 KB, image/png)
2020-04-03 08:11 UTC, contacto.atezllan 		Details
ODB file (44.02 KB, application/vnd.sun.xml.base)
2020-04-03 10:57 UTC, contacto.atezllan 		Details
TIME-field with 1/10 seconds (57.08 KB, application/vnd.oasis.opendocument.database)
2020-04-03 13:38 UTC, Robert Großkopf 		Details
Time field with 1/10 seconds - Firebird (56.85 KB, application/vnd.oasis.opendocument.database)
2020-04-03 13:45 UTC, Robert Großkopf 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description contacto.atezllan 2020-04-03 08:06:06 UTC 
Description:
When I configure the TIME format type with: H:MM:SS,0 and I put the next value: 3:20:15,7 LibreOffice changes it to 3:20:15,0

Always ',0', impossible to put any other number,

Steps to Reproduce:
1. Create a new table and column with the next field type: Time [TIME].
2. Configure this field with the next format: H:MM:SS,0
3. Save the table and open it.
4. Insert the next value: 3:10:25,7


Actual Results:
LibreOffice saves the next value: 3:10:25,0

Expected Results:
LibreOffice should save the inserted value (3:10:25,7).


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.2.2 (x64)
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: en-US (es_ES); UI-Language: en-US
Calc: threaded
Comment 1 contacto.atezllan 2020-04-03 08:08:05 UTC 
Created attachment 159286 [details]
In this image you can see field format configuration
Comment 2 contacto.atezllan 2020-04-03 08:11:24 UTC 
Created attachment 159287 [details]
In the next image you can see the result of putting the values. They all end in .0
Comment 3 Robert Großkopf 2020-04-03 10:20:07 UTC 
Which database do you use?

Internal databases:

HSQLDB: 
You will need a TIMESTAMP-field.
You need to change the TIMESTAMP-field to save values, which are less then 1 second. 

Firebird:
Should work with TIME as you expect ist.
Comment 4 contacto.atezllan 2020-04-03 10:40:49 UTC 
Not working...

Images:
https://i.imgur.com/zqYk8v5.png
https://i.imgur.com/FGgLqxO.png

It doesn't work either:

H.MM.SS[.F]
Comment 5 Robert Großkopf 2020-04-03 10:51:25 UTC 
Are you using HSQLDB?

I don't know your tablename. Please add it to the command.

Open Tools > SQL
ALTER TABLE "your tablename" ALTER COLUMN "Temps" TIMESTAMP(6)
Comment 6 contacto.atezllan 2020-04-03 10:57:52 UTC 
Created attachment 159294 [details]
ODB file

I have uploaded the file to see if you can solve this problem. 

'Resultats' table and 'Temps' column.
Comment 7 QA Administrators 2020-04-03 11:11:48 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2020-04-03 13:38:04 UTC 
Problem here: You could use the TIMESTAMP, but it needs input in the the form

YYYY-MM-DD HH:MM:SS,00

So it wont work without a date input.
I have solved this problem in a database by macro in a HSQLDB-database.

For your database I have only changed to Firebird Database and changed the file back to TIME. It works now.
Comment 9 Robert Großkopf 2020-04-03 13:38:41 UTC 
Created attachment 159300 [details]
TIME-field with 1/10 seconds
Comment 10 Robert Großkopf 2020-04-03 13:45:41 UTC 
Created attachment 159301 [details]
Time field with 1/10 seconds - Firebird
Comment 11 contacto.atezllan 2020-04-03 13:54:11 UTC 
Thanks for your help.

Regards.