https://bugs.documentfoundation.org/show_bug.cgi?id=162088
--- Comment #8 from [email protected] --- (In reply to Eike Rathke from comment #4) > 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] "]" IDEA What if keywords were "[#All]" for "[#All]" "[#Data]" for [#Data]" "[#RowHeaders]" for "[#Headers]" "[#RowTotals]" for "[#Totals]" "[#This Row]" for "[#This row]" "@Row" for "@" "[#ColHeaders]" for <unavailable expression in MS Excel> "[#ColTotals]" for <unavailable expression in MS Excel> "[#This col]" for <unavailable expression in MS Excel> "@Col" for <unavailable expression in MS Excel> This would be an improving of expressions to use a fully functional DatabaseRange (bidimensional: horizontal and vertical). -- You are receiving this mail because: You are the assignee for the bug.
