https://bugs.documentfoundation.org/show_bug.cgi?id=162088
--- Comment #4 from Eike Rathke <[email protected]> --- The MS Open Specification "[MS-XLSX]: Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format" at https://learn.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/3d025add-118d-4413-9856-ab65712ec1b0 lists the ABNF grammar used by formulas. Search for "structure-reference", the following block (modulo comments) is exactly what needs to be added to ODFF as well: structure-reference = [table-identifier] intra-table-reference table-identifier = [book-prefix] table-name table-name = name ;table-name is the name of the table the structure reference refers to. If it is missing, the formula containing the structure reference MUST be entered into a cell which belongs to a table and that table's name is used as the table-name. table-name MUST be the value of the displayName attribute of some table element ([ISO/IEC29500-1:2016] section 18.5.1.2). It MUST NOT be any other user-defined name. intra-table-reference = spaced-lbracket inner-reference spaced-rbracket / keyword / ("[" [simple-column-name] "]") inner-reference = keyword-list / ([keyword-list spaced-comma] column-range) keyword = "[#All]" / "[#Data]" / "[#Headers]" / "[#Totals]" / "[#This Row]" keyword-list = keyword / ("[#Headers]" spaced-comma "[#Data]") / ("[#Data]" spaced-comma "[#Totals]") column-range = column [":" column] column = simple-column-name / ("[" *space simple-column-name *space "]") simple-column-name = [any-nospace-column-character *any-column-character] any-nospace-column-character escape-column-character = tick / "[" / "]" / "#" tick = %x27 unescaped-column-character = character ; MUST NOT match escape-column-character or space any-column-character = any-nospace-column-character / space any-nospace-column-character = unescaped-column-character / (tick escape-column-character) spaced-comma = [space] comma [space] spaced-lbracket = "[" [space] spaced-rbracket = [space] "]" -- You are receiving this mail because: You are the assignee for the bug.
