Hi,
We are using the Aspose.Cells.jar version of 2.1.0.0. The following piece of code is working fine in windows environment to set autoFitColumns for all the cells in the worksheet.
Workbook srcWorkbook = new Workbook();
srcWorkbook.open("D:\\ExcelPageBreakUp\\RegionalRundownMonthEnd-Apr2009-BO.xls");
Worksheets currentWorksheet = srcWorkbook.getWorksheets();
Worksheet worksheet = currentWorksheet.getSheet(0);
worksheet.autoFitColumns();
Same above code is not working in Sun Solaris environment for some scenarios. Here some of the Cells in the worksheet we are getting #### due to autoFitColumns() is not setting proper.
Some of the cells in the worksheet are calculated cells and the size of the each cell is not getting adjusted according to its value. Lets say I have a cell value 185.35%, now we are applying autoFitColumns() to this worksheet. Its working fine in windown envirment ,but not working in Sun Solaris environment. This is happening only for some of the cells in the worksheet, what could be the reason?
Can you please help us to rectify this issue? Thanks in advance.
Thanks & Regards,
Karuppiah M