qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
18.32k stars 1.71k forks source link

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

Closed EP-Toushirou closed 4 years ago

EP-Toushirou commented 4 years ago

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

EP-Toushirou commented 4 years ago

Thank you!

xuri commented 4 years ago

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

EP-Toushirou commented 4 years ago

😁😁

EP-Toushirou commented 4 years ago

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

click: image

then: image