[Libreoffice-bugs] [Bug 138409] FIREBIRD: decimal fields in table are falsifying their default values

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138409

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |lionel at mamane.lu

--- Comment #8 from Julien Nabet <serval2412 at yahoo.fr> ---
With the last test file attached (Firebird embedded test file ok (created with
en-US locale), I made this other test:
- change to French locale (so decimal separator is ",")
- open this last file (editing table field shows that it can't display by
default value as I previously indicated)
- create a new table with:
- "Decimal places":2
- "Default value":12,22
- save

As expected, inserting a new row doesn't work, it display "12,00" then save
"0,12" but when editing table field, everything seems ok.

Lionel: I think the only place to change is field edition, for both when
reading and when writing.
I'm quite sure that internally, the decimal separator should/must be stored
with a "." (since most programming languages are in English).
To make decimal separator "," work, we need an extra display treatment layer.
This is done when inserting records in table (the first one displays ","
whereas it's been created with en-US locale) but not when editing a field of a
table.
What do you think?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201206/26d9c636/attachment.htm>