Named cells/ranges are recognised in Calc from OOo2.4 - see Issue 4695.

In Excel, type is a logical value Calc also accepts logical values but they are displayed as numbers.

The type parameter is implemented from OOo3.0 - see Issue 91020.

In the case of R1C1 notation only, Calc uses the ! character to separate the sheet identifier. A portable solution might be INDIRECT(ADDRESS(1 1 4 'Sheet2')). For example INDIRECT('Sheet2.A1') is valid in Calc, but in Excel the required form is INDIRECT('Sheet2!A1').

Excel represents some cell references differently to Calc, so this function is not always portable.

The type is zero, so RC is evaluated as R1C1 notation, in this case relative to cell B1: 3 rows down and 1 column across to yield a reference to cell C4. =INDIRECT('RC' 0) entered in cell B1, returns the contents of cell C4. The type is zero, so R2C3 is evaluated as R1C1 notation. =INDIRECT('R2C3' 0) returns the contents of cell C2. The type is non-zero, so B2 is evaluated as the usual A1 notation. =INDIRECT('B2' 99) returns the contents of cell B2. =SUM(INDIRECT('A1:C3')) returns the sum of the numbers in A1:C3. =INDIRECT(D3) where cell D3 contains the text B2 returns the contents of cell B2. =INDIRECT('B' & '2') also returns the contents of cell B2. INDIRECT('B2') returns a reference to cell B2, so this is the same as =B2.

=INDIRECT('B2') (in a cell) returns the contents of cell B2. Type is an optional number if 0, textref is taken to be in R1C1 notation, and otherwise (or if omitted) textref is taken to be in the usual A1 notation.Ī named reference is recognised with either type. The reference may then be used in formulas or functions requiring a reference - see the examples below.

INDIRECT(textref type) textref is a text string specifying the reference to be returned the reference may be to a single cell or to a range. Returns a reference, given a text string.

Librecalc