AddPicture does not work properly when Copying Sheets with Images

[t4traw]

Description

I found a strange behavior with the AddPicture function after copying a sheet in Excelize. When I attempt to insert an image into the copied sheet using AddPicture, the function doesn't behave as expected if there is already an image inserted in a different sheet.

package main

import (
	_ "image/png"

	"github.com/xuri/excelize/v2"
)

func main() {
	xlsx, _ := excelize.OpenFile("./Book1.xlsx")

	templateSheetName := "Sheet2"
	templateSheetIndex, _ := xlsx.GetSheetIndex(templateSheetName)

	Copied1, _ := xlsx.NewSheet("Copied1")
	_ = xlsx.CopySheet(templateSheetIndex, Copied1)
	Copied2, _ := xlsx.NewSheet("Copied2")
	_ = xlsx.CopySheet(templateSheetIndex, Copied2)

	photoPotisions, _ := xlsx.SearchSheet(templateSheetName, "photo")

	xlsx.AddPicture("Copied1", photoPotisions[0], "./a.png", &excelize.GraphicOptions{})
	xlsx.AddPicture("Copied2", photoPotisions[0], "./b.png", &excelize.GraphicOptions{})

	xlsx.SaveAs("./output.xlsx")
}

I executed this code without making any changes. Here are the generated .xlsx files:

1. This is the .xlsx file created when there is no image inserted in Sheet1.
   
2. This is the .xlsx file created when an image is inserted in Sheet1.
   

I have pushed the sample code to the repository.

https://github.com/t4traw/addpicture_duplicate

Output of go version:

go version go1.19 darwin/arm64

Excelize version or commit ID:

v2.7.2-0.20230522012428-c2327484006e

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

• OS: macOS 13.3.1
• Excel: 16.72

[xuri]

Thanks for your issue. I have fixed this issue, please try to upgrade the master branch code, and this patch will be released in the next version.

[t4traw]

It worked perfectly with my own code too! Superb! Thank you for this cool library!