Collapse all groups generated by Subtotal

Hi,

I using Aspose.Cells for Java. I created Subtotals in a worksheet but groups are expanded.
I wish collapse all the groups generated by Subtotal.

I see that in the AsposeCell for Net exists the function “
HideGroupDetail”, but no in AsposeCells for Java.

Thank you

Hi,

I think, you can try looking for your functionality in these methods.

Please see this API reference document: Cells


void groupColumns(int startIndex, int endIndex)
Groups columns.

void groupColumns(int startIndex, int endIndex, boolean isHidden)
Groups columns.

void groupRows(int startIndex, int endIndex)
Groups rows.

void groupRows(int startIndex, int endIndex, boolean isHidden)
Groups rows.