carlosaran667 opened a new issue, #38557: URL: https://github.com/apache/superset/issues/38557
### Bug description I found another minor issue with "Export to Pivoted Excel" for pivot tables, this time related to percentage values that contain decimals. Related to #38555 ### Steps to reproduce 1. Create a Pivot Table chart. 2. Use a metric that returns percentage values. 3. Set the chart Value format to ,.2~%. 4. Click Download -> Export to Pivoted Excel. 5. Open the exported file in Excel. ### Expected behavior Percentage values should be exported consistently as numeric values already scaled for Excel percentage formatting. For example: - 2% should be exported as 0,02 - 43,66% should be exported as 0,4366 ### Actual behavior Percentage values without decimals are converted correctly (20% becomes 0,2). However, percentage values with decimals are exported as the raw number instead of being divided by 100. For example: 43,66% becomes 43,66 instead of 0,4366 If the column type is then changed to Percentage in Excel, those values are multiplied by 100, which leads to inconsistent results within the same exported column. ### Screenshots/recordings Superset UI:  Excel: <img width="87" height="468" alt="Image" src="https://github.com/user-attachments/assets/a8c5ac37-31f6-40b3-a297-c355995efe10"; /> ### Superset version 6.0.0 ### Python version 3.10 ### Node version I don't know ### Browser Firefox ### Additional context The chart Value format is set to: ,.2~% I am using the chart-level value format because setting a percentage D3 format in the dataset metric configuration does not to work in pivot tables. ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
