Hello,
we are using Aspose.Cells to read the equation of a trendline in an Excel file from its label, to do this we have followed the instructions reported in the Aspose documentation (https://docs.aspose.com/cells/net/get-equation-text-of-chart-trendline/). When we read the equation of the trendline from our excel file the value get by Aspose does not match the value written in the Excel.
Below I report both values:
-
Excel value: y = 2,73412452858917E-14x5 - 1,36684786729484E-10x4 + 2,50451351052486E-07x3 - 2,09907409068621E-04x2 + 6,76259404128956E-02x + 1,83817780754589E+01
-
Value get by Aspose: y = 2,73412452881114E-14x5 - 1,36684786740373E-10x4 + 2,50451351071089E-07x3 - 2,09907409081871E-04x2 + 6,76259404171546E-02x + 1,83817780751106E+01
As you can see above the values read by Aspose are the same of the excel for the first 9 digits after the comma, from the 10th digit to the 14th values are different.
Can you please help us in finding a solution to get the right value?
Attached the Excel file we are speaking of (zipped), from which we have to get the values of the Trendline Label.
Thank you
FlavioNuovo file—CORTE C—Dati_Input_Curve (2).zip (93.0 KB)