Protected cell

[nikencmoscow]

Hi!

Why does the cell become protected when using SetCellStyle?

style, err := xlsx.NewStyle({"font":{"color":"#FF0000", "size":12}, "border":[{"type":"right","color":"#09600b","style":1}], "alignment":{"horizontal":"right"}})
if err != nil {
fmt.Println(err)
}
xlsx.SetCellStyle(sheetFull, cell, cell, style)

Advance thanks!

[xuri]

What's the "be protected" means? I have tested and it works well. Please provide the file attachment if you can.

[nikencmoscow]

Please, look file before and after.
Sheet 3, Cell F8.
func SetDate(xlsx *excelize.File, sheet int, cell string, data time.Time, isError *bool) {

sheetString := strconv.Itoa(sheet)
sheetFull := "sheet" + sheetString

defaultTime, _ := time.Parse("2006-01-02", "0001-01-01 05:48:48 +0548 LMT")
if data.Format("2006-01-02") == defaultTime.Format("2006-01-02") {
	xlsx.SetCellValue(sheetFull, cell, "ДД.ММ.ГГГГ")
	style, err := xlsx.NewStyle(`{"font":{"color":"#FF0000", "size":12}, "border":[{"type":"right","color":"#09600b","style":1}], "alignment":{"horizontal":"right"}}`)
	if err != nil {
		fmt.Println(err)
	}
	xlsx.SetCellStyle(sheetFull, cell, cell, style)
	*isError = true
} else {
	xlsx.SetCellValue(sheetFull, cell, data.Format("02.01.2006"))
}

}

before.xlsx
after.xlsx

[xuri]

I have added set protection properties support for the function NewStyle(). You can add "protection":{"locked":false} in the style format set param.

[nikencmoscow]

Thank You!)