ONLYOFFICE TRUE: Logical Constants, Type Checks and Enable Flags
Use the TRUE function in ONLYOFFICE, distinguish logical values from text and build an explicit enable flag without bypassing other conditions.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
TRUE() returns a logical TRUE value without testing any input. It is useful as an explicit Boolean constant in a formula or as a clearly defined worksheet control. It does not inspect a record or prove that a condition is satisfied.
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 TRUE reference. Examples were independently evaluated as logical models; these cases were not tested in the native application.
Syntax and the value type
=TRUE()
The official reference shows empty parentheses and no arguments. Enter the function as written. Do not put the condition you want to test inside TRUE’s parentheses; write that comparison separately.
A logical value is different from the text string "TRUE". To make the difference visible, create LogicalValues and enter:
| Cell | Formula | Expected result |
|---|---|---|
| A2 | =TRUE() |
TRUE |
| A3 | =FALSE() |
FALSE |
| A4 | ="TRUE" |
The text TRUE |
| B2 | =ISLOGICAL(A2) |
TRUE |
| B3 | =ISLOGICAL(A3) |
TRUE |
| B4 | =ISLOGICAL(A4) |
FALSE |
Both A2 and A3 have a logical type, even though their truth values differ. B3 asks whether A3 is logical, not whether A3 is true. The ISLOGICAL reference defines that type test. A cell’s visible word alone is not enough to identify its stored type.
Use the constant to test an IF branch
On LogicalValues, enter =IF(TRUE(),"Selected","Other") in D2. Expect Selected. In D3 enter =IF(FALSE(),"Selected","Other"); expect Other.
The two controls let you check the intended branch outputs independently of any source data. Afterward, use a real logical test where the decision belongs. Leaving TRUE() as the condition would always select the same branch.
Practical example: an enable flag that preserves the actual rules
Create EligibilityControl. Put Order, Spend and Units in A1:C1, then enter:
| Row | Order | Spend | Units |
|---|---|---|---|
| 2 | R101 | 150 | 2 |
| 3 | R102 | 80 | 3 |
| 4 | R103 | 200 | 0 |
| 5 | R104 | 120 | 1 |
Put Evaluation enabled in G2 and =TRUE() in H2. Put Eligible in D1. In D2 enter =AND($H$2,B2>=100,C2>0) and fill through D5. Expect TRUE,FALSE,FALSE,TRUE.
TRUE does not waive the spend or unit requirements. It allows those other AND conditions to determine the result. The $H$2 reference stays fixed as the row-specific comparisons advance.
Change H2 to =FALSE(); D2:D5 becomes FALSE,FALSE,FALSE,FALSE. Restore =TRUE() after checking. This is a worksheet scenario switch, not an access-control mechanism or protection against editing the underlying data.
Check the effect of the surrounding operator
Keep the previous columns intact. In E2 enter =OR($H$2,B2>=100) and fill through E5 while H2 is TRUE. Every result is TRUE, including the 80-spend row. With OR, one unconditional TRUE makes the whole expression true; it does not preserve the spend requirement.
In LogicalValues, =AND(TRUE(),FALSE()) in D5 returns FALSE, =OR(TRUE(),FALSE()) in D6 returns TRUE, and =NOT(TRUE()) in D7 returns FALSE. These results follow the respective logical rules; TRUE itself always supplies the same value.
Limits and related functions
The current TRUE entry does not document every way imported text, numbers or arrays may be converted by other functions. These examples create logical values explicitly and do not rely on such conversion. English formulas use commas between other functions’ arguments; TRUE itself has none.