Free Support Forum - aspose.com

Merged Cells not merged in Aspose

I have a simple excel worksheet with merged cells. When I look at the Cell object in Aspose, the isMerged property is showing as false. When I save an image of the sheet, all of the text is showing in the left hand column instead of showing merged accross the 2 cells like it should. I saw another post mentioning a fix. Can I get that fix if it is appropriate?

Hi,

Please try the attached version/fix v4.8.0.11. If you still find the issue, kindly post your template file with sample code to re-produce the issue, we will check it soon.


Thank you.

Here is some sample code.

Hi,

Please use Workbook.Open() method instead of Workbook.LoadData(). For your information, if you use LoadData method, the formattings, objects might lost as it only reads data in the workbook.

e.g (you may change your code to):
Workbook wb = new Workbook();
wb.Open("./Book1.xls");
Worksheet worksheet = wb.Worksheets[0];
worksheet.Cells[“A1”].PutValue(“Hello”);
wb.Save(“C:\BookUpdated.xls”);


Thank you.