If you are having issues with the Excel calculations when executing the report, you can use the information below to determine how the cells are expanding. 

 

 

The OSRRef formula has some extra parameters, such as OSRRef(“Cell”,2). The second parameter can have four values; 0,1,2,3 which gives us cell reference for expanding columns OR rows.

 

Here are the definitions for the second parameters:

 

0 = auto (which is the same as the regular =OSRref(Cell) formula)

1= Expanding on rows OSRRef(“Cell”,1)

2= Expanding on columns OSRRef(“Cell”,2)

3= Expanding on both rows and columns OSRRef(“Cell”,3)

 

These formulas are quite useful in large reports where the OSRRef formula is not able to find out how the cells are expanding.