In INDIRECT, the parameter is appended as the 2nd parameter.

wg_abbrev=office-formula feature-info: ODFF in section "5.10.5 Automatic Intersection" defines the '!! To comply with the specification this needs to be written to and read from ODF 1.2 files.The INDIRECT function is written as is to ODF 1.0/1.1 format; if the 2nd parameter was present, an older version of Calc will return an error for that function.This is on purpose, as ADDRESS usually is used in conjunction with INDIRECT, and when stored to ODF 1.0/1.1 format this combination will more likely return an error result upon recalculation if the R1C1 notation was used.Both functions still use the dot '.' sheet name separator with A1 notation.When opening documents stored in ODF 1.0 or 1.1 format, an ADDRESS function appearing in a formula expression gets a 4th parameter of value 1 inserted if a sheet name was given as 4th parameter, shifting the sheet name to the 5th parameter.When given two parameters, Searched is first examined: - If Searched is square or is taller than it is wide (more rows than columns), LOOKUP searches in the first column (similar to VLOOKUP), and returns the corresponding value in the last column.

You must have an account to comment. Please register or login here!