Obfuscate (ROT13)
Syntax: ROT13(Text)
The ROT13 function encrypts text using a simple algorithm called Caesar’s Code, where each letter is replaced by one of the 13 characters in the Latin alphabet.
Rotating the encoded text by 13 again returns the original string. For example:
=ROT13("OpenOffice.org")
returns BcraBssvpr.bet, while
=ROT13(ROT13("OpenOffice.org")
returns OpenOffice.org.
Figure 11-8. Sample results of the ROT13 function
It is not a very strong form of protecting data, but it is enough to keep it from being accidentally revealed to someone who might be “just looking.”
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
