Skip to main content
A
alsathappan
Newcomer
April 27, 2023
Solved

Excel grouping is disappearing in excel add in after the upgrade

  • April 27, 2023
  • 1 reply
  • 0 views

We upgraded to 7.3.3 and noticed that grouping that are created in excel is disappearing when we refresh the quickview report in the excel add in.  If I refresh the report in spreadsheet application, the grouping disappears but at least it is hiding the columns/rows that were grouped.  

Has anyone noticed this?  Is there a fix or work around for this?

Thanks

 

Best answer by alsathappan

Yes, reached out to support and it seems to be a defect.

Here are couple of workarounds just in case if anyone else have the issue

1) Highlight the data section of the quick view and "convert to XFGetCells" for the data section in the excel add in, then refresh the file, the row and column will keep group format.

2) After creating the quick view in excel add in, create a new sheet and link to original QA.  Apply the necessary formatting and grouping the new sheet.

Thanks

 

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
May 2, 2023

Not sure, this is the sort of thing that should probably be discussed with Support. Did you open a case?

    A
    alsathappanAuthorAnswer
    Newcomer
    May 2, 2023

    Yes, reached out to support and it seems to be a defect.

    Here are couple of workarounds just in case if anyone else have the issue

    1) Highlight the data section of the quick view and "convert to XFGetCells" for the data section in the excel add in, then refresh the file, the row and column will keep group format.

    2) After creating the quick view in excel add in, create a new sheet and link to original QA.  Apply the necessary formatting and grouping the new sheet.

    Thanks

     

      Terms & ConditionsAccessibility statement