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

[question] Why are the columns shifting and no longer aligned after exporting as Excel? #13294

Closed
aiampogi opened this issue May 29, 2024 · 9 comments
Labels
component: data grid This is the name of the generic UI component, not the React module! support: commercial Support request from paid users support: unknown Support request type not verified yet. Head to https://tools-public.mui.com/prod/pages/jyhs86t

Comments

@aiampogi
Copy link

aiampogi commented May 29, 2024

The problem in depth

Using MUI-X Premium Datagrid v7.5.1, after exporting as Excel, the columns become unaligned and shifts whenever you scroll horizontally.

It can be reproduced using the example in the docs

Here's my recording.
excelexportingshiftscolumns

Your environment

`npx @mui/envinfo`
  Browser: Microsoft Edge Version 125.0.2535.67 (Official build) (64-bit)
  Output from `npx @mui/envinfo` goes here:
  
    System:
    OS: Windows 11 10.0.22631
  Binaries:
    Node: 20.9.0 - C:\Program Files\nodejs\node.EXE
    npm: 10.1.0 - C:\Program Files\nodejs\npm.CMD
    pnpm: 8.15.5 - ~\AppData\Local\pnpm\pnpm.EXE
  Browsers:
    Chrome: Not Found
    Edge: Chromium (123.0.2420.97)
  npmPackages:
    @emotion/react: ^11.11.1 => 11.11.1
    @emotion/styled: ^11.11.0 => 11.11.0
    @mui/base: ^5.0.0-beta.32 => 5.0.0-beta.40
    @mui/core-downloads-tracker:  5.15.16
    @mui/icons-material: ^5.11.11 => 5.13.7
    @mui/lab: ^5.0.0-alpha.128 => 5.0.0-alpha.135
    @mui/material: ^5.15.16 => 5.15.16
    @mui/private-theming:  5.15.14
    @mui/styled-engine:  5.15.14
    @mui/system:  5.15.15
    @mui/types:  7.2.14
    @mui/utils:  5.15.14
    @mui/x-data-grid:  7.5.1
    @mui/x-data-grid-premium: ^7.5.1 => 7.5.1
    @mui/x-data-grid-pro:  7.5.1
    @mui/x-license:  7.2.1
    @types/react:  18.2.14
    react: ^18.2.0 => 18.2.0
    react-dom: ^18.2.0 => 18.2.0
    typescript: ^4.9.4 => 4.9.5

Search keywords: export as excel shifting columns

@aiampogi aiampogi added status: waiting for maintainer These issues haven't been looked at yet by a maintainer support: commercial Support request from paid users support: unknown Support request type not verified yet. Head to https://tools-public.mui.com/prod/pages/jyhs86t labels May 29, 2024
Copy link

You have created a support request under the "Priority Support" terms, which is a paid add-on to MUI X Premium ⏰. Please validate your support key using the link below:

https://tools-public.mui.com/prod/pages/jyhs86t?repo=mui-x&issueId=13294

Do not share your support key in this issue!

Priority Support is only provided to verified customers. Once you have verified your support key, we will remove the support: unknown label and add the support: priority label to this issue. Only then the time for the SLA will start counting.

@romgrk
Copy link
Contributor

romgrk commented May 29, 2024

Duplicate of #12641? The fix will be released this week.

@romgrk romgrk added component: data grid This is the name of the generic UI component, not the React module! status: waiting for author Issue with insufficient information and removed status: waiting for maintainer These issues haven't been looked at yet by a maintainer labels May 29, 2024
@aiampogi
Copy link
Author

cool thanks. I'll close this.

Copy link

⚠️ This issue has been closed. If you have a similar problem but not exactly the same, please open a new issue.
Now, if you have additional information related to this issue or things that could help future readers, feel free to leave a comment.

@aiampogi: How did we do? Your experience with our support team matters to us. If you have a moment, please share your thoughts in this short Support Satisfaction survey.

@github-actions github-actions bot added status: waiting for maintainer These issues haven't been looked at yet by a maintainer and removed status: waiting for author Issue with insufficient information labels May 29, 2024
@aiampogi aiampogi reopened this May 29, 2024
@aiampogi
Copy link
Author

what version will it be fixed?

@romgrk
Copy link
Contributor

romgrk commented May 29, 2024

The upcoming one in the v7 branch. Either 7.6.0 or 7.5.2 depending on what changes are included.

@romgrk romgrk added the status: waiting for author Issue with insufficient information label May 29, 2024
@aiampogi
Copy link
Author

thanks.

@github-actions github-actions bot removed the status: waiting for author Issue with insufficient information label May 29, 2024
@aiampogi
Copy link
Author

as per @romgrk it'll be fixed either in 7.6.0 or 7.5.2

@github-actions github-actions bot removed the status: waiting for maintainer These issues haven't been looked at yet by a maintainer label May 29, 2024
Copy link

⚠️ This issue has been closed. If you have a similar problem but not exactly the same, please open a new issue.
Now, if you have additional information related to this issue or things that could help future readers, feel free to leave a comment.

@aiampogi: How did we do? Your experience with our support team matters to us. If you have a moment, please share your thoughts in this short Support Satisfaction survey.

@aiampogi aiampogi changed the title [question] Why is the columns shifting and no longer aligned after exporting as Excel? [question] Why are the columns shifting and no longer aligned after exporting as Excel? May 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component: data grid This is the name of the generic UI component, not the React module! support: commercial Support request from paid users support: unknown Support request type not verified yet. Head to https://tools-public.mui.com/prod/pages/jyhs86t
Projects
None yet
Development

No branches or pull requests

2 participants