REM The Field property is the zero based column REM the first field so this is not required. REM how to connect to the previous field. REM I could use the Connection property to indicate OFilterDesc = oSheet.createFilterDescriptor(True) REM descriptor with the previous settings. REM If argument is True, creates an empty filter OSheet = ThisComponent.getSheets().getByIndex(0) The macro in Listing 5 creates a simple filter for the first sheet.ĭim oSheet ' Sheet that will contain the filter.ĭim oFields(0) As New .TableFilterField Finally, use the drop-down arrow to choose an appropriate auto filter. Use Data > Filter > AutoFilter to insert the auto filter combo box in the appropriate cell. Although you can place the auto filter in any row, only the rows below the auto filter are filtered. If you do not select the title rows, Calc asks if the title row or the current row should be used. For example, using the data in Table 1, select data in columns B and C. To create an auto filter, first select the columns to filter. An auto filter entry is created for each unique entry in the column.In other words, more than ten rows may be displayed. If the value 70 is in the top ten values, then all rows containing the value 70 in the filtered column are displayed. The Top 10 auto filter displays the ten rows with the largest value.The Standard auto filter opens the Standard Filter dialog and is the same as the standard filter.The All auto filter causes all rows to be visible.The combo box provides quick access to each of the auto filter types. After creating an auto filter for a specific column, a combo box is added to the column. Use auto filters to quickly create easily accessible filters found to be commonly used in many different types of applications. To avoid this problem, you must individually select each of the filtered rows using the control key. Operations, such as delete, act on all of the selected rows. If you select multiple rows in one operation, you will also select the invisible rows contained between the selected visible rows. After applying a filter, some rows are visible and some rows are not.
0 kommentar(er)
