You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "jose-vines-toteat (via GitHub)" <gi...@apache.org> on 2024/05/16 13:23:30 UTC

[I] Tables with long numbers are truncated when exported to excel [superset]

jose-vines-toteat opened a new issue, #28551:
URL: https://github.com/apache/superset/issues/28551

   ### Bug description
   
   When downloading a table with long numbers with the excel options, these are truncated by replacing the last number with a 0. For example, 1100108628127863 would appear as 1100108628127860. This does not happen when exporting to CSV.
   
   ### How to reproduce the bug
   
   Create a table where a dimension is some large number (15-16 digits) and then download as excel.
   
   ### Screenshots/recordings
   
   This is an extract of the table in my dashboard
   <img width="306" alt="image" src="https://github.com/apache/superset/assets/124913243/ce9a86ce-c878-4ff0-85fd-dcd1f6b64395">
   
   This is what it looks like in excel
   <img width="293" alt="image" src="https://github.com/apache/superset/assets/124913243/ca5fb92b-0af1-44b6-9a55-fcb4a46bf68d">
   
   
   ### Superset version
   
   3.1.3
   
   ### Python version
   
   3.9
   
   ### Node version
   
   16
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   _No response_
   
   ### 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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28551:
URL: https://github.com/apache/superset/issues/28551#issuecomment-2115673958

   @jose-vines-toteat let us know if you want to open a PR to solve the problem. We'd love to get feedback on Dosu's suggestions here, since if it leads to a fix, that's pretty amazing.


-- 
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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "mistercrunch (via GitHub)" <gi...@apache.org>.
mistercrunch closed issue #28551: Tables with long numbers are truncated when exported to excel
URL: https://github.com/apache/superset/issues/28551


-- 
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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "jvines (via GitHub)" <gi...@apache.org>.
jvines commented on issue #28551:
URL: https://github.com/apache/superset/issues/28551#issuecomment-2486565384

   @rusackas  Hi! Yes I intend to, but I've had problems with my pc lately. I'll try to get it done asap.


-- 
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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "jvines (via GitHub)" <gi...@apache.org>.
jvines commented on issue #28551:
URL: https://github.com/apache/superset/issues/28551#issuecomment-2309263047

   Hi, sorry it took me so long to get to this. I'll open a PR to solve this following Dosu's suggestion.


-- 
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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #28551:
URL: https://github.com/apache/superset/issues/28551#issuecomment-2484288197

   @jvines did you want to open a PR on Superset to close out this issue? Curious if the fix worked and seems like it'd help others, too, without causing some other edge case.


-- 
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] Tables with long numbers are truncated when exported to excel [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #28551:
URL: https://github.com/apache/superset/issues/28551#issuecomment-2115238235

   <!-- Greeting -->
   Hola @jose-vines-toteat, soy [Dosu](https://dosu.dev), un bot aquí para ayudarte a resolver dudas, solucionar problemas y convertirte en un colaborador mientras esperas por un mantenedor humano. Estoy aquí para asistirte en lo que necesites. Ahora, voy a revisar tu problema para ofrecerte una respuesta completa en breve.
   
   
   


-- 
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