com.aspose.cells.CalculationPrecisionStrategy.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






CalculationPrecisionStrategy





com.aspose.cells

Class CalculationPrecisionStrategy
java.lang.Object
    com.aspose.cells.CalculationPrecisionStrategy



public class CalculationPrecisionStrategy extends java.lang.Object




Utility class containing constants. 
            Enumerates strategies for handling calculation precision.
            Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result.
            Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue,
            some special strategies may give the expected result.
            











Field Summary




static final int NONE 
          
            No strategy applied on calculation.
            When calculating just use the original double value as operand and return the result directly.
            Most efficient for performance and applicable for most cases.
            




static final int ROUND 
          
            Rounds the calculation result according with significant digits.
            




static final int DECIMAL 
          
            Uses decimal as operands when possible.
            Most inefficient for performance.
            

 







Field Detail



NONE 
public static final int NONE

            No strategy applied on calculation.
            When calculating just use the original double value as operand and return the result directly.
            Most efficient for performance and applicable for most cases.
            




ROUND 
public static final int ROUND

            Rounds the calculation result according with significant digits.
            




DECIMAL 
public static final int DECIMAL

            Uses decimal as operands when possible.
            Most inefficient for performance.
            






See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Field Summary
`static final int`	`NONE`
`static final int`	No strategy applied on calculation. When calculating just use the original double value as operand and return the result directly. Most efficient for performance and applicable for most cases.
`static final int`	`ROUND`
`static final int`	Rounds the calculation result according with significant digits.
`static final int`	`DECIMAL`
`static final int`	Uses decimal as operands when possible. Most inefficient for performance.

com.aspose.cells.CalculationPrecisionStrategy.html Maven / Gradle / Ivy

com.aspose.cells Class CalculationPrecisionStrategy

NONE

ROUND

DECIMAL

com.aspose.cells
Class CalculationPrecisionStrategy