• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

xlnt-community / xlnt / cf1f6fae-1063-4a10-a278-1f29eaceceaa / 1
84%
master: 84%

Build:
DEFAULT BRANCH: master
Ran 07 Jul 2025 07:05PM UTC
Files 112
Run time 9s
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

07 Jul 2025 07:01PM UTC coverage: 82.046% (+0.1%) from 81.942%
cf1f6fae-1063-4a10-a278-1f29eaceceaa.1

push

circleci

web-flow
Support whole column/row references and #REF! in definedName (#91)

# Problem Description
xlnt was throwing "bad cell coordinates" exceptions when parsing Excel
files containing `definedName` entries with:
- Whole column references (e.g., `$A:$I`) 
- Excel error values (e.g., `#REF!`)

This prevented loading of valid Excel files that work fine in Excel/WPS
Office.

# Solution Overview
This PR adds comprehensive support for:

1. **Whole Column References**: `A:C`, `$A:$C` → internally converted to
`A1:C1048576`
2. **Whole Row References**: `1:5`, `$1:$5` → internally converted to
`A1:XFD5`
3. **Excel Error Value**: `#REF!` → skip those references

Closes #90

Co-authored-by: m7913d <m7913d@my-dreams.be>

14175 of 18729 branches covered (75.68%)

11598 of 14136 relevant lines covered (82.05%)

10773.41 hits per line

Source Files on job cf1f6fae-1063-4a10-a278-1f29eaceceaa.1
  • Tree
  • List 112
  • Changed 5
  • Source Changed 4
  • Coverage Changed 4
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Build 0
  • 2de12e0b on github
  • Prev Job for on master (#c8692d7d-b719-4b68-ae8c-2a338681201b.1)
  • Next Job for on master (#f462fa4d-f663-4985-891c-c54d1e7a4500.1)
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc