DSUM function

[carlvaillancourt]

Hi,

The DSUM function does not seem to be supported, is it something that will be added in the future. We have an excel file that uses it a lot, making it impossible to use your API for us.

Thank you!

[sweety1]

Hello,

Thanks for your inquiry.

Spire.XLS supports DSUM function, while Free Spire.XLS doesn't support it. Please download Spire.XLS via link below and have a try:
http://www.e-iceblue.com/Download/download-excel-for-net-now.html

And here is the sample code

Code: Select all

 Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"test.xlsx");
            Worksheet wsSheet = workbook.Worksheets[0];       
            string currentFormula = "=DSUM(A1:C9,3,D1:D2)";
            wsSheet.Range["D4"].Formula = currentFormula;
            workbook.CalculateAllValue();       
            wsSheet.Range["D4"].Text = wsSheet.Range["D4"].FormulaValue.ToString();
            workbook.SaveToFile("Sample.xlsx");
            System.Diagnostics.Process.Start("Sample.xlsx");

Best Regards,
Sweety
E-iceblue support team

[carlvaillancourt]

Yes it is working now.

Thank you very much

[sweety1]

Hello,

Please feel free to contact us, if you have any questions or needs. We are here for help.

Sincerely,
Sweety

E-iceblue support team