[Libreoffice-bugs] [Bug 53027] EDITING: dBase-Import-Wizard fails when trying to append DECIMAL(NUMERIC) and BOOLEAN data types

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 23 22:45:53 UTC 2017


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

--- Comment #27 from Julien Nabet <serval2412 at yahoo.fr> ---
Lionel: I noticed this comment from
http://opengrok.libreoffice.org/xref/core/sc/source/ui/docshell/docsh8.cxx#708
    708             // 538 MUST: Sdb internal representation adds 2 to the
field length!
    709             // To give the user what he wants we must subtract it here.
    710              //! CAVEAT! There is no way to define a numeric field with
a length
    711              //! of 1 and no decimals!
(been there since initial commit)

Indeed, I can't create a simple odb file HSQL Embedded with 2 fields:
"id" INTEGER (primary key)
"test" NUMERIC (length = 1 + no decimals)
in this case, length value is changed to 10

If I put length = 2, the value stays unchanged.

Do you know the reasons for this?

-- 
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/20170623/cbbf3ec6/attachment.html>


More information about the Libreoffice-bugs mailing list