Bug 103497 - FORMATTING: Fields in forms should be created with same format as defined in table.
Summary: FORMATTING: Fields in forms should be created with same format as defined in ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2016-10-25 14:29 UTC by Robert Großkopf
Modified: 2017-11-05 21:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2016-10-25 14:29:31 UTC
This enhancement-request comes from a German LO-forum:
When creating a table and define, for example, a field for TIME, there will be a standardformat '00:00:00' (hours:minutes:seconds). 
When creating a form for this table the field in the form has standardformat '00:00' (hours:minutes). Uninformed users would miss the input for seconds here and don't know, that is defined in a different way.

That isn't the only field with different standardformatting. Have a look at a field with INTEGER-AutoValue. This will be created in the form wizard as a decimal with two digits. Every time I create a form by the wizard I have to reset this field to a field without digits.

When creating a form it would be great to get the format from the table. If you want to change this, you could do it later. But if you won't you have excluded one step and the uninformed user isn't irritated about different forms.

Have a look at bug86315 . If this bug is solved you could also read out the format of queries and define the defaultformat of a form, which has a query as datasource.
Comment 1 Alex Thurgood 2016-11-03 09:49:49 UTC
Lionel : is this behaviour down to our use of Calc's number formatter for determining the field format applicable by default ?
Comment 2 Lionel Elie Mamane 2016-11-03 10:25:54 UTC
I was under the impression that the wizard actually did that... Not sure now.