DuplicateRow or InsertRows in table,and quick analysis tool will lost

[DehaiWang]

Description

i insert some rows in the table zone , and quick analysis tool will lost

Steps to reproduce the issue:

package main

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

func main() {

	log.SetFlags(log.Lshortfile | log.LstdFlags)

	openFile, err := excelize.OpenFile("aa.xlsx")
	defer openFile.Close()

	if err != nil {
		log.Panicln(err)
		return
	}

	sheetList := openFile.GetSheetList()
	sheetName := sheetList[0]

	rowIndex := 4

	tableList, err := openFile.GetTables(sheetName)
	if err != nil {
		log.Panicln(err)
		return
	}

	tableItem := tableList[0]
	log.Printf("%+v\n", tableItem)

	err = openFile.DuplicateRow(sheetName, rowIndex)
	if err != nil {
		log.Panicln(err)
		return
	}
	
	//nowTime := time.Now().Format(time.DateTime)
	//openFile.SetCellValue(sheetName, "A5", nowTime)
	openFile.Save()

}

Describe the results you received:

and then ,quick analysis tool losted

Describe the results you expected:

[xuri]

Thanks for your issue. Which version of the Excelize are you using? Could you provide the workbook attachment without confidential info?

[DehaiWang]

@xuri

thanks.

github.com/xuri/excelize/v2 v2.8.1

example workbook
aa.xlsx

[DehaiWang]

@xuri excuse me, do have a plan to fix this ? or have other function to do this ?

[xuri]

Yeah, I need some time to fix this, this is caused by incorrect formula adjust for shared formula. Contributions are welcome. I'll certainly accept that patch if somebody did that.

[pgalbavy-itrs]

In a related way, is there any chance any changes that address this could also "move" conditional formatting on InsertRows() ?

Edit: This may be (my) user error. I was using absolute coordinates when setting the conditional formats. I have not made them relative, but I have not yet tested the result as I had already changed the code path to set the formats last...