none
EPPlus excel not caluculating formula output after binding RRS feed

  • Question

  • ExcelPackage pck = new ExcelPackage(@"D:\MYSheets\EmptyFile.xlsx");
    var ws = pck.Workbook.Worksheets["MySheet"];
    
    ws.Cells["A3"].Value = "2.3";
    ws.Cells["A4"].Value = "10.2";
    
    ws.Cells["A5"].Formula = "=SUM(A3:A4)";
    ws.Cells["A5"].Style.Numberformat.Format = "#,##0.00";
    pck.Save();
    Thursday, June 13, 2013 3:59 AM

Answers

  • Hi Rajasekhar raju, This forum is for software developers who are using the Open Specification documentation to assist them in developing systems, services, and applications that are interoperable with Microsoft products. The Open Specifications can be found at: http://msdn.microsoft.com/en-us/library/cc203350(PROT.10).aspx. Since your post does not appear to be related to the Open Specification documentation set we would appreciate it if you could try to post your question in a more relevant forum. You might want to try posting your question on the CodePlex Discussions page for EPPlus.

     

    http://epplus.codeplex.com/discussions


    Josh Curry (jcurry) | Escalation Engineer | Open Specifications Support Team

    Thursday, June 13, 2013 3:31 PM
    Moderator