[Solved] Leading Zero in Base

Creating and using forms

[Solved] Leading Zero in Base

Postby Mickey12 » Mon Apr 27, 2020 10:45 am

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
Posts: 73
Joined: Thu Apr 16, 2020 3:07 pm

Re: Leading Zero in Base

Postby Villeroy » Mon Apr 27, 2020 1:59 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28683
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Forms

Who is online

Users browsing this forum: No registered users and 3 guests