ClosedXML relative range Exception in sample code

Question

I had a problem with selecting relative range to another range inside worksheet in ClosedXML. So to be sure how it works I tried example code.

var ws = wb.Worksheets.Add("Sample Sheet");

// From worksheet
var rngTable = ws.Range("B2:F6");

// From another range
var rngDates = rngTable.Range("D3:D5");  // works, range inside B2:F6
var rngNumbers = rngTable.Range("E3:E5");// works, range inside B2:F6

var rngHeaders = rngTable.Range("A2:E2"); // this line throws an exception

It seems that the ranges are not relative after all? If the selected range is inside "B2:F6" range it works.

I used the code from here: ClosedXML Wiki

In what format do I address them relatively to the sub-range? — gtu, May 24 '20 at 05:15

score 1 · Accepted Answer · answered May 24 '20 at 21:11

This behaviour was changed and the wiki is now out of date. Thanks for the catch. When specifying ranges in A1:D4 format, they are now indeed relative to the worksheet. Use this overload for sub ranges relative to the parent range:

IXLRange.Range(int firstCellRow, int firstCellColumn, int lastCellRow, int lastCellColumn);

ClosedXML relative range Exception in sample code

1 Answers1