Bug 131846

Summary: "HH:MM:SS,0" doesn't work
Product: LibreOffice Reporter: contacto.atezllan
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: robert
Priority: medium    
Version: 6.4.2.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: In this image you can see field format configuration
In the next image you can see the result of putting the values. They all end in .0
ODB file
TIME-field with 1/10 seconds
Time field with 1/10 seconds - Firebird

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.