Skip to content

Formula referencess not updated after InsertCols #1615

@CSHornby

Description

@CSHornby

Description
Formula references are not updated after using InsertCols.

Steps to reproduce the issue:

  1. Create a formula in cell F5 that references C5 + D5 + I5
  2. InsertCols at column C or D or G

Describe the results you received:
Formula references are not updated, so formula still reads C5 + D5 + I5

Describe the results you expected:
Formula references should be updated to:
D5 + E5 + J5 for insert at C
C5 + E5 + J5 for insert at D
C5 + D5 + J5 for insert at G

Output of go version:

go version go1.20.5 linux/amd64

Excelize version or commit ID:

v2.7.2-0.20230703160637-e2c74162925c

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Ubuntu Linux on laptop

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions