Free Support Forum - aspose.com

Formulas and appending a string

Is it possible to use SetCellValue(= 12 * 5) and also append a string at the end so the end result would be “60 widgets”?

Hi,

Thanks for considering Aspose.

I think you may try:

Aspose.Grid.Desktop.Worksheet sheet = gridDesktop1.Worksheets[gridDesktop1.ActiveSheetIndex];
Aspose.Grid.Desktop.GridCell cell = sheet.Cells["C1"];
cell.Value = "=12*5";
cell.SetCellValue(cell.Value + " widgets");

Thank you.