implementation of table structured references in libreoffice calc · 2 table structured references...
TRANSCRIPT
![Page 1: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/1.jpg)
Implementation of Table Structured References in LibreOffice Calc
Eike Rathke, Red Hat, Inc.2015-09-25
![Page 2: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/2.jpg)
2Table Structured References in Calc, Eike Rathke (erAck)
About the Speaker
Eike Rathke, known on the net as erAckBased in Hamburg, GermanyWorked on StarOffice from 1993 to 2000 for Star DivisionWorked on OpenOffice.org from 2000 to 2011 for Sun Microsystems and one other companyWorks on LibreOffice since 2011, employed by Red Hat, Inc.Areas of expertise:
Calc core, formula compiler and interpreternumber formatter/scanneri18n framework, locale data
Also mentor and knowledge spreader whenever possibleWeb site http://erack.de/
![Page 3: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/3.jpg)
3Table Structured References in Calc, Eike Rathke (erAck)
Agenda
Brief overview on formula compilationChallenges of Table structured referencesImagine all the tokensSolve the puzzle
![Page 4: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/4.jpg)
4Table Structured References in Calc, Eike Rathke (erAck)
Brief overview on formula compilation
Only what is needed to understand the later approach …
![Page 5: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/5.jpg)
5Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
=SUM(A2:A4)
![Page 6: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/6.jpg)
6Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
=SUM(A2:A4)Two passes1.Scan text into tokens, each token with
OpCode (enum values of functions, operators, ...)StackVarEnum (type of token)Stored in FormulaTokenArray::pCode
![Page 7: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/7.jpg)
7Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClose
![Page 8: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/8.jpg)
8Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
![Page 9: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/9.jpg)
9Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
=SUM(A2:A4)Two passes1.Scan text into tokens, each token with
OpCode (enum values of functions, operators, ...)StackVarEnum (type of token)Stored in FormulaTokenArray::pCode
![Page 10: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/10.jpg)
10Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
=SUM(A2:A4)Two passes1.Scan text into tokens, each token with
OpCode (enum values of functions, operators, ...)StackVarEnum (type of token)Stored in FormulaTokenArray::pCode
2.Create a sequence of interpret-able tokensin Reverse Polish Notation (RPN)through a recursive descending parserStored in FormulaTokenArray::pRPN
![Page 11: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/11.jpg)
11Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
![Page 12: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/12.jpg)
12Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocSum
![Page 13: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/13.jpg)
13Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocSum ┐ └
![Page 14: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/14.jpg)
14Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocSum ┐ └ ocPush
![Page 15: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/15.jpg)
15Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocSum ┐ └ ocPush ┘
![Page 16: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/16.jpg)
16Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocSum ┐ └
ocPush
![Page 17: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/17.jpg)
17Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocPush ocSum
![Page 18: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/18.jpg)
18Table Structured References in Calc, Eike Rathke (erAck)
Compiling a Formula
SUM ( A2:A4 )↓ ↓ ↓ ↓ocSum ocOpen ocPush ocClosesvByte svSep svDoubleRef svSep
ocPush ocSumsvDoubleRef svByte
![Page 19: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/19.jpg)
19Table Structured References in Calc, Eike Rathke (erAck)
Challenges of Table structured references
It might look easy, but ...
![Page 20: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/20.jpg)
20Table Structured References in Calc, Eike Rathke (erAck)
Challenges of TableRef
Header1 Header2
Data11 Data21
Data12 Data22
Data13 Data23
Total1 Total2
A table is a cell range defined as a named database rangeOptional header rowOne or more data rowsOptional totals row
Table structured references provide a syntax to address different parts of such tableAssume this sample table to be named Table and to cover cells A1:B5 for the examples later
![Page 21: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/21.jpg)
21Table Structured References in Calc, Eike Rathke (erAck)
Challenges of TableRef
structure-reference = [table-identifier] intra-table-reference
table-identifier = [book-prefix] table-name
table-name = 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] "]"
(Definitions excerpt of [MS-XLSX]: 2.2.2 Formulas, https://msdn.microsoft.com/en-us/library/dd906358.aspx)
![Page 22: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/22.jpg)
22Table Structured References in Calc, Eike Rathke (erAck)
Challenges of TableRef
Example Reference Resulting Range
Table[[#All]] A1:B5 (entire table)
Table[] A2:B4 (data area)
Table[[#Data]] A2:B4 (data area)
Table[[#Headers]] A1:B1 (header row)
Table[[#Totals]] A5:B5 (totals row)
Table[[Header1]] A2:A4 (data of column Header1)
Table[[#Data],[Header1]] A2:A4 (data of column Header1)
Table[[#Totals],[Header1]] A5 (totals of column Header1)
Table[[#Headers],[#Data],[Header1]] A1:A4 (header and data of column Header1)
Table[[#This Row]] A1:B1,A2:B2,… (all cells of this row)
Table[[#This Row],[Header1]] A1,A2,… (this row's cell of column Header1)
Table[[#This Row],[Header1]:[Header2]] A1:B1,A2:B2,… (this row's cells of column range)
![Page 23: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/23.jpg)
23Table Structured References in Calc, Eike Rathke (erAck)
Imagine all the tokens
One for each...
![Page 24: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/24.jpg)
24Table Structured References in Calc, Eike Rathke (erAck)
Imagine all the tokens
Symbol Token
Table (name) ocDBArea, already existed
[ ocTableRefOpen
] ocTableRefClose
#All ocTableRefItemAll
#Headers ocTableRefItemHeaders
#Data ocTableRefItemData
#Totals ocTableRefItemTotals
#This Row ocTableRefItemThisRow
, ocSep
: ocRange
… resulting token / reference ocTableRef
![Page 25: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/25.jpg)
25Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
With yet another new token...
![Page 26: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/26.jpg)
26Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
=SUM(Table[[#Data],[Header1]])
![Page 27: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/27.jpg)
27Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
=SUM(Table[[#Data],[Header1]])Table[[#Data],[Header1]]
![Page 28: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/28.jpg)
28Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [[#Data],[Header1]]↓ocDBAreasvIndex
![Page 29: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/29.jpg)
29Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [#Data],[Header1]]↓ ↓ocDBArea ocTableRefOpensvIndex svSep
![Page 30: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/30.jpg)
30Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [#Data],[Header1]]↓ ↓ocDBArea ocTableRefOpensvIndex svSep↘ocTableRefsvIndex(ScTableRefToken, additionally holds item information and another token reference)
![Page 31: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/31.jpg)
31Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [#Data],[Header1]]↓ ↓ocTableRef ocTROsvIndex svSep
![Page 32: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/32.jpg)
32Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data],[Header1]]↓ ↓ ↓ocTableRef ocTRO ocTROsvIndex svSep
![Page 33: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/33.jpg)
33Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ],[Header1]]↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTableRefItemDatasvIndex svSep
![Page 34: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/34.jpg)
34Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ],[Header1]]↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTableRefItemDatasvIndex svSep#Data
![Page 35: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/35.jpg)
35Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] ,[Header1]]↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRCsvIndex svSep#Data
![Page 36: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/36.jpg)
36Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] , [ Header1 ]]
↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRC ocSep ocTRO ocPush
svIndex svSep svSingleRef
#Data A1
![Page 37: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/37.jpg)
37Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] , [ Header1 ] ]
↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRC ocSep ocTRO ocPush C C
svIndex svSep svSingleRef
#Data A1
![Page 38: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/38.jpg)
38Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] , [ Header1 ] ]
↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRC ocSep ocTRO ocPush C C
svIndex svSep svSingleRef
#Data A1
ocPush
svDoubleRef
A2:A4
![Page 39: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/39.jpg)
39Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] , [ Header1 ] ]
↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRC ocSep ocTRO ocPush C C
svIndex svSep svSingleRef
#Data A1
ocPush
svDoubleRef
A2:A4
![Page 40: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/40.jpg)
40Table Structured References in Calc, Eike Rathke (erAck)
Solving the puzzle
Table [ [ #Data ] , [ Header1 ] ]
↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ ↓ocTableRef ocTRO ocTRO ocTRID ocTRC ocSep ocTRO ocPush C C
svIndex svSep svSingleRef
#Data A1
ocPush
svDoubleRef
A2:A4
ocPush
svDoubleRef
A2:A4
![Page 41: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/41.jpg)
41Table Structured References in Calc, Eike Rathke (erAck)
Questions?
I might be able to answer...
![Page 42: Implementation of Table Structured References in LibreOffice Calc · 2 Table Structured References in Calc, Eike Rathke (erAck) About the Speaker Eike Rathke, known on the net as](https://reader031.vdocuments.us/reader031/viewer/2022013110/5c04e79009d3f2093a8ca795/html5/thumbnails/42.jpg)
42Table Structured References in Calc, Eike Rathke (erAck)
All text and image content in this document is licensed under the Creative Commons Attribution-Share Alike 3.0 License (unless otherwise specified). "LibreOffice" and "The Document Foundation" are registered trademarks. Their respective logos and icons are subject to international copyright laws. The use of these therefore is subject to the trademark policy.
Thank you …
… for using LibreOffice!… for supporting LibreOffice!… for hacking LibreOffice!