Support col(A) notation. E.g., =[book1]1!col(A)[1]

Book Name support resolving string varaible. E.g., Fill A1 cell with “Book1”, the cell formula =[A1$]1!A1 can refer to A1 cell in the 1st sheet of Book1

Support A0 notation. E.g., =[A1$]1!B0