In my ultragrids I have options for exporting to excel using the UltragridExcelExporter. When I export I do not want the formulas to be exported, just the cell data. How can I do this?
Currently this is the code I am using to export my grids:
var filePath = Application.StartupPath + "\\Export-" + Guid.NewGuid().ToString() + ".xls"; var wkBook = new Workbook(); wkBook.Worksheets.Add("Margins"); excelExporter.Export(grdMain, wkBook, 0, 0); excelExporter.Export(grdSupp, wkBook, 75, 1); wkBook.Save(filePath); System.Diagnostics.Process.Start(filePath);
Thanks!
Found the answer... ExportFormulas = false;
I thought I had deleted this thread, but I guess I did not.