[FAQ000154]The filtered rows are copied as well

Q

On the CELF sheet, when I copied the data filtered by the filter,

the hidden cells were copied as well.

A

In CELF, when selecting and copying a range,

since the rows hidden by the filter are also included in the copy range target,

there is a way to narrow down the search criteria instead of using the filter, as shown below.

・Before displaying the data on the sheet, narrow down the conditions using

"Get multiple records from table" action, etc., and then retrieve the data from the table.

・After displaying the data on the sheet, retrieve the data from the table using

the "Get multiple records from table" action, etc., and set the data in the cell by narrowing down the conditions

when displaying on the sheet.