=LOWER(text)

There is one argument: no second argument, no optional count, and no documented default when text is omitted. For a literal, use "Sample Text"; for a cell use A2. Do not type the placeholder word text in a real cell formula. The argument order and spelling come from the official LOWER entry, checked 2026-10-11.

The current English ONLYOFFICE Spreadsheet Editor function catalogue includes this function. Its individual official function reference is unversioned. This proves documentation coverage, not that every past Docs server release, Desktop Editors build or mobile application implements identical behaviour. First supported release: not established by the reviewed documentation. This guide is scoped to the documented English-language Spreadsheet Editor and is subject to a real desktop/web test before publication; mobile parity is unverified. See the Docs changelog and Desktop Editors changelog when researching your installed version.

For entry, type a leading =, a function name and parentheses. The English function insertion instructions show comma-separated arguments when a function needs more than one. These functions have one required argument; commas become relevant in nested examples, such as IF(...). In File → Advanced Settings, ONLYOFFICE supports selecting a Formula Language and regional number formatting; a localized function name may differ. The regional settings documentation does not establish a universal argument delimiter for every locale, so use the local Function Arguments tooltip instead of assuming English syntax always copies unchanged.

Paste or type the following literal text into A1:A8 of a new, blank worksheet. Ordinary letters, digits, and hyphens are ASCII. ␠ represents one ordinary space to type; do not put the ␠ glyph itself in the sheet.

1. Open a blank workbook in ONLYOFFICE Spreadsheet Editor. Use a worksheet with column A empty.
2. Type the listed examples into A1:A8. Set input cells to Text before entering IDs or strings that your locale might parse as dates or numbers. Keep all formulas in B2:B8, not in the original data cells.
3. Select B2, enter the shown formula, press Enter, and compare the result with the expected output. Copy a formula downward only after checking the references change as intended.
4. To inspect a surprising result, use the formula bar or Formula → Show Formulas. Original values in A remain unchanged.

All expected outputs are independently checked on simple ASCII input strings. They are not screenshots or observed results from ONLYOFFICE.

Enter =LOWER(A2) in B2; expected maple ridge. Use =LOWER(A3) in B3 to change JANE DOE to jane doe. The hyphen, digits and existing lowercase letters in invoice-204b are not letters needing a case change: =LOWER(A4) is expected to return invoice-204b.

The entire result column can be filled by dragging the formula from B2 down to B7. Compare each row against the table above before replacing the sample data with real information. Source column A remains intact.

Literal input: =LOWER("NORTH CAMPUS") is expected to show north campus. Literal text must be enclosed in quotes; entering a bare unquoted name can cause a formula-parse or name-resolution problem.

Type ␠␠CA-ON-1047␠␠ into A8, where each ␠ denotes one normal space, not the symbol itself. Put in B8:

=LOWER(TRIM(A8))

Expected result: ca-on-1047. The chain uses ONLYOFFICE TRIM to remove ordinary spaces at the edges and LOWER to convert the ASCII letters. The expected output was independently checked; verify the nested expression natively before using it in a business workflow.

For an additional prefix-only value, =LOWER(LEFT(A4,7)) is expected to return invoice; LEFT itself has a separate official reference. This leaves the original identifier untouched.

• The output looks unchanged: Some strings already contain lowercase letters only (invoice-204b). Compare the actual input character by character before treating this as a defect.
• Spaces persist: LOWER changes letter case, not surrounding spaces; normal-space trimming is separate and nonbreaking spaces have not been tested here.
• An error appears: Confirm =LOWER(A2) has the equals sign and closing parenthesis. A misspelled function, damaged reference or unquoted literal can produce an error; the exact displayed message varies and was not native-tested.
• Result remains a formula string: Check cell formatting and re-enter with the Insert Function control instead of pasting a literal text representation.
• Accents, non-Latin scripts, Turkish locale distinctions and grapheme clusters: The vendor’s concise reference does not document an exhaustive Unicode case map; these require real tests by product version. The examples deliberately use plain ASCII letters.

Microsoft Excel documents the same LOWER(text) name and argument. The English-language syntax is therefore portable at the naming level. Results for international case rules, automatic import coercion and locale settings are not asserted identical without side-by-side testing. Do not infer availability from a different software’s implementation.

• Existing ONLYOFFICE FILTER guide

• Existing ONLYOFFICE COUNTIF guide: count categories after standardizing source values in a helper column; check that workbook’s matching logic separately.

• Official ONLYOFFICE LOWER guide — source of this page’s purpose and exact syntax.

• ONLYOFFICE Spreadsheet Editor — function documentation
• current English ONLYOFFICE Spreadsheet Editor function catalogue
• Docs changelog
• Desktop Editors changelog
• regional settings documentation
• ONLYOFFICE TRIM
• separate official reference

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.