Created this with the AI bot but seemed right ot me except a few edits**
Product / Version:**
ONLYOFFICE Desktop Editors, Community version 9.3.1.8 (x64 MSI) on Windows 11
Description:
When using Data validation with type “Other” and selecting a range using the picker, the editor generates a formula that is not a valid logical expression, so the rule is effectively invalid.
Steps to reproduce:
- Open a spreadsheet in Desktop Editors.
- Select any cell (e.g.
A1). - Go to Data → Data validation.
- Set Type to Other.
- Click the range selector and select cells
E10:F17. - Confirm the dialog.
Actual result:
- The condition field is filled with
=$E$10:$F$17. - This is not a valid logical (TRUE/FALSE) expression for a custom validation rule.
- The UI makes it look like this is a valid rule, but it doesn’t work as expected.
Expected result:
- Either:
- It should tell me to use list not “other”
- “Other” should require/enforce a logical formula and warn if the user enters only a bare range; or ( or be called logic formula or similar)
- The range picker in “Other” should be clearly indicated as “Insert reference into custom formula”; or
- The product should help convert the selection into a valid expression or guide the user (e.g.
=COUNTIF($E$10:$F$17, A1) > 0).
Additional info:
- I initially used “Other” because I could select a range and expected behavior similar to a “List” rule
- I later found that List is the correct type for “values from a range”, but the “Other” behavior is confusing to a new user like me