Basically, I have been trying to make my C# program use Excel’s NORMDIST(x, mean, st.dev, cumulative) function on an Excel template than I have already generated, to generate a point on a graph, and I seem to be having a problem with Aspose when it exports the Excel to PDF.
//Values have been input into the Workbook
sheet1.Cells[“A1”].Formula = “=NormDist(B1, A2, A3, False)”;
//Export Excel to PDF
When the excel is the exported to PDF, the values become Cumulative (changing the False to True in the formula), and I have no idea why this happens?
I put a break point before it exports to see if it was Workbook.CalculateFormula() that calculated the value incorrectly but when I look at the values in the PDF document they are cumulative.
Please help, many thanks.
PS. Here is a link to my other post, incase it gets a reply and this one doesn’t.