Worksheet Query default to select rows


Version: 2023b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-26442


If all columns are selected, Worksheet Query tool and wxt X-Function will select whole rows instead of block cells now.

This is improved to work better with the newly improved wks.deleteRows() command.

E.g. wxt "col(B)>5000" sel:=1, used to select block cells that fits condition instead of the rows, therefore when user want to run wks.deleteRows() to delete those selected rows, a selection block remains which is anoying. Now row is being deleted, and no selection will be left.