CVE-2026-40296: PhpSpreadsheet has XSS via number format code with @ text placeholder bypasses htmlspecialchars in HTML writer
It was discovered that there is a way to bypass HTML escaping in the HTML writer using custom number format codes. The Problem In Writer/Html.php around line 1592, the code checks if the formatted cell data equals the original data to decide whether to apply htmlspecialchars(): When a cell has a custom number format containing @ (text placeholder) with any additional literal characters, the formatter replaces @ with…
Published Apr 28, 2026 · Updated May 8, 2026
Affected packages
phpoffice/phpspreadsheet
- Ecosystem
- Composer (PHP)
- Affected
- >= 4.0.0, <= 5.6.0
- Fixed in
- 5.7.0
- Check
composer show phpoffice/phpspreadsheet
phpoffice/phpspreadsheet
- Ecosystem
- Composer (PHP)
- Affected
- >= 3.3.0, <= 3.10.4
- Fixed in
- 3.10.5
- Check
composer show phpoffice/phpspreadsheet
phpoffice/phpspreadsheet
- Ecosystem
- Composer (PHP)
- Affected
- >= 2.2.0, <= 2.4.4
- Fixed in
- 2.4.5
- Check
composer show phpoffice/phpspreadsheet
phpoffice/phpspreadsheet
- Ecosystem
- Composer (PHP)
- Affected
- >= 2.0.0, <= 2.1.15
- Fixed in
- 2.1.16
- Check
composer show phpoffice/phpspreadsheet
phpoffice/phpspreadsheet
- Ecosystem
- Composer (PHP)
- Affected
- <= 1.30.3
- Fixed in
- 1.30.4
- Check
composer show phpoffice/phpspreadsheet
Advisory details
From the GitHub Advisory Database (CC BY 4.0).
It was discovered that there is a way to bypass HTML escaping in the HTML writer using custom number format codes.
The Problem
In Writer/Html.php around line 1592, the code checks if the formatted cell data equals the original data to decide whether to apply htmlspecialchars():
if ($cellData === $origData) {
$cellData = htmlspecialchars($cellData, ...);
}When a cell has a custom number format containing @ (text placeholder) with any additional literal characters, the formatter replaces @ with the cell value and adds the extra characters. This makes $cellData !== $origData, so htmlspecialchars() is skipped entirely.
Even a single trailing space in the format (@ ) is enough to bypass the escape.
Proof of Concept
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Html;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
// XSS payload with malicious number format
$sheet->setCellValueExplicit('A1', '', DataType::TYPE_STRING);
$sheet->getStyle('A1')->getNumberFormat()->setFormatCode('. @');
$writer = new Html($spreadsheet);
$writer->save('output.html');The generated HTML contains:
<td>. </td>The XSS payload is completely unescaped.
Tested Bypass Formats
| Format Code | Result | Escaped? | | `General` (default) | Original value | YES (safe) | | `. @` | `. ` + value | **NO (XSS!)** | | `@ ` (trailing space) | value + ` ` | **NO (XSS!)** | | `x@` | `x` + value | **NO (XSS!)** |
This was tested with PhpSpreadsheet 4.5.0 and confirmed the XSS executes in the browser.
Impact
Any application that:
- Accepts uploaded XLSX files from users
- Converts them to HTML using PhpSpreadsheet's HTML writer
- Displays the HTML to other users
...is vulnerable to stored XSS. The attacker embeds the payload in a cell value and sets a custom number format in the XLSX file's xl/styles.xml.
Suggested Fix
Always apply htmlspecialchars() regardless of whether formatting changed the value:
// Instead of conditional escaping:
$cellData = htmlspecialchars($cellData, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');Or escape AFTER formatting, not conditionally based on equality.
Reporter
Keyvan Hardani
Credited to Keyvanhardani.
References
How this page is made: the data panel comes from the GitHub Advisory Database, CISA’s KEV catalog, the NVD and FIRST EPSS, and updates twice a day. No analysis has been written for this entry yet. Methodology
More Composer (PHP) vulnerabilities
All Composer (PHP) entriesCVE-2026-108357
PhpSpreadsheet: XmlScanner Bypass via Double-Encoded unentity() TOCTOU Allows XXE and Denial of Service
high8.8Oct 27, 2026CVE-2026-108358
PhpSpreadsheet: XmlScanner Bypass via ISO-2022 Escape Sequences Allows XXE and Denial of Service
high8.8Oct 27, 2026CVE-2026-108359
PhpSpreadsheet ODS Reader: Unbounded number-rows-repeated → CPU & Memory Exhaustion (DoS)
high8.7Oct 27, 2026CVE-2026-108360
PhpSpreadsheet: SSRF whitelist bypass via unre-validated HTTP redirect in Drawing::setPath external image loading
medium6.4Oct 27, 2026CVE-2026-59931
PHPSpreadsheet: SSRF bypass via HTTP redirect in WEBSERVICE() domain whitelist
high7.7Jul 23, 2026CVE-2026-59932
PHPSpreadsheet: Gnumeric reader unbounded gzip expansion causes memory exhaustion
high7.5Jul 23, 2026
