Enquiry

Discuss the spreadsheet application

Enquiry

Postby jon80 » Tue Mar 24, 2020 12:33 pm

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.
Jon
Open Office 3 on Win XP SP 3
User avatar
jon80
Banned
 
Posts: 9
Joined: Thu Apr 28, 2011 3:53 pm

Re: enquiry

Postby Zizi64 » Tue Mar 24, 2020 12:49 pm

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.
Last edited by Zizi64 on Tue Mar 24, 2020 1:32 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9439
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: enquiry

Postby Zizi64 » Tue Mar 24, 2020 12:54 pm

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
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9439
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: enquiry

Postby jon80 » Tue Mar 24, 2020 1:15 pm

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.
Jon
Open Office 3 on Win XP SP 3
User avatar
jon80
Banned
 
Posts: 9
Joined: Thu Apr 28, 2011 3:53 pm

Re: enquiry

Postby Zizi64 » Tue Mar 24, 2020 1:29 pm

Please upload an ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9439
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: enquiry

Postby jon80 » Tue Mar 24, 2020 1:57 pm

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.
Jon
Open Office 3 on Win XP SP 3
User avatar
jon80
Banned
 
Posts: 9
Joined: Thu Apr 28, 2011 3:53 pm

Re: enquiry

Postby Zizi64 » Tue Mar 24, 2020 2:16 pm

Just create a small file with some huge numbers and the relevant cell functions.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9439
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests