When you select filter by condition, MyOffice Spreadsheet suggests conditions depending on the type of data in the selected range: if the range contains more numeric values, filter conditions for numbers are used, otherwise filter conditions for dates are used, provided that there is data of this type in the range.
The matches between the comparison conditions for dates and numbers are shown in the table below. Other filter conditions have no matches.
Comparison condition for dates |
Comparison condition for numbers |
|---|---|
Exact date |
Equal to |
Before |
Less that |
After |
Greater than |
Between |
Between |
In the current version of the application, you can filter data by only one condition.