v20260311 (Patch)
ยท One min read
This patch improves the reliability of matrix formulas when used with row and column templates, ensuring lookup functions correctly evaluate relative to each cell.
New Features & Major Enhancements ๐โ
Matrix Formula Context Improvementsโ
Enhanced how matrix lookup functions resolve context when used in templated row and column spaces, ensuring each generated cell evaluates independently.
Fixes & Improvements ๐ ๏ธโ
- Fixed an issue where
FINDCELLINCOLused in a row space with an Extends-enabled template could return the same cell for every generated row. - Corrected behavior so
FINDCELLINCOLnow finds the cell in the same column as the referencing cell, producing unique values per row. - Fixed the same context issue affecting
FINDCELLINROWwhen used in column space templates.