Skip to content

Cannot parse field name cell notation #133

@dcrasch

Description

@dcrasch

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions