Common Error: Index Out of Bounds in Details Task

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]
• 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)

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)

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)

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)

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)

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.