|
When adjacent cells have the same content, OOo stores the content once, with a 'repeated' attribute.
Subsequent rows with the same content are stored in the same way.
So, by default, there is no one-to-one mapping between stored and displayed cells.
Before addressing row and cells in a spreadsheet, you must explictly declare an area, beginning in the top left cell ("A1"), with given height and width. This area (and only this area) is preprocessed in order to implement a normalized mapping, allowing subsequent direct cell addressing by logical coordinates.
You can do that with the getTable() method, with the two optional size arguments. Example:
my $sheet = $doc->getTable("Sheet1", 25, 18);
The instruction above normalizes the cell addressing scheme for a 25x16 area in a given sheet.
See getTable() and normalizeSheet() in the OpenOffice::OODoc::Text man page.
(There is no difference between 2.011 and 2.012 about table cell addressing.)
|
(4)
]
