Bug 82411 - Numeric fields are limited to Integer-Values in Tablecontrols and Databrowser of a Form
Summary: Numeric fields are limited to Integer-Values in Tablecontrols and Databrowser...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Database-Forms
  Show dependency treegraph
Reported: 2014-08-10 07:00 UTC by Robert Großkopf
Modified: 2020-08-16 13:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

Different values for the same field in the form, when numeric fields are chosen (11.49 KB, application/vnd.oasis.opendocument.base)
2014-08-10 07:00 UTC, Robert Großkopf

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2014-08-10 07:00:59 UTC
Created attachment 104369 [details]
Different values for the same field in the form, when numeric fields are chosen

Open the attached document.
open the form.
There is a tablecontrol and the same fields are shown in "normal" controls.
Two fields (one for BigInt, one for Decimal 13 digits) are formatted as numeric fields and limited by the max value of the field.
The numeric fields in the tablecontrol show the wrong values. Seems to be limited for Integer values.
The numeric fields outside the tablecontrol show the right values.

I first saw this when I chose in the navigationbar "Datasource as Table". Seems to be the same problem. "Datasource as Table" seems to work like "tablecontrols".
Comment 1 Alex Thurgood 2014-10-14 13:46:02 UTC

In the table grid view of the underlying data when displayed via the "datasource as a table button", the numeric fields do not show a "Format" property.

I suspect that this might have something to do with the recent UI rework.
Comment 2 Alex Thurgood 2014-10-14 13:47:42 UTC
@Robert : this is set as "inherited from OOo", surely not ? Didn't this work previously ?
Comment 3 Alex Thurgood 2014-10-14 13:49:31 UTC
I can reproduce in LO 4322 on OSX, setting OS to All
Comment 4 Alex Thurgood 2014-10-14 14:02:15 UTC
OK, skip the IU rework comment, I see the same problem in LO 4142.
Comment 5 Alex Thurgood 2014-10-14 14:09:51 UTC
I also see the problem in LO 3672
Comment 6 Alex Thurgood 2014-10-14 14:11:51 UTC
Problem also in OOo 321 320m18 (build 9502)
Comment 7 Lionel Elie Mamane 2014-10-14 17:23:06 UTC
This looks like an overflow of a 32 bit value.
Comment 8 Alex Thurgood 2015-01-03 17:41:24 UTC
Adding self to CC if not already on
Comment 9 QA Administrators 2016-01-17 20:05:23 UTC Comment hidden (obsolete)
Comment 10 Alex Thurgood 2016-01-19 13:46:11 UTC
Confirming still present on 

Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale : fr-FR (fr.UTF-8)

OSX 10.11.2
Comment 11 QA Administrators 2017-03-06 14:40:59 UTC Comment hidden (obsolete)
Comment 12 Robert Großkopf 2017-03-06 20:00:03 UTC
Bug still exists with LO, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 13 QA Administrators 2018-03-07 03:40:44 UTC Comment hidden (obsolete)
Comment 14 Robert Großkopf 2018-03-07 17:54:42 UTC
Bug still exists with LO, OpenSUSE 42.3 Leap, 64bit rpm Linux.
Comment 15 QA Administrators 2019-03-08 03:40:45 UTC Comment hidden (obsolete)
Comment 16 Robert Großkopf 2019-03-08 15:55:52 UTC
Same buggy behaviour with LO on OpenSUSE 15 64bit rpm Linux.
Comment 17 Sébastien Ducoulombier 2019-05-07 16:52:08 UTC
Still in LO 64-bit AppImage (tested on Debian 9.8)