Quarantine Spreadsheet Formulas
Easy About 15 min Katabench Pro
Keep untrusted export cells from becoming spreadsheet commands, including whitespace and full-width prefixes.
The full brief is part of Katabench Pro
Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Comment Renderer (HTML Injection), which is free.
How it is graded
Functional tests and adversarial payloads both have to pass before the solution is accepted.
What it practices
- Output encoding (XSS and formula injection)
- Encode or neutralize untrusted text for the context it lands in, such as HTML or spreadsheet cells.
Related katas
- Comment Renderer (HTML Injection) Easy Free Fix a stored-XSS hole in a comment renderer without breaking its output.
- Filename Sanitizer Easy Free Reduce an uploaded filename to a safe, single path segment.
- Log Forging (CRLF) Easy Free Stop user input from forging extra log lines with embedded newlines.
- Mass Assignment Guard Easy Free Decide which submitted fields may be applied to a record using an allowlist, not a blocklist.