Difference between revisions of "Documentation/DevGuide/Spreadsheets/Capabilities of Columns and Rows"

Revision as of 10:20, 5 June 2008

All cell ranges are organized in columns and rows, therefore column and row containers are retrieved from a spreadsheet, as well as from sub-ranges of a spreadsheet through com.sun.star.table.XColumnRowRange. These containers are com.sun.star.table.TableColumns and com.sun.star.table.TableRows. Both containers support index and enumeration access. Only the TableColumns supports name access to the single columns and rows (com.sun.star.table.TableColumn and com.sun.star.table.TableRow) of a SheetCellRange.

The following UML charts show table columns and rows. The first chart shows columns:

Collection of table columns

The collection of table rows differs from the collection of columns, that is, it does not support com.sun.star.container.XNameAccess:

Collection of table rows

The services for table rows and columns control the table structure and grid size of a cell range:

• The containers for columns and rows have methods to insert and remove columns, and rows by index in their main interfaces com.sun.star.table.XTableRows and com.sun.star.table.XTableColumns.
• The services TableColumn and TableRow have properties to adjust their column width and row height, toggle their visibility, and set page breaks.