04-27-2023 07:04 PM
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
Solved! Go to Solution.
05-02-2023 12:10 PM
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
05-02-2023 08:15 AM
Not sure, this is the sort of thing that should probably be discussed with Support. Did you open a case?
05-02-2023 12:10 PM
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