we are using Aspose.cells.dll to export string value to Excel, due to some reason, we add a leading apostrophe to every string, this apostrophe is invisible in cell, but visible in format window, and this is expected.
The problem is we found not every string has this leading apostrophe in format window after being exported, it seems there is a pattern, in that only every second line has this leading apostrophe, please check the problem using attached .xlsx
when focusing on description column, t1, t3, t5 do have a leading apostrophe, but t2, t4, t6 do not.
is this a problem in Aspose.Cells.dll?
Workbook sourceWorkbook = new Workbook(path + “testplan4.xlsx”);
// get collection of cells
Cells cells = sourceWorkbook.Worksheets.Cells;
// iterate through the cells
foreach (Cell cell in cells)
Console.WriteLine(cell.Name + " : " + ("’" + cell.StringValue));
Console.WriteLine(cell.Name + " : " + cell.StringValue);