npoi icon indicating copy to clipboard operation
npoi copied to clipboard

Published 20 hours ago • verified publisher icon nissl-lab

In the ShiftRows transformation, certain functions disappear in the cells

Open Julyxunle opened this issue 5 months ago • 0 comments

NPOI Version

File Type

  • XLSX

Upload the Excel File

Please attach your original Excel File to help us reproduce the issue

Reproduce Steps

Issue Description

For example, the function “=INDEX($K:$K, ROW()-7)” disappears after the transformation, but the function “=INDEX(OFFSET($A$1,ROW()-8,COLUMN()+5),1,1)” remains intact.

Julyxunle avatar Jan 11 '24 12:01 Julyxunle