This project has moved. For the latest updates, please go here.

Copying ranges with formulas using absolute references

Aug 5, 2014 at 12:06 AM

I have a template file that is populated from my database. So I insert a new row for each record of my DB and in this new rows I need to copy the formulas of the previous rows, some of these formulas have absolute references for example


and I would expect that on the next row the copied formula should be


but instead I'm getting


My code looks somethin like this
int prevRowNo = currentRowNo - 1;
var prevRow = oSheet.Row(prevRowNo);
//var currentRange = oSheet.Range("A" + setIdx.ToString(), "AZ" + setIdx.ToString());     
var PrevRange = oSheet.Range("$A$" + prevRowNo.ToString() + ":$AZ$" + prevRowNo.ToString());
oSheet.Cell(CurrentRowNo, "A").Value = PrevRange;
I don't know if I'm doing something wrong,

Aug 6, 2014 at 6:28 PM
I need an easy way to reproduce the problem. The following works:
var wb = new XLWorkbook();
var ws = wb.AddWorksheet("Sheet");

    .CellBelow().SetFormulaA1("A1 + $A$1")
A1 = 1
A2 = "A1 + $A$1"
A3 = "A2 + $A$1"