Is there support relative formula update in duplicate row function

[bailantaotao]

Hi,

I wonder to know the feature is supported currently?

In my imagine like below

1. C1 = A1+B1
2. call duplicate row 1
3. C2 = A2+B2

but in library actually

1. C1 = A1+B1
2. call duplicate row 1
3. C2 = A1+B1

I have try to find any documents but no answer in library.

[xuri]

Thanks for your issue. This library doesn't support this feature currently. I'll consider adding support for it later.

[bailantaotao]

thank you sir~

[ljyf5593]

same feature need, thank you !

[ljyf5593]

I write this utils funtion can support this feature

func parseFormula(formula string, sourceRowID, targetRowID int) (newFormula string) {
	reg := regexp.MustCompile(fmt.Sprintf("([A-Z]{1,2}%d)", sourceRowID))
	cellSlice := reg.FindAllString(formula, -1)
	newFormula = formula
	for _, cell := range cellSlice {
		col, _, err := excelize.SplitCellName(cell)
		if err != nil {
			log.Fatalln(err)
		}
		targetCell, err := excelize.JoinCellName(col, targetRowID)
		if err != nil {
			log.Fatalln(err)
		}
		newFormula = strings.ReplaceAll(newFormula, cell, targetCell)
	}
	return
}

call like this parseFormula("A1 + B1", 1, 2)

[xuri]

Hi @bailantaotao, @ljyf5593, this library now support this feature, please upgrade to the master branch code, and this feature will be released in the next version.