mfolk
commented
9 years ago Yuck. When we ran into this problem before, the workaround was to spread the text across multiple objects. In the Excel case it would mean spreading it among several cells.
It’s an ugly solution, but I think fine for version 1, and perhaps even for later versions.
Another solution, or perhaps this could be an option on a later version, would be to open an independent text window to hold it. That only works for text, but I suspect it’ll be mainly a text issue.
For version 1, I don’t think it’s critical. It could even report that the text doesn’t fit and just show the first 32K characters.
Mike
From: Gerd Heber [mailto:notifications@github.com] Sent: Wednesday, November 19, 2014 8:44 AM To: HDFGroup/PyHexad Subject: [PyHexad] Total number of characters that a cell can contain (#29)
Excel supports up to 32,767 characters in a cell. This is a potential issue, for example, with the HDFEOS metadata under '/HDFEOS INFORMATION', which gets truncated.
— Reply to this email directly or view it on GitHubhttps://github.com/HDFGroup/PyHexad/issues/29.
Excel supports up to 32,767 characters in a cell. This is a potential issue, for example, with the HDFEOS metadata under '/HDFEOS INFORMATION', which gets truncated.