Skip to content
Blame History Permalink
  • Steven Cunnane's avatar
    Add xloIndex function to Utils which extends the Excel INDEX function to cache... · 9f59d58c
    Steven Cunnane authored 
    Add xloIndex function to Utils which extends the Excel INDEX function to cache refs and sub-arrays.  To support this,:
* Improve handling of negative indices in ExcelArray
* Add function to conveniently copy an ExcelArray to a new ExcelObj
* objectCacheExpand function to simplify processing of xloref args

tests: added unit tests for ExcelArray and added xloIndex to Utils test spreadsheet
    9f59d58c