You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "carlosaran667 (via GitHub)" <gi...@apache.org> on 2026/03/10 12:44:21 UTC
[I] Export to pivoted Excel exports percentage values with decimals as raw numbers [superset]
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Export to pivoted Excel exports percentage values with decimals as raw numbers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #38557: Export to pivoted Excel exports percentage values with decimals as raw numbers
URL: https://github.com/apache/superset/issues/38557
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Export to pivoted Excel exports percentage values with decimals as raw numbers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #38557:
URL: https://github.com/apache/superset/issues/38557#issuecomment-4898971489
Same root cause as #38555 (formatted-string re-parsing in the client-side pivoted-Excel export chokes on comma decimals). I'd suggested consolidating and it was agreed one PR would fix both. Closing as duplicate in favor of #38555.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Export to pivoted Excel exports percentage values with decimals as raw numbers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #38557:
URL: https://github.com/apache/superset/issues/38557#issuecomment-4069255172
Is this any different from the other issue, or is it just another flavor of formatter not being exported? If it's the same underlying cause, we should close this in favor of the other.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Export to pivoted Excel exports percentage values with decimals as raw numbers [superset]
Posted by "kendallperry050-sudo (via GitHub)" <gi...@apache.org>.
kendallperry050-sudo commented on issue #38557:
URL: https://github.com/apache/superset/issues/38557#issuecomment-4089648503
Thanks for confirming
On Wed, Mar 18, 2026, 10:19 AM carlosaran667 ***@***.***>
wrote:
> *carlosaran667* left a comment (apache/superset#38557)
> <https://github.com/apache/superset/issues/38557#issuecomment-4083354733>
>
> @kendallperry050-sudo <https://github.com/kendallperry050-sudo> yes, on
> multiple tables from different datasets.
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/superset/issues/38557#issuecomment-4083354733>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/B7X556SO67WKOESSSMHMRUD4RK47XAVCNFSM6AAAAACWNAUPZOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHM2DAOBTGM2TINZTGM>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org