Excel grouping is disappearing in excel add in after the upgrade

alsathappan
New Contributor

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

 

1 ACCEPTED SOLUTION

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

 

View solution in original post

2 REPLIES 2

JackLacava
Community Manager
Community Manager

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

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

 

Please sign in! alsathappan