ROT13 Function (OpenOffice Calc)

The Apache OpenOffice Calc ROT13 function transforms a text string by rotating letters 13 places through the alphabet. Apply the same function to the result to get the original letters back. Apache’s 4.1 Calc Guide explicitly lists ROT13(text) in its Text Functions section. [AO1]

=ROT13("Hello, world!")

Expected: Uryyb, jbeyq! . ROT13 is suitable for simple reversible obfuscation, such as hiding puzzle answers from casual view. It is not secure encryption and should never be used to conceal passwords, customer records, confidential information, or other secrets.

Apache OpenOffice 4.1 specifies: [AO1]

ROT13(text)

In a worksheet, begin the formula with =:

=ROT13(A2)
=ROT13("OpenOffice Calc")

• text — required: the text string to transform, either a quoted text literal such as "Hello" or a cell reference containing text. The documented function has one argument, without optional arguments or defaults. [AO1]
• Output: text produced by substituting letters at positions 13 away in the alphabet. The transformation can be applied twice to reverse it. [AO1]
• Case, punctuation, numerals: the examples in this guide use the familiar ASCII Latin A–Z/a–z ROT13 mapping; independently computed expectations leave spaces, digits and punctuation in place. Apache’s short table description does not enumerate every Unicode or locale edge case, so do not infer tested outcomes for accented letters, non-Latin writing systems or unusual input types. [AO1]
• Locale: with a single argument, ROT13(text) needs no argument separator. For combined examples containing other functions, Apache’s documented default is a semicolon between parameters; local application formula-language settings should be confirmed in the Function Wizard. [AO2]
• Version/platform: the syntax is stated in the Apache OpenOffice 4.1 Calc Guide. Apache’s public release page lists 4.1.16 on the evidence access date; there is no native execution verification on Windows, Linux or macOS, and there is no guarantee of identical behaviour in every version or locale. [AO1, AO3]

How the rotation works

For basic Latin alphabet letters, ROT13 replaces A with N, B with O, and so on until M becomes Z; then N becomes A, through Z becoming M. The lowercase letters rotate in the same way. This is why using ROT13 twice restores the original for this alphabet: 13 + 13 = 26, one complete cycle. [AO1]

1. Open a blank Calc sheet. Type Input in A1, Encoded in B1, and Decoded in C1.
2. Enter the exact literal text from the A column below into cells A2:A8. These are strings, not formulas.
3. Type =ROT13(A2) in B2 and fill down through B8.
4. Type =ROT13(B2) in C2 and fill down through C8.
5. Compare the on-screen results with the independently computed expectations below. Do not treat the table as a record of an application test. [AO1]

Validation level: all values were independently generated using a simple standard ROT13 transformation and double-checked for reversibility; no outputs were observed in OpenOffice itself. Uppercase/lowercase distinctions and unchanged punctuation follow the basic Latin alphabet algorithm; exact application-level exceptions remain subject to native testing.

One-cell decoding

You do not need a separate special decode function:

=ROT13("Uryyb, jbeyq!")

Expected: Hello, world!. The same formula works in reverse because the offset is exactly half of the 26-letter basic Latin alphabet. For a worksheet that contains the obfuscated string in B2, enter =ROT13(B2) to display the decoded form. [AO1]

Audit a reversible classroom message

Suppose A2 contains Secret note: Q4. Enter:

=ROT13(ROT13(A2))

Expected: Secret note: Q4 . This nested call is a convenient sanity check for ordinary Latin-letter text. It does not verify data confidentiality, protect the worksheet, or prove the input is valid. You can compare the original and decoded cells directly rather than adding an unverified cross-application encoding function.

Check that a row can be restored

For the ordinary ASCII example in A2, this comparison is a reasonable editorial test candidate:

=EXACT(A2;ROT13(ROT13(A2)))

Expected: TRUE for Hello, world! . The separately documented Apache EXACT(text_1; text_2) compares text for equality and is case-sensitive. This combined formula has not been executed natively in this run. If it returns FALSE, check the original source string, any Unicode characters, imported text normalization, and whether the nested ROT13 function is recognized. [AO1, AO2, AO4]

Prepare a shareable puzzle without exposing the answer immediately

Keep the answer in column A and display its ROT13 version in B. For example Alpha Beta becomes expected Nycun Orgn . Share the encoded cell value, not the original hidden worksheet column. A hidden column is not security, and recipients can reverse ROT13 immediately. If actual privacy matters, use a suitable encryption or access-control mechanism outside ROT13.

Limits not claimed: The retrieved Apache documentation does not specify a tested maximum input length, precise blank-cell coercion, all invalid argument error codes, or behaviour for non-Latin scripts. This guide deliberately does not invent those details or promise that other applications reproduce them. [AO1]

Apache OpenOffice Calc: ROT13 is explicitly listed in the Apache OpenOffice 4.1 Calc Guide with ROT13(text). That documentation supports the function’s documented purpose and syntax; native 4.1.16 execution is still outstanding. [AO1, AO3]

LibreOffice Calc: Its help also documents a function named ROT13. This establishes a similarly named function in LibreOffice, not authoritative proof that its implementation, encoding, localization, import/export or error handling matches Apache OpenOffice. [COMP1]

Microsoft Excel, Google Sheets and other spreadsheets: Do not assume =ROT13(...) is portable or built in merely because a file opens. Verify the destination’s actual function catalogue and formula import behaviour. When exchanging plain text, transmitting the already-encoded result is different from transmitting an unevaluated OpenOffice formula; the former avoids a dependency on function recognition.

Those are useful adjacent topics—counting characters, comparing strings, replacing text and changing letter case—but none is a substitute for ROT13.

Official Apache references (accessed 2026-10-11)

• AO1 — Apache OpenOffice 4.1 Calc Guide, Text Functions, Table 46 (ROT13 syntax and double-rotation behaviour).
• AO2 — Apache OpenOffice 4.1 Calc Guide, understanding function syntax and semicolon argument separators.
• AO3 — Apache OpenOffice official download page (release displayed at access).
• AO4 — Apache OpenOffice’s EXACT documentation (cross-check the formula in a native Calc session).

Verification status: Official OpenOffice 4.1 documentation checked; sample outcomes independently calculated for the standard Latin-letter mapping. Not executed in Apache OpenOffice Calc. No genuine Calc screenshots are included. This guide does not use mock application images.

Additional official reference: Apache OpenOffice 4.1 Calc Guide, function reference.

The examples show expected results checked against Apache OpenOffice documentation and independent arithmetic, text mapping, or logical reasoning. They were not run in Apache OpenOffice Calc. Platform, locale, import, and unusual error cases are not certified.