title: Issue during Grouping and Ungrouping using Apache POI and java
body: <p>I am able to write to excel Sheet by Using Apache POI with Java.
  Also, I am able to groupby Row, as mentioned in the requirement.
  But, the issue which I am facing is:
  I create multiple sheets in the workbook, and use &quot;groupRow&quot; to group data in the sheets.
  And, I need to activate the 2nd sheet, by default. All, works fine, apart from the expand(+) button to &quot;Ungroup&quot; the &quot;group&quot;.
  Basically, when I open the excel, the 2nd sheet is selected by default and the similiar data are grouped also. But, when I click the &quot;Ungroup&quot; button(+), It does not work.
  Note: If I navigate to some other sheet and come back to the same sheet, then the &quot;Ungroup&quot; button works fine.
  Its due to the fact that the &quot;Data Tab&quot; is deactivated by default.
  How do I activate the &quot;Data Tab&quot; by default, so that the &quot;Ungroup&quot; button works fine.
  So, Basically, I need the &quot;Ungroup&quot; button to work ,without navigating to some other sheet.
  Appreciate your help and Support.
  If possible please share code snippet.</p>
  <p>Below are the code Snippets:</p>
  <pre><code>sheetx = wb.createSheet();
  sheetx.groupRow(4, 11);
  sheetx.setRowGroupCollapsed(4, true);
  wb.setActiveSheet(1);   
  </code></pre>
  <p><a href="https://i.stack.imgur.com/xbnYp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xbnYp.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/rJtwg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rJtwg.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/YJwan.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YJwan.png" alt="enter image description here" /></a></p>