Enquiry

[jon80]

I have this problem aggregating very large numbers (Version: 6.4.0.0.beta1 (x64)), adding up data that relates to economics, try importing data from http://www.nso.gov.mt which is a statistical service as a test case.

I was trying to create a financial model for demonstration of economic risk, as per books normally, found in bookstores.

[Zizi64]

Jon
_____________________________________
Open Office 3 on Win XP SP 3

Please update your signature in this forum. I can not believe if you use that archaic old version today.

[Zizi64]

The AOO and LO Calc uses the 8 byte, double precision floating point numbers, according to the IEEE 754-2008 standard. The Calc uses it even for the integer values.
This numeric representation has a "dynamic precision limit":
https://en.wikipedia.org/wiki/Double-pr ... int_format

[jon80]

i tried using SUM, and through the interface without a programming interface I cannot quite adjust the formula to accept new numbers since you are doing the error trapping so far.

[Zizi64]

Please upload an ODF type sample file here.

[jon80]

The file is too big, maximum allowed size is 128 KiB, reads your error message, calculation is simple multiplication for demonstration of concept of programmability.

e.g. =N2*K2*L2*[40000] is a large number, requiring representation logic.

[Zizi64]

Just create a small file with some huge numbers and the relevant cell functions.