Searched refs:range (Results 226 – 250 of 422) sorted by last modified time
12345678910>>...17
41 /** provides access to the settings of a named range in a spreadsheet50 /** returns the content of the named range.52 <p>The content can be a reference to a cell or cell range59 /** sets the content of the named range.61 <p>The content can be a reference to a cell or cell range83 /** returns the type of the named range.92 /** sets the type of the named range.95 a combination of flags that specify the type of a named range,
60 /** adds a new named range to the collection.63 the new name of the named range.68 <p>A cell range address is one possible content of a named69 range.</p>75 a combination of flags that specify the type of a named range,88 /** creates named cell ranges from titles in a cell range.94 part of the original range, excluding the labels.</p>101 range is named using cell B1 and contains the cell range address105 the cell range used to create the named ranges.116 /** removes a named range from the collection.[all …]
83 /** returns the range that is specified as title columns range.90 the range of columns that is specified as title columns range.96 /** specifies a range of columns as title columns range.98 <p>The rows of the passed range are ignored.</p>105 the title columns range.128 /** returns the range that is specified as title rows range.135 the range of rows that is specified as title rows range.141 /** specifies a range of rows as title rows range.143 <p>The columns of the passed range are ignored.</p>150 the title rows range.
43 /** allows to let the user to select a cell range.49 /** starts the range selection.53 range selection is done.58 /** aborts the range selection.62 /** adds a listener that is notified when range selection is completed73 /** adds a listener that is notified when the selected range is changed.
41 /** allows notification when the selected range is changed.47 /** is called when the selected range is changed while48 range selection is active.
41 /** allows notification when range selection is completed or aborted.47 /** is called when range selection is completed.51 /** is called when range selection is aborted.
45 /** provides methods to execute operations on a cell range or ranges.55 cell range(s).69 /** clears the specified contents of the current cell range(s).
52 <p>Each cell of the original range is contained in one of the
48 /** returns the address of the cell range in the spreadsheet document.51 can be used to address the range within its document.</p>
38 for a cell range.48 /** gets an array from the contents of the cell range.57 /** fills the cell range with values from an array.60 range. Each element of the array is interpreted the same way as
64 the cell range in which empty cells will be inserted.78 the cell range to remove.89 /** moves a cell range to another position in the document.91 <p>After copying the contents of the cell range, all cells95 the address of the top left cell of the destination range.98 the cell range which will be copied.106 /** copies a cell range to another position in the document.108 <p>The source cell range keeps unchanged.</p>111 the address of the top left cell of the destination range.114 the cell range which will be copied.
61 /** Returns a single cell within the range.76 if an index is outside the dimensions of this range.88 /** Returns a sub-range of cells within the range.94 is the row index of the first cell inside the range.97 is the column index of the last cell inside the range.100 is the row index of the last cell inside the range.106 the specified cell range.109 if an index is outside the dimensions of this range.123 /** Returns a sub-range of cells within the range.125 <p>The sub-range is specified by its name. The format of the range[all …]
63 the visible (not hidden) cells of the current cell range(s).72 the empty cells of the current cell range(s).88 all cells of the current cell range(s) with the specified102 all formula cells of the current cell range(s) with the121 all cells of the current cell range(s) which are different131 <p>This method takes each row of the current cell range(s) and140 all cells of the current cell range(s) which are different148 /** intersects the current cell range(s) with the specified cell range.151 contains the cell range for intersection.154 all cells of the current cell range(s) which are contained[all …]
84 /** returns the position of the top left cell of the cell range where91 /** sets the position of the top left cell of the cell range
74 /** returns the cell range containing the data for the data pilot table.80 /** sets the cell range containing the data for the data pilot table.88 source cell range are used for the data pilot table.
138 into one range (e.g. a value of 7 groups the members of a week139 into a range).</li>
50 /** returns the address of the cell range that contains the data58 cell range.
111 /** <p>This method returns a different output range of a DataPilot table 112 per specified output range type.</p>115 the range specified. See <type>DataPilotOutputRangeType</type> for a set116 of possible output range types.
59 <FALSE/> = queries cells dependent from the original range(s),65 cell range(s).78 <FALSE/> = queries precedent cells of the original range(s),84 range(s).
49 <p>A region is a cell range bounded by empty cells.</p>55 /** collapses the cursor into the range of the array formula to which68 <p>Expands the current cursor range in a way so that all merged69 cell ranges intersecting the current range will fit completely.70 If the cursor does not point to any range with merged cells, it91 /** changes the size of a cursor range.96 the number of columns of the new cursor range.98 the number of rows of the new cursor range.
41 /** provides access to the spreadsheet that contains a cell range.49 /** returns the spreadsheet interface which contains the cell range.
54 /** adds the given range to the collection of cell ranges.57 contains the address of the new range.60 defines how the range should be added. To merge the ranges69 /** removes the given range from the collection of cell ranges.72 contains the address of the range to be removed.74 <p>The specified range must fit exactly to an element of the75 collection. The method does not try to shorten a range.</p>78 if the collection does not contain the specified range.
64 <p>The range addresses are separated with semicolons. For instance
54 the current object (i.e. a database range).
46 /** provides access to the settings of a label range.
Completed in 82 milliseconds