ONLYOFFICE FALSE: Logical Values and Review-Override Examples
Create a logical FALSE in ONLYOFFICE, test its value type and compare an inactive review override inside OR with a blocking AND condition.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
FALSE() returns the logical FALSE value. It has no input to evaluate, so it is useful as an explicit constant or the initial state of a worksheet control. It does not mark a record as invalid by itself.
Availability and version history
- Introduced: The first introduction release and date are not established by the checked sources.
- Availability: Currently documented in ONLYOFFICE’s rolling Spreadsheet Editor help; no final supported-version endpoint is established.
- Scope: Docs and Desktop Editors release separately. The shared help does not establish every older build or mobile client’s behavior.
- Checked: October 14, 2026, against the official FALSE reference. Examples were independently evaluated as logical models; these cases were not tested in the native application.
Syntax and a direct type check
=FALSE()
The official reference documents a function with no arguments. Keep its parentheses empty. To evaluate a condition, write the condition or use a logical function that accepts it.
Create FalseControls and enter these formulas:
| Cell | Formula | Expected result |
|---|---|---|
| A2 | =FALSE() |
FALSE |
| A3 | ="FALSE" |
The text FALSE |
| B2 | =ISLOGICAL(A2) |
TRUE |
| B3 | =ISLOGICAL(A3) |
FALSE |
| D2 | =IF(A2,"Yes branch","No branch") |
No branch |
| D3 | =NOT(A2) |
TRUE |
ISLOGICAL checks a type, so it returns TRUE for the logical FALSE in A2. The quoted string in A3 is a different type. This distinction follows the official ISLOGICAL description; it does not imply that every function converts those two inputs identically.
Practical example: a manual review override starts off
Create ReviewControl. Put Order, Status and Units in A1:C1 and enter:
| Row | Order | Status | Units |
|---|---|---|---|
| 2 | R201 | Ready | 3 |
| 3 | R202 | Hold | 2 |
| 4 | R203 | Ready | 0 |
| 5 | R204 | Hold | 0 |
Put Force review in G2 and =FALSE() in H2. Put Review needed in D1 and Action in E1.
In D2 enter =OR($H$2,B2="Hold",C2=0) and fill through D5. Expected results are FALSE,TRUE,TRUE,TRUE. The false override contributes no positive review reason; each record’s status and units determine the result.
In E2 enter =IF(D2,"Review","Proceed") and fill to E5. Expect Proceed,Review,Review,Review. R204 has two review reasons, but it still receives a single logical flag and one label.
Change H2 to =TRUE(). All four D results become TRUE and all four E labels become Review. Restore =FALSE() afterward. Keep the source records unchanged so the control’s effect is visible. The worksheet flag is not a security or permissions feature.
Why the same constant behaves differently inside AND
On ReviewControl, keep H2 FALSE. In F2 enter =AND($H$2,C2>0) and fill through F5. Every result is FALSE, including the positive-unit rows.
This expression requires both the false flag and the unit test to be true, so no record can pass. It is a different rule from the OR review override. Choosing FALSE as a control value does not determine its effect without considering the function around it.
On FalseControls, put =OR(FALSE(),FALSE()) in D5, =OR(FALSE(),TRUE()) in D6 and =AND(FALSE(),TRUE()) in D7. The expected results are FALSE,TRUE,FALSE. In D8, =NOT(NOT(FALSE())) returns FALSE again.
Do not confuse a false result with missing data
A genuine FALSE can be a complete answer to a logical question. It does not mean the formula cell is empty, that an input was missing, or that a calculation failed. Keep those checks separate instead of treating every false flag as an error.
The short function page does not specify all numeric, text, blank or imported-array coercion behavior in other functions. These examples use explicit comparisons and logical constants. No native error token or evaluation-order guarantee is inferred from them.