Skip to content

Excel styles should default to using number format from display.precision option #16161

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.

Sign up for GitHub

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

Jump to bottom
Closed
jnothman opened this issue Apr 27, 2017 · 2 comments
Closed

Excel styles should default to using number format from display.precision option #16161

jnothman opened this issue Apr 27, 2017 · 2 comments
Labels
Enhancement IO Excel read_excel, to_excel Output-Formatting __repr__ of pandas objects, to_string

Comments

@jnothman
Copy link
Contributor

Excel output should be as close to the DataFrame html display as possible. Excel controls the display of each cell with a number format style attribute. Pandas controls it with the display.precision option. Excel export should adhere to the pandas option.
@jreback jreback added IO Excel read_excel, to_excel Numeric Operations Arithmetic, Comparison, and Logical operations Output-Formatting __repr__ of pandas objects, to_string labels Apr 27, 2017
@jreback jreback added this to the Next Major Release milestone Apr 27, 2017
@jbrockmendel jbrockmendel removed the Numeric Operations Arithmetic, Comparison, and Logical operations label Sep 23, 2020
@mroeschke mroeschke removed this from the Contributions Welcome milestone Oct 13, 2022
@rmhowe425
Copy link
Contributor

rmhowe425 commented Jul 7, 2024 •
edited
Loading

@mroeschke I think this PR satisfies the acceptance criteria for this issue.

If we all agree then we can probably close this issue.

@mroeschke
Copy link
Member

Thanks. Yes I think this can be closed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Enhancement IO Excel read_excel, to_excel Output-Formatting __repr__ of pandas objects, to_string
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@jnothman @jreback @jbrockmendel @mroeschke @rmhowe425