Category / Section
Common Error: Index Out of Bounds in Details Task
2 mins read
Issue Explanation
An error occurred because the index specified in the details task is out of bounds: ${messages}
. The maximum index is based on the input range.
Explanation of Absolute vs. Relative Index
Absolute Index
An absolute index specifies the exact location of a cell using its column and row labels. This format remains constant, regardless of changes or movements in the data range.
- Format:
[col A]
,[row 1]
- Example:
[col A]
refers to column A,[row 1]
refers to row 1.
Relative Index
A relative index specifies the location of a cell relative to the starting point of the selected input range. This format adjusts if the data range changes or moves.
- Format:
col1
,row1
- Example:
col1
refers to the first column in the selected input range,row1
refers to the first row in the selected input range.
Solution
- Edit Details Task: Ensure the index used in the details task is within the input range limits.
- Valid Index Formats:
- Relative Index:
col1
,row1
- Absolute Index:
[col A]
,[row 1]
- Relative Index:
- Ensure Correct Indexing: Verify that your relative or absolute indexes do not exceed or fall outside the input range.
Sample Input Range vs. Valid and Invalid Index Format
Scenario 1
- Input Range:
Data!A1:B10
- Valid Index:
col1
,row1
,[col A]
,[row 1]
- Invalid Index:
- Absolute:
[col C]
(Column C is outside the range),[row 11]
(Row 11 is outside the range) - Relative:
col3
(Column 3 is outside the range),row11
(Row 11 is outside the range)
- Absolute:
- Valid Index:
Scenario 2
- Input Range:
Data!C5:D20
- Valid Index:
col1
,row1
,[col C]
,[row 5]
- Invalid Index:
- Absolute:
[col E]
(Column E is outside the range),[row 21]
(Row 21 is outside the range) - Relative:
col3
(Column 3 is outside the range),row16
(Row 16 is outside the range)
- Absolute:
- Valid Index:
Scenario 3
- Input Range:
Sheet1!E1:F15
- Valid Index:
col1
,row1
,[col E]
,[row 1]
- Invalid Index:
- Absolute:
[col G]
(Column G is outside the range),[row 16]
(Row 16 is outside the range) - Relative:
col3
(Column 3 is outside the range),row16
(Row 16 is outside the range)
- Absolute:
- Valid Index:
Scenario 4
- Input Range:
Sheet2!G10:H30
- Valid Index:
col1
,row1
,[col G]
,[row 10]
- Invalid Index:
- Absolute:
[col I]
(Column I is outside the range),[row 31]
(Row 31 is outside the range) - Relative:
col3
(Column 3 is outside the range),row22
(Row 22 is outside the range)
- Absolute:
- Valid Index:
Scenario 5
- Input Range:
Data!A1:C5
- Valid Index:
col1
,row1
,[col A]
,[row 1]
- Invalid Index:
- Absolute:
[col D]
(Column D is outside the range),[row 6]
(Row 6 is outside the range) - Relative:
col4
(Column 4 is outside the range),row6
(Row 6 is outside the range)
- Absolute:
- Valid Index:
Ensure your relative index in detail tasks such as col1
, row1
or absolute index such as [col A]
, [row 1]
does not exceed or fall outside the input range. For further assistance, please contact our support team.