ExcelFile.SemiAbsoluteReferences Property
When this property is false, inserting and copying ranges will behave the same as it does in Excel. When this property is true, absolute references to cells inside the block being copied will be treated as relative. For example, if you have:
A1: 2
B1: =$A$1 + $A$57
and you copy the row 1 to row 2, in Excel or FlexCel when this property is false you will get:
A2: 2
B2: =$A$1 + $A$57
When this property is true, you will get:
A2: 2
B2: =$A$2 + $A$57
In the second case, the first reference was updated because it was inside the range being copied, but the second was not. This property might be useful when you want to duplicate blocks of cells, but want the absolute references inside it to point to the newer block.
Syntax
Namespace: FlexCel.Core
public Boolean SemiAbsoluteReferences { get; set; }