Free Support Forum - aspose.com

worksheet.autoFitColumns() - Facing #### problem in Sun Solaris environment

Aspose.Cells Product Family
#1

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

#2

Hi,

Hi the same issue worked with the Aspose.Cells.jar Version 2.0.1.8 both the environments. But we are facing this environment issue only with the latest Aspose.Cells.jar 2.1.0.0 which we are using currently.

Please help us to resolve this issue.

Thanks & Regards

Karuppiah M

#3

Hi Karuppiah,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for providing us the detailed information about your issue. We will look into it and get back to you soon.

Thank You & Best Regards,

#4

Hi Karuppiah,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest version. We have fixed your mentioned issue regarding Worksheet.autoFitColumns.

Thank You & Best Regards,

#5

Hi Nausherwan,

We are using the Aspose.Cells.jar version of 2.1.0.6. The following piece of code is working fine in windows environment to set autoFitRows 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.autoFitRows();

Same above code is not working in Sun Solaris environment for some scenarios. Here some of the Cells in the worksheet the text is not getting wrapped.

Some of the cells in the worksheet are having some Text value (say "TOTAL QUANTITY MATRIX"). This text is not getting wrapped after applying the autoFitRows(). The same above piece of code is working fine in windown envirment ,but not working in Sun Solaris environment.

The fix you have given for Worksheet.autoFitColumns() is working fine Both the environment. Now we need the fix for Worksheet.autoFitRows().

Can you please help us to rectify this issue? Thanks in advance.

Thanks & Regards,

Karuppiah M

#6

Hi Karuppiah,

Thank you for your feedback.

We will look into your reported issue regarding autoFitRows() method on Sun Solaris environment and get back to you soon.

Thank You & Best Regards,

#7

Hi,

We have tested your scenario with 2.1.0.6 and Linux OS but cannot find the issue.

Our test code is:

Workbook wb = new Workbook();
Cells cells = wb.getWorksheets().getSheet(0).getCells();
cell = cells.getCell("A1");
cell.setValue(CellsHelper.getReleaseVersion());
cell = cells.getCell("A10");
cell.setValue("TOTAL QUANTITY MATRIX");
style = cell.getStyle();
style.setTextWrapped(true);
cell.setStyle(style);
sheet.autoFitRows();
wb.save("fit_row_res.xls");

The result file is attached "fit_row_res.xls". Would you please send us your template file and sample code to reproduce the issue?

Thank you.

#8

Hi Amjad,

Thanks for your support. We will check our code and get back to you incase of any issues.

Thanks & Regards,

Karuppiah M

#9

The issues you have found earlier (filed as 10119) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.