Feature request: Or filter

[ken-mills]

I realize I can input a custom filter for Or for example ~[dog|cat]. It would be great if that feature was available in the filter popup by selecting multiple values and then selecting apply. Currently, when I select a single value, the column is only filtered by that single value. Multiple selections is not an option.
Thanks so much.
--Ken

[cscan]

Yes, now the dialog just provides single-selection mode. I will think about it.

[ken-mills]

I came up with a solution which does not require the user to type a regex expression each time. It appears to work for my use case while still supporting existing filter conditions. The fix opens the dialog with a brief instruction, then requires the user to select a filter condition prior to clicking one or more checkbox options, and then select apply. Let me know if you would like to review a pull request and update the instructions. I called the option:

thisOrThat: '| This Or That',

I added a new "|" filter condition and supporting filter function, case #10 to support uppercase. The checkboxes values are captured using v-model.

...panelFilter.vue

v-model="selectedFilters"
.
.
. 
if (this.selectedFilters.length === 1) {
 opt = this.inputFilterCondition + this.selectedFilters[0]
} else {
 if (this.inputFilterCondition === '|') {
   opt = "|" + this.selectedFilters.join("|")
 }
}

...VueExcelEditor

case this.columnFilter[k].startsWith('|'):
 filter[k] = {type: 10, value: this.columnFilter[k].slice(1).trim().toUpperCase()}
 break

[cscan]

Let me think about it