search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
66 stars 23 forks source link

/xl/styles.xml error when exporting to Excel and opening it with Profitbase version 7.2 #549

Open Mzr4132 opened 5 months ago

Mzr4132 commented 5 months ago

Hi,

I was testing version 7.2, in the offline power BI environment by downloading the PBI visual for 7.2. However when trying to export the profitbase matrix to Excel I get a /xl/styles.xml error where Excel 2016 fails to load the style / formatting and recovers the cells without any formatting being applied. I haven't had this issue with the current 7.1 release.

What causes this issue and will it be solved for a future release?

Edit: This is for the more recent version of December 13, the previous version (not the live one) for 7.2 worked fine.

Edit2: In the beta version of v7.2.0-rc1 Oct 19. 2023 if you export a column that is a percentage value, it will not export it as a percentage but as a rounded number (either 0 or 1).

Kind regards!

AndersAano commented 5 months ago

Thanks for the feedback! We'll make sure to fix this before publishing v7.2.

-Anders Visuals team