It seems that there were accuracy issues in version 1.1 of Calc.Any info on whether things have improved in more recent versions of Calc?How does Calc compare with Excel in numerical accuracy?

Excel has three sets of calculation mode.Sheets are done in extended precision, ie 80 bit.VBA works in a mix of single and double precision (32 and 64 bit)Add-ins are usually 64 bit, but as C++ apps may choose to use extended precision.

QuoteOriginally posted by: DCFCExcel has three sets of calculation mode.Sheets are done in extended precision, ie 80 bit.VBA works in a mix of single and double precision (32 and 64 bit)Add-ins are usually 64 bit, but as C++ apps may choose to use extended precision.THe issue is the algorithms used, not the precision.Precision means nothing with faulty algorithms.

QuoteOriginally posted by: kaikowIt seems that there were accuracy issues in version 1.1 of Calc.Any info on whether things have improved in more recent versions of Calc?How does Calc compare with Excel in numerical accuracy?I don't remember what versions I was using when I looked at some of the stats functions in Calc, Excel and Gnumeric, but IIRC Gnumeric was the best, followed by Excel. The differences were not that great (I have no need for high precision stas, so my perception may be far different for someone who needs super high accuracy). Gnumeric had other flaws, but certainly is the fastest for correcting and improving function accuracy.If you need the high accuracy and want to stay in the spreadsheet world, download the code from Ian Smith. http://members.aol.com/iandjmsmith/examples.xlsHis site seems to be down, but the link to the Excel file still works. A newsgroup poster far more skilled than I in this realm has commented numerous times saying how good it is, and that Ian's stuff is better than some dedicated stats packages. EDIT: His site is still up...here is the link to the numerical analysis page. http://members.aol.com/iandjmsmith/iansNApage.htm

QuoteOriginally posted by: MMPQuoteOriginally posted by: kaikowIt seems that there were accuracy issues in version 1.1 of Calc.Any info on whether things have improved in more recent versions of Calc?How does Calc compare with Excel in numerical accuracy?I don't remember what versions I was using when I looked at some of the stats functions in Calc, Excel and Gnumeric, but IIRC Gnumeric was the best, followed by Excel. The differences were not that great (I have no need for high precision stas, so my perception may be far different for someone who needs super high accuracy). Gnumeric had other flaws, but certainly is the fastest for correcting and improving function accuracy.If you need the high accuracy and want to stay in the spreadsheet world, download the code from Ian Smith. http://members.aol.com/iandjmsmith/examples.xlsHis site seems to be down, but the link to the Excel file still works. A newsgroup poster far more skilled than I in this realm has commented numerous times saying how good it is, and that Ian's stuff is better than some dedicated stats packages. EDIT: His site is still up...here is the link to the numerical analysis page. http://members.aol.com/iandjmsmith/iansNApage.htmFor those of us who are programmers, it's not difficult to create a DLL with accurate algorithms, but I want to look at this from the perspective of the masses who take on faith that Excel or Calc uses appropriate algorithms. Such users have to stay in the spreadsheet world.When I saw the statements about the accuracy issues in Calc 1.1, I became concerned about the design decisions that went into calc.