-
Notifications
You must be signed in to change notification settings - Fork 94
Open
Description
Excel 365 has a new cell notation for field names, in the current version this is parsed as a namedrange.
You would expect: CellToken.FieldName
Example
Cell notation
D2 is a 'Amsterdam' converted to Geography.
Named ranges, Amsterdam, 'Hello.World' are D2
Not different from a namedrange
=Amsterdam.Population
Different from namedrange using the square brackets.
=D2.[Population]
=Amsterdam.[Population]
=Hello.World.[Population]
Difference is D2 is cell
=D2.Population
Function notation
=fieldvalue(D2,"Population")
Metadata
Metadata
Assignees
Labels
No labels