add function to remove or update comment in a cell

[coreyzzp]

No description provided.

[coreyzzp]

when we try to add comment to a cell with comment, when open the excel file, the excel program will complain about 'there is an error occur, but we has recovery from it'

[xuri]

Hi @coreyzzp, thanks for your feedback, could you provide any code and attachments to reproduce this issue?

[coreyzzp]

func TestCreateExcelAndUpdateComment(t *testing.T) {
	target := "test.xlsx"
	target2 := "test-after.xlsx"
	{
		var err error
		fd := excelize.NewFile()
		err = fd.AddComment("Sheet1", "A1", fmt.Sprintf(`{"author":"Excelize: ","text":"This is a comment" }`))
		require.Nil(t, err)
		err = fd.SaveAs(target)
		require.Nil(t, err)
		// here open test.xlsx is find
	}
	{
		fd, err := excelize.OpenFile(target)
		require.Nil(t, err)
		err = fd.AddComment("Sheet1", "A1", fmt.Sprintf(`{"author":"Excelize: ","text":"hello world"}`))
		require.Nil(t, err)
		err = fd.SaveAs(target2)
		require.Nil(t, err)
		// now open test-after.xlsx an error popup
	}
}

open test.xlsx

open test-after.xlsx

[coreyzzp]

it will be good to has a method to delete or update comment in a cell

[xuri]

This lib doesn't support modify comment and set the comment repeatedly on one cell currently. I've add this feature support in the Roadmap.

[coreyzzp]

thx~

[Jonham]

find an article about "comments" and "notes": The difference between threaded comments and notes

[FoeverA0]

[WeOpen Star] I would like to help

[NaturalGao]

[WeOpen Star] I would like to help