Ask Your Question

LO Base is not saving the field formatting when editing a table [closed]

asked 2016-03-04 22:55:52 +0200

David M gravatar image

updated 2016-03-04 22:57:42 +0200


I have a Pattern Field Mask using the Form Editor, in a little HSQLDB. I'm trying to avoid typos in an important field (the geographic position of the data taken). So I used the following mask:

NNLNN as the Edit Mask

"GG:DD" as the Literal Mask.

Let say I named the field as LAT. Then, in the Table editor, in the corresponding LAT field format example, I choose 2 leading zeros and 2 decimal places... so the data should be stored as: 09.45

The format field in Table Editor

Everything works OK during a session, but when I close LO, and I start the following day, the LAT field format example is lost to the default settings, so the data is stored as 9.45 (note there isn't a leading zero anymore). And this cause display problems in the Form... say instead of visualizing the data as 09.45, all I see is 94.5D

The last D came from the literal mask.

So, what I need is a way to set the LAT format field in a way it doesn't change between sessions.

Help is greatly appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by David M
close date 2016-03-07 16:11:56.763353

2 Answers

Sort by » oldest newest most voted

answered 2016-03-07 02:58:06 +0200

Ratslinger gravatar image

Look at the Format of the field in the table. Is it set to 2 leading zeros?

edit flag offensive delete link more

answered 2016-03-07 15:34:47 +0200

David M gravatar image

updated 2016-03-07 16:10:57 +0200

Hi. That's my problem, actually. I set the format to 2 leading zeros, but when I close LO and I open it again, say the next day, the formatting is lost. Any idea why? Thanks

[EDIT] You were right, I was making the changes in the Edit Table window... But the permanent changes are made in the Table window, right click on the column, and Column Format. Thanks a lot!

edit flag offensive delete link more


@David M, This was useful to me. Thank you.

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 20:09:14 +0200 )edit

Question Tools

1 follower


Asked: 2016-03-04 22:55:52 +0200

Seen: 179 times

Last updated: Mar 07 '16