Saving excel file makes it corrupt #426
Description
Description
If you try to open and save an excel file, which has formatterd\colored\cell borders, it corrupts the file
xlsx, err := excelize.OpenFile("./Book1.xlsx")
if err != nil {
fmt.Println(err)
return
}
err = xlsx.Save()
if err != nil {
fmt.Println("unable to save Internal timesheet, error: ", err)
os.Exit(1)
}
Steps to reproduce the issue:
1.
2.
3.
Describe the results you received:
Describe the results you expected:
Output of go version:
go version go1.12.5 darwin/amd64
Excelize version or commit ID:
github.com/360EntSecGroup-Skylar/excelize/v2 v2.0.1-0.20190601073747-d038ca2e9c75
Environment details (OS, Microsoft Excel™ version, physical, etc.):
Mac OS
Excel for mac 16.13
Metadata
Metadata
Assignees
Type
Projects
Milestone
Relationships
Development
No branches or pull requests
Participants
Activity
xuri commentedon Jun 15, 2019
Hi @RajatBanerjee, thanks for your feedback, could you upload the .xlsx attachment?
RajatBanerjee commentedon Jun 15, 2019
I can't upload the actual attachment since it has some confidential data, but it happens for any excel file, so let me recreate the scenario with a regular file and upload that.
dennisfleischmann commentedon Nov 26, 2019
@RajatBanerjee Hi RajatBanerjee, is the problem still there? We have issues while doing a small change in our excel (xlms) sheet using intensly activex controls and macros. The exel activeX control informations are lost afterwards.
xuri commentedon Nov 26, 2019
Hi @dennisfleischmann, please provide code and file attachment to reproduce this issue if you can.
muhrifqii commentedon Dec 15, 2019
I had the exact same problem too. Opened excel with formatterd\colored\cell borders, and also formulas that referenced across sheets
xuri commentedon Dec 15, 2019
@muhrifqii could you provide code and file attachment to reproduce this issue?
muhrifqii commentedon Dec 15, 2019
@xuri the code just open the file then save it, exactly like @RajatBanerjee code . It contains some credential data, could you please send your contact to me and I'll send it to you privately.
xuri commentedon Dec 15, 2019
You can send me the file with credential data masking.
xuri.me[at]gmail.comxuri commentedon Dec 16, 2019
Hi @muhrifqii, thanks for your feedback. I have fixed it. Please try to upgrade the library with the master branch code. I'm not sure if this fix will work for the issue you mentioned by @RajatBanerjee.
muhrifqii commentedon Dec 19, 2019
Thanks @xuri I tested on master branch and it fixed the issue
Fix qax-os#426, handle empty workbook view
Fix qax-os#426, handle empty workbook view