Hello,
I am currently experiencing an issue with exporting the Data View to Excel and would appreciate your assistance.
When I select the "Standard Microsoft Excel Workflow" export option, the generated file maintains the exact format of the Data View, which is ideal for my needs. However, I lose the formulas required to calculate column totals and row totals.
Alternatively, when I use the "Microsoft Excel Workbook for Board Add-in" export option and enable "Use formulas," I encounter a different problem. The exported file does not align with the original Data View formatting. This misalignment occurs primarily because my Data View contains multiple entities in the rows, which act as grouping elements. In the Data View, each entity was highlighted in gray, and the "View totals on expand groups" option was active, showing the totals for each group in the gray lines.
Is there any workaround or alternative export method available that would allow me to retain both the Data View's original formatting and the necessary formulas for totals in an xlsx format ?
Thank you in advance for your help.
Felipe