mirror of
https://github.com/jmcnamara/libxlsxwriter.git
synced 2026-05-15 14:15:54 -06:00
[GH-ISSUE #193] Exceeding Limit on URLs #158
Labels
No labels
awaiting user feedback
bug
cmake
cmake
docs
feature request
in progress
long term
medium term
medium term
pull-request
question
question
ready to close
short term
under investigation
wontfix
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/libxlsxwriter#158
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @iamtheschmitzer on GitHub (Aug 24, 2018).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/193
Originally assigned to: @jmcnamara on GitHub.
I am exceeding the limit on URLs. I can see where this is enforced, but suprisingly, I cannot find an actual fixed-size array of URLs. Instead it appears URLs are inserted into the list of cells.
Does anyone know why the number of URLs is constrained, or where that array is?
@jmcnamara commented on GitHub (Aug 24, 2018):
The number of unique, non-contiguous, URLs is constrained by Excel to 65,530 per worksheet.
This is an Excel limitation. After that it doesn't accept any more URLs. It just inserts them as strings with formatting but they don't have links.
Excel supports an optimization for non-unique contiguous URLs, i.e., in adjoining cells but that isn't supported by libxlsxwriter.
@iamtheschmitzer commented on GitHub (Aug 24, 2018):
Okay, thanks