Methods' Details |
queryVisibleCells
- Description
- queries all visible cells.
- Returns
- the visible (not hidden) cells of the current cell range(s).
|
|
queryEmptyCells
- Description
- queries all empty cells.
- Returns
- the empty cells of the current cell range(s).
|
|
queryContentCells
- Description
- queries all cells with the specified content type(s).
- Parameter nContentFlags
- a combination of CellFlags flags.
Attention: Despite the CellFlags flags are
long values, this method expects a short
parameter.
Attention: Empty cells in the range may be skipped depending on
the content flag used. For instance, when querying for STYLES,
the returned ranges may not include empty cells even if styles are
applied to those cells.
- Returns
- all cells of the current cell range(s) with the specified
content type(s).
|
|
queryFormulaCells
- Description
- queries all formula cells with the specified result type.
- Parameter nResultFlags
- a combination of FormulaResult flags.
- Returns
- all formula cells of the current cell range(s) with the
specified result type(s).
|
|
queryColumnDifferences
- Description
- queries all cells with different values in a specified row.
This method takes each column of the current cell range(s) and
compares all cells with the cell in the specified row. All cells
which are different to this comparison cell will be returned.
- Parameter aCompare
- contains a cell address with the row index used for comparison.
Only this row index is of interest.
- Returns
- all cells of the current cell range(s) which are different
to the comparison cell of each column.
|
|
queryRowDifferences
- Description
- queries all cells with different values in a specified column.
This method takes each row of the current cell range(s) and
compares all cells with the cell in the specified column. All cells
which are different to this comparison cell will be returned.
- Parameter aCompare
- contains a cell address with the column index used for
comparison. Only this column index is of interest.
- Returns
- all cells of the current cell range(s) which are different
to the comparison cell of each row.
|
|
queryIntersection
- Description
- intersects the current cell range(s) with the specified cell range.
- Parameter aRange
- contains the cell range for intersection.
- Returns
- all cells of the current cell range(s) which are contained
in the passed cell range.
|
|
Top of Page
Copyright © 2000, 2014 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.
Privacy Policy | Impressum (Legal Info) | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.