[xubuntu-users] LibreOffice Base misbehavior

[Roger Broseus]

On January 29, 2015 3:48:32 PM EST, Paul <pmanos at sbcglobal.net> wrote:
>I recently set up a database using LibreOffice Base.  in one of my 
>tables I have a field named AMOUNT which I typed as NUMERIC with 2 
>decimal places (it is a money field).

I have better luck with Oracle Open Office. Seems to be more well behaved. Problem is, one has to totally uninstall Libre before installing the other. Then, register DBs, etc.

>When I enter data into that field of the table strange things happen.  
>If I enter a complete decimal amount such as 123.45 or 123. the value 
>will register as 0.00 whenever I move out of the field. If I enter the 
>value 123 then it is accepted and shows as 123.00. At this point I am 
>free to correct the value to my desired 123.45 and it is accepted.
>
>I have experimented with changing the field's type from NUMERIC to 
>several other numerical types.  None behaved any better; but, on one 
>occasion when I returned to typing the field as NUMERIC it worked 
>correctly.  I have no clue about why or what detail was different that
>time.
>
>Paul Manos

--
"Linux.Rog"