Jahn, Ray (R.) wrote:
The symptoms can be divided into two types:
* a brand new spreadsheet file
a brand new and empty spreadsheet
no content in any cell
aXCellRange.queryEmptyCells() always returns nothing
regardless what the range is set to.
* a brand new spreadsheet file
a brand new spreadsheet
one single cell filled with content
aXCellRange.queryEmptyCells() returns a correct result
only if the range includes the cell with content.
It returns nothing for all other settings of spreadsheet ranges,
be it a row range, a column range, a block range,
as long as the range excludes the cell with content.
See issue 20044.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]