Add ForeignTable class

[jferard]

A foreign table is a table from another ods file. It is defined by a file and a name. Would be useful for filters, links, ...

To do: check if this complies the OASIS standard before doing anything.

[jferard]

Checked:

19.910.33 The xlink:href attribute specifies the target location of a hyperlink. The xlink:href attribute is usable with the following element: 6.1.8. The xlink:href attribute has the data type anyIRI 18.3.2.

[jferard]

Example:

'file:///path/to/file.ods'#$sheet.A1

[jferard]

PositionUtil and PositionBuilder should do the trick with a little modification.

[jferard]

Design:

• Position
• Range
• PositionRef (with optional $)
• RangeRef (with optional $)
• TableRef (with optional $)
• FullPosition = Table + Position
• FullRange = Table + Range
• FullPositionRef = TableRef + PositionRef
• FullRangeRef = TableRef + RangeRef

[jferard]

address string --- parse ---> file, table, position (row, col) or range (row1, col1, row2, col2) for FastODS internal use.

position (row, col) --- toString ---> positionRef (for urls)
range (row1, col1, row2, col2) --- toString ---> positionRef (for urls)
table --- getName ---> tableRef (for urls)