Ask Your Question

Is there a maximum number which a Base field can handle?

asked 2019-02-26 18:41:55 +0200

Quarto Die gravatar image

updated 2019-02-26 19:04:40 +0200

In Libre Office Base Version: on Linux Mint 19.1

I am trying to enter the number 4.314086505E+023 (431,408,650,500,000,000,000,000) in a Libre Office Base table numeric field 4.314086505E+023 but it always reverts to something less than what I entered, such as just 4.3. I find it will accept a number such as: 1,000,000,000,000,000,000,000,000 which is even larger but when I put 430 at the start of the number when I move on to the next record all goes back to 4.3 with no exponent. Even in scientific format this does not work. I suppose I should be using Calc with these numbers but I am less familiar with it. In calc, I cannot figure out how to rapidly calculate several rows of numbers in one column, (if someone could direct me to to do that should these numbers be too astronomical for base, I would be thankful) whereas in base I can do this in a query.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-26 19:38:00 +0200

Ratslinger gravatar image


Seems to work on Mint 18.3 with LO With a type of Double:

image description

using format:

image description

edit flag offensive delete link more


Thank you in effect, that does seem to work and the DOUBLE seems to be able to compute with numbers in Calculations.

Quarto Die gravatar imageQuarto Die ( 2019-02-26 23:29:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-26 18:41:55 +0200

Seen: 32 times

Last updated: Feb 26