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.
FlavioNuovo file—CORTE C—Dati_Input_Curve (2).zip (93.0 KB)