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

ThousandSeperator doesn't work after SaveAs a new excel #628

Closed
EP-Toushirou opened this issue May 5, 2020 · 4 comments
Closed

ThousandSeperator doesn't work after SaveAs a new excel #628

EP-Toushirou opened this issue May 5, 2020 · 4 comments

Comments

@EP-Toushirou
Copy link

Description

original excel:
1.origin state:
image

2.click general
image

3.and then click thousand seperator
image

4.The number turn back to thousandSeperator.It's right.
image

after saveAs a new excel:
1.origin state:
image

2.click general
image

3.and then click thousand seperator
image

4.It's not work,that's the problem. Thank you.
Still at 1800.
image

Steps to reproduce the issue:

func ThousandSeperator() {
	f, _ := excelize.OpenFile("ThousandSeperator.xlsx")
	f.SaveAs("ThousandSeperator_new.xlsx")
}

ThousandSeperator.xlsx

Describe the results you received:
Not same as the original excel

Describe the results you expected:
Same as the original excel

Output of go version:

go1.13.7 windows/amd64

Excelize version or commit ID:

2020.05.05 master

Environment details (OS, Microsoft Excel™ version, physical, etc.):
win10,office2019

@xuri xuri closed this as completed in 1f73a19 May 5, 2020
@EP-Toushirou
Copy link
Author

Thank you!

@xuri
Copy link
Member

xuri commented May 6, 2020

Thanks for your donation. I have added you're into the donator page.

@EP-Toushirou
Copy link
Author

😁😁

@EP-Toushirou
Copy link
Author

@xuri Hi,here has a follow-up questions:
click thousand seperator cause the style disappear after SaveAs function.

click:
image

then:
image

xuri added a commit that referenced this issue May 10, 2020
- styles: allow empty and default cell formats, #628
nullfy pushed a commit to nullfy/excelize that referenced this issue Oct 23, 2020
nullfy pushed a commit to nullfy/excelize that referenced this issue Oct 23, 2020
- styles: allow empty and default cell formats, qax-os#628
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants