The deviations are mostly much smaller and go unnoticed as the results are rounded to 15 digits for display, but the 'value' of the cell is not corrected accordingly and the deviations may cause boosted errors in downstream calculations. Thus expect unpredictable 'fuzzy' results already in Calc itself. This may vary from function to function and is partly affected / broken by empty cells within the operand stack. for 'SUM' the first 'non-zero' summand is reserved and calculated last to spot a probability that a small result should be zero. The results of Calc still vary due to other influences, e.g. While the results are opposite (Calc wrong) for the following: the sum of this stack will be correct in Calc (0,52) but wrong in Excel (0,51953125): (there are differences between 'floating point math' and 'school math'! fp-math with limited precision is not! associative)Į.g. While excel works 'by row' first top row from left to right and than that downwards row by row.Īs the results of some operations sometimes depend on the order of operands, differences show up. calculate sheets / ranges / operands in different orders: apply different rounding / 'snap-to-zero' to results, apply different rounding to input values, LibreOffice Calc and Microsoft Excel often compute slightly different results.Įxpect (often invisible) deviations between results from Calc and Excel as they: LibreOffice Calc cannot properly work with Microsoft Excel's xlsm files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |