Aspose.Cellls for Java Feature request for Cell.applyStyle and Cells.applyRangeStyle

For the same reason the product has Row.applyStyle and Column.applyStyle it should have Cell.applyStyle and Cells.applyRangeStyle. With Cell.setStyle and Cells.setRangeStyle, you can't create multiple, reusable Style objects that could be applied to the same cells because whatever style is used last with setStyle overwrites any others.

This would allow Aspose.Cells to close the gap a little bit with OfficeWriter's ExcelWriter formatting capabilities.

The implementation would be extremely simple for both applyStyle and applyRangeStyle. See attached java sample.


Thanks for your suggestions.

We will check the feasibility for Cell.applyStyle() and Cells.applyRangeStyle() methods if we can add them to the APIs. We will get back to you soon.

Thank you.


Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells. We have added new methods for your requirement:

  • void com.aspose.cells.Cells.applyStyle(Style style, StyleFlag flag, int startRow, int endRow, int startColumn, int endColumn)
  • void com.aspose.cells.Cell.applyStyle(Style style, StyleFlag flag)

Thank You & Best Regards,

Thanks. This looks good. Are these new methods candidates for the next official Cells release or just for me?


Yes sure, our next official release would include all the functionality of the previous fixes (including all the intermediate versions till the next official release).

Thanks for your understanding.

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

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