I am using Aspose.Cell 7.3.2 and having issue with workSheet.Cells.GetColumnWidthPixel method. The issue is that this method retuning higher value compare to Aspose.Cell 6.0.0 with the same excel file and that’s causing problem with the word table I am creating from the excel table using Aspose.Word in my application. Since I am using Aspose.Word in my application as well before I was thinking this is Aspose.Word issue so I posted this table issue here in Aspose.Word section but I narrow down the issue and it’s happening because of this workSheet.Cells.GetColumnWidthPixel method which is retuning different value.
Try this sample code with attached excel file with 6.0.0 and 7.3.2 Aspose.Cells versions :
const string excelFile = @“C:\Users\meetp\Desktop\NewProspectiveUnlockingTable.xlsx”;
var wb = new Workbook(excelFile);
var displaySheet = wb.Worksheets[“Display”];
var cell= displaySheet.Cells[“M5”];
var columnWidth = displaySheet.Cells.GetColumnWidthPixel(12);
you will notice that column width is different with both versions.
I am more looking for temporary solution of this issue for now since we can’t change aspose version in our application near soon.
Ok. But why it’s (v7.3.5.x) returning different value than 6.0.0?
In v7.3.5.x it’s returning 12 and in 6.0.0 it’s returning 10. Try with Aspose.Cells 6.0.0 and you will see. I need to know what has been changed to fix my issue.
Thanks - Meet