i'm trying to traverse all cells of an openoffice spreadsheet.
selectElementsByContent(..., \&action) seems to be insufficient because i need to change the cells' type (to e.g. float) and &action doesn't get sufficient arguments to be able to do that, it seems.
the &action gets the surrounding element, not the cell, and it doesn't get cell coordinates, so i've got no idea how to access the cell.
traversing all cells by checking the grid of all rows and columns isn't easy, either.
firstly, like the documentation indicates, getTableSize() is of no use.
- on an unnormalized table, it gives back useless results, because there are cells outside the range it indicates.
- the arguments to normalizeSheet() have to be guessed?
problem is, that guessing to small will not cover all cells, and guessing to large will result in a very slow program because cellValue/cellValueType seem to be very slow, perhaps even more so when it is used to access empty cells?
i'd be delighted if somebody could share an idea on how to traverse all cells of an openoffice spreadsheet.
order is not important, and i don't even need to know the cells coordinates, as long as i cover them all.
(4)
]
