**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.