[Solved] Leading Zero in Base

Creating and using forms
Post Reply
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

[Solved] Leading Zero in Base

Post by Mickey12 »

Hi I am unable to get the leading zero to show in a form. I have tried added leading zero in format and also changed to text. Nothing doing.
Last edited by Mickey12 on Tue Apr 28, 2020 12:13 pm, edited 1 time in total.
Open Office 4.1.7 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Leading Zero in Base

Post by Villeroy »

If the table column type is numeric (integer, decimal, floating point etc), you can use either a formatted field or a numeric field and format to your liking.
If the table column type is text, you have to enter the leading zero because the text "0123" differs from the text "123". In this case you should use a pattern field.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply