Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
How to create worksheets containing formulae?
posted

 I tried thisbriefly and it doesn't work as intended

            Infragistics.Excel.Workbook workbook = new Workbook();
           
            workbook.Worksheets.Add("test");
            Infragistics.Excel.Worksheet sheet = workbook.Worksheets[0];
            sheet.Rows[0].Cells[0].Value = 5.05;
            sheet.Rows[1].Cells[0].Value = "=A1+1";

when I wxport it to excel, A2 shows =A1+1, and I have to go into the cell and press enter again for it to update to 6.05, and pressing F9 doesn't update the cell. How can I do this properly? Thank you

Parents Reply Children
No Data