More flexible cell formula notation


Version: 2021b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-22606


For following notation is now allowed:

[book1]1!A1   // Cell A1 from book1
[A1$]1!A2     // Cell A2 from a different bookname stored in cell A1
[A1$]1!B[0]   // Last cell of col(B) in book name stored in A1