We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Insert row with formatting of the Row below

Workbook wb = new Workbook();
Worksheet ws = wb.getWorksheets().get(“temp”);

Now when I do,

the new row takes the formatting of the previous Row, Row 10.

I want to insert row in a way so that the new row has the formatting of the row below, ie Row 12.

Is there any way to do it?


Thanks for your query.

This feature is not available in Aspose.Cells therefore I have logged it as a new feature request. We need to look into it more for an investigation. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42827 - Insert row with insert option similar to Excel


This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for Java v19.1.6:

aspose-cells-19.1.6.zip (6.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSJAVA-42827) have been fixed in Aspose.Cells for Java 19.2. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi