ROT13 in Collabora Office: Transform Latin Text and Verify the Round Trip
Use Collabora ROT13 for reversible Latin-letter transformations, preserve punctuation and digits, and recognize that the result offers no confidentiality.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =ROT13("Hello, Calc 123!") has independently expected result “Uryyb, Pnyp 123!”. Applying ROT13 again returns the original text.
Syntax and transformation
=ROT13(Text)
Text is the one required string or cell reference. The documented operation moves letters thirteen positions through the alphabet, wrapping after Z. The reference’s example explicitly leaves spaces, digits and full stops unchanged.
For the ASCII Latin examples here, A becomes N, B becomes O, N becomes A, and corresponding lowercase letters follow the same rotation. Case remains recognizable. This guide does not infer arbitrary non-Latin or Unicode behavior from those examples.
Although the official help uses the word encryption, ROT13 is a public, fixed substitution with no secret key. Anyone can reverse it. It provides no confidentiality, password protection or protection for sensitive information.
Example 1: encode and reverse a phrase
Put the text Hello, Calc 123! in A2. In B2 enter =ROT13(A2). The independent target is Uryyb, Pnyp 123!. In C2 enter =ROT13(B2); the target is the original phrase.
In D2 use =EXACT(A2;C2) for a case-sensitive round-trip check. The independent target is TRUE. The punctuation, space and digits remain in place throughout the example.
A matching round trip verifies the chosen reversible transformation for that input. It does not establish that the text was hidden from anyone while transformed.
Example 2: inspect the alphabet mapping
Enter ABCDEFGHIJKLMNOPQRSTUVWXYZ in A5 and use =ROT13(A5) in B5. The expected result is NOPQRSTUVWXYZABCDEFGHIJKLM. Repeating with the lowercase alphabet gives nopqrstuvwxyzabcdefghijklm.
The rotation shifts by half the 26-letter alphabet. Applying it twice shifts by 26, returning each letter to its original position. This explains the inverse property without relying solely on a second function call.
For A1-Z9, the expected transformed text is N1-M9. The digits and hyphen do not move or become substitute letters.
Advanced application: prepare optional spoiler text
For a puzzle answer or non-sensitive spoiler, place the original in A10 and its transformed version in B10. Keep a visible instruction that applying ROT13 reverses it. This can discourage accidental reading without pretending to prevent deliberate access.
If the source is a formula, reference its resulting text. Preserve the original cell so the transformation is auditable. Do not overwrite original identifiers or assume the transformed strings remain suitable keys in another system.
Advanced application: audit a list of transformations
Enter several ASCII test strings in A12:A15: abc, XYZ, 12345, and an empty text result from ="". Fill =ROT13(A12) down in B12:B15. Expected outputs are nop, KLM, 12345, and empty text.
Fill a reverse-transformation column beside them and compare with EXACT. Also compare LEN before and after for these ASCII controls: lengths are preserved. That observation is bounded to the stated examples, not a universal promise about every script or encoding.
A transformed empty-string result is still a formula result. It does not make the destination cell genuinely blank, so ISBLANK and LEN=0 ask different questions.
Errors and troubleshooting
If numbers or punctuation appear unchanged, that is expected for these examples. If output looks like a different language, check whether it is simply the letter substitution awaiting a second application.
Use actual text when exact leading zeros or formatting matter. Numeric cells converted to text may not preserve a custom display format; construct the desired string explicitly before applying ROT13.
The dedicated documentation does not establish all invalid-input errors, non-Latin mappings or native encoding boundaries. No target-application execution occurred here. Never use this operation as a substitute for genuine encryption or access controls.
Availability, format and verification
Collabora Office 26.04 desktop help documents this exact function. The saved source was retrieved on 2026-10-13 and hash-verified for this guide on October 15, 2026. It identifies the namespace ORG.OPENOFFICE.ROT13 and says the function is outside the cited OpenFormula 1.3 standard. This is not cross-product semantic certification.
The first introduced release and last functioning version are unknown. Online/mobile availability is not inferred. No native Collabora or WPS execution was performed. Results are independent calendar/string controls or explicitly identified documented examples. English names and semicolon separators are used.