I made a google sheet with Listview and spreedsheet linked
I use the filter function of Listview to take out the filtered data
After the filtered processed data is written back to the sheet, the data on the Listview is not updated at the same time. I try to refresh the data of the Listview, but the words on the Filter column still exist, but the ListView is an unfiltered data. What is the solution? You can filter the text on the Filter Bar again in the program