Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: download as excel feature in table not working when column type is set as number. #38995

Closed
1 task done
rahulbarwal opened this issue Feb 4, 2025 · 5 comments · Fixed by #39427
Closed
1 task done
Assignees
Labels
Bug Something isn't working Medium Issues that frustrate users due to poor UX Needs Triaging Needs attention from maintainers to triage Production QA Needs QA attention Query & Widgets Pod All issues related to Query, JS, Eval, and Widgets Table Widget V2 Issues related to Table Widget V2 Widgets & Accelerators Pod Issues related to widgets & Accelerators Widgets Product This label groups issues related to widgets

Comments

@rahulbarwal
Copy link
Contributor

Is there an existing issue for this?

  • I have searched the existing issues

Description

One of our customers reported this issue where if any of the column types is set as number the downloaded file when imported in excel comes out as corrupted.

Screen.Recording.2025-02-04.at.11.39.52.AM.mov

Slack conversation

Steps To Reproduce

  1. Go to any app or create new app.
  2. Drag and drop a table widget and bind it to some data.
  3. Allow download through property pane.
  4. Make one of columns as number type.
  5. Click on download and download as excel.
  6. Notice open the downloaded file in ms excel. Notice that it throws up an error and reports the file as corrupted.

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Cloud

@rahulbarwal rahulbarwal added Bug Something isn't working Needs Triaging Needs attention from maintainers to triage Table Widget V2 Issues related to Table Widget V2 labels Feb 4, 2025
@Nikhil-Nandagopal Nikhil-Nandagopal added Medium Issues that frustrate users due to poor UX Production labels Feb 4, 2025
@github-actions github-actions bot added Widgets Product This label groups issues related to widgets Widgets & Accelerators Pod Issues related to widgets & Accelerators labels Feb 4, 2025
@rahulbarwal
Copy link
Contributor Author

The package zipcelx that is used to convert table data to excel file is no longer maintained. The last update on the library happened over 6 years ago.
We need to consider alternatives to make this better. One of the options is write excel file. But the unpacked size is quite huge(1.28MB 🤯). We need to consider lighter alternatives.

@rahulbarwal
Copy link
Contributor Author

As a quick fix, we are removing the Download as Excel feature in the meantime.

@rahulbarwal rahulbarwal added the Query & Widgets Pod All issues related to Query, JS, Eval, and Widgets label Feb 4, 2025
@MMHalim
Copy link

MMHalim commented Feb 11, 2025

My app includes a feature to download data from a table. Initially, exporting the data in a delimited format (e.g., CSV) seemed like an option, but due to the presence of numerous delimiters within text fields, the data often becomes misaligned. This causes columns to mix up, with data from one column appearing in another. To resolve this, I found that exporting the data as an Excel file works perfectly, as it avoids these delimiter-related issues entirely, hopefully exporting as excel to be back soon enough.

@chataid-sam
Copy link

We are also experiencing the same problem referenced above where exporting as CSV is not a viable option. We would love to see this functionality restored soon!

@rahulbarwal
Copy link
Contributor Author

rahulbarwal commented Feb 25, 2025

@MMHalim , @chataid-sam
thanks for your inputs. We have fixed the bug with this feature and it is going to be available soon(tomorrow).
Do check it out and let us know if you have any concerns.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Medium Issues that frustrate users due to poor UX Needs Triaging Needs attention from maintainers to triage Production QA Needs QA attention Query & Widgets Pod All issues related to Query, JS, Eval, and Widgets Table Widget V2 Issues related to Table Widget V2 Widgets & Accelerators Pod Issues related to widgets & Accelerators Widgets Product This label groups issues related to widgets
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants