Can't modify cell content of xlsx file exported from server

[Lin07ux]

Description

I have an excel file exported from server, i can use excelize@v2 to modify its style and modify the content of empty cells, but I can't modify the content of cells that already have content.

Steps to reproduce the issue:

1. export excel file from server (you can open the file, but don't modify it use any software like WPS or MS Office). orders-20220628222630-20220629173554.xlsx
2. use excelize to process the file, the above situation will occur .
3. use WPS open and modify any cell in the file and save it.
4. then use excelize to process the file, and everything is ok.

Describe the results you received:

I can't change the content of A1 cell.

Describe the results you expected:

change the content of A1 cell.

Output of go version:

go version go1.17.2 darwin/amd64

Excelize version or commit ID:

github.com/xuri/excelize/v2 v2.6.0

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

Mac OS, WPS 4.2.2

Example Code

package main

import (
	"github.com/xuri/excelize/v2"
	"log"
)

func main() {
	excel, err := excelize.OpenFile("~/Downloads/orders-20220628222630-20220629173554.xlsx")
	if err != nil {
		log.Fatalln(err)
	}
	defer func() {
		if err := excel.Save(); err != nil {
			log.Fatalln(err)
		}
		if err := excel.Close(); err != nil {
			log.Fatalln(err)
		}
	}()

	sheet := excel.GetSheetName(excel.GetActiveSheetIndex())

	// **not work**
	if err = excel.SetCellStr(sheet, "A1", "A1"); err != nil {
		log.Fatalln(err)
	}

	// ok
	if err = excel.SetCellStr(sheet, "B2", "B2"); err != nil {
		log.Fatalln(err)
	}

	style, err := excel.NewStyle(&excelize.Style{
		Border: []excelize.Border{
			{Type: "left", Color: "0000FF", Style: 3},
			{Type: "top", Color: "00FF00", Style: 4},
			{Type: "bottom", Color: "FFFF00", Style: 5},
			{Type: "right", Color: "FF0000", Style: 6},
			{Type: "diagonalDown", Color: "A020F0", Style: 7},
			{Type: "diagonalUp", Color: "A020F0", Style: 8},
		},
	})
	if err != nil {
		log.Fatalln(err)
	}

	// ok
	if err = excel.SetCellStyle(sheet, "D1", "D1", style); err != nil {
		log.Fatalln(err)
	}
}

[xuri]

Thanks for your feedback. This issue has been fixed, please upgrade to the master branch code, and this patch will be released in the next version.

[Lin07ux]

Thank you very much for your response and handling.