Spreadsheet XLSX Ghost Cells Cleaner – Light (Gratuit)
by ezway technology https://ezway-technology.com| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Documents (documents)
• Discuss (mail) |
| Lines of code | 402 |
| Technical Name |
addon_custom_spreadsheet_light |
| License | LGPL-3 |
| Website | https://ezway-technology.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Documents (documents)
• Discuss (mail) |
| Lines of code | 402 |
| Technical Name |
addon_custom_spreadsheet_light |
| License | LGPL-3 |
| Website | https://ezway-technology.com |
Light Edition – Limited functionality
This free version lets you clean .xlsx files one at a time (max 5 MB, 10 cleanings/day).
For automatic cleaning on open, files up to 20 MB, and unlimited cleanings,
discover the full version.
The Problem: Ghost Cells
When you apply formatting to an entire column or row in Excel (e.g. make column A bold, paint a whole row yellow), Excel silently generates millions of "ghost cells" — empty cells that carry only a style attribute and no data. These cells are invisible in Excel, but when Odoo parses the XLSX file's XML, the browser runs out of memory trying to render them all.
.xlsx file in Odoo Spreadsheet.
Features – Light Version (Free)
Manual cleaningOpen a |
JavaScript fallbackA browser-side patch acts as a safety net, cleaning ghost cells before the spreadsheet engine processes them. |
Non-destructiveThe original file is only updated after your explicit action. No real data is ever deleted. |
Automatic cleaningFull version only. Every file is cleaned on-the-fly before being sent to the browser — no user action needed. |
Batch processingFull version only. Select multiple files in list view and clean them all in a single operation. |
Files > 5 MBFull version only. Process files up to 20 MB with maximum compression (level 9). |
Version Comparison
| Feature | Light (Free) | Full version |
|---|---|---|
| Manual cleaning (action button in Documents) | Yes | Yes |
| JavaScript fallback (browser-side) | Yes | Yes |
| Automatic cleaning on file open | No | Yes |
| Maximum file size | 5 MB | 20 MB |
| Daily cleanings | 10 / day | Unlimited |
| Batch processing (multi-file selection) | No | Yes |
| Odoo Spreadsheet files (JSON format) | No | Yes |
| Compression level | Standard (6) | Maximum (9) |
| Price | Free | See ezway-technology.com |
Performance
| Metric | Before cleaning | After cleaning |
|---|---|---|
| File size | 25 MB | 250 KB (−99%) |
| Cells parsed by the browser | ~500,000 | ~5,000 |
| Result | Browser crash | Opens in 2 seconds |
Installation
|
1
|
Make sure the Documents and Spreadsheet modules are installed. |
|
2
|
Copy the addon_custom_spreadsheet_light folder into your Odoo addons directory. |
|
3
|
In Odoo: Apps → Update List → Search "Ghost Cells Cleaner Light" → Install. |
|
4
|
If needed: Settings → Technical → Regenerate Assets. |
How to Use
|
1
|
Go to the Documents module. |
|
2
|
Open a .xlsx file record. |
|
3
|
Click Action → Clean XLSX – Light Version. |
|
4
|
A notification confirms the size reduction (e.g. "850 KB → 12 KB (−98.6%)"). |
What Is Removed — and What Is Kept
Removed: only cells and rows with no data
- Self-closing styled cells:
<c r="A1" s="1"/> - Empty cell nodes:
<c r="A1" s="1"></c> - Empty rows:
<row r="5"></row>
Preserved: all cells that contain data
- Values:
<v> - Formulas:
<f> - Inline text:
<is>
Need more? Upgrade to the full version.
Automatic and transparent cleaning on every open ·
Files up to 20 MB ·
Unlimited cleanings ·
Batch processing ·
Odoo Spreadsheet (JSON) support ·
Maximum compression.
Discover the full version →
Please log in to comment on this module