Long text (sentences) in single cell throws AssertionError about sheetjs

[redchair123]

There are quite a few things that trigger that error, including strings using special codepages and strings that cross a block. I'll look into it after pushing some codepage changes (the holdup right now is the fact that https://github.com/Niggler/js-codepage/blob/master/cptable.js is 1.6MB )

[mnmly]

Thanks for the quick reply and your plan sounds cool!

But just fyi, the excel that has the problem is not using any special characters (I hope), I replaced every letter into * in order to narrow the cause into the one with larger text length :)

it would be great if you can reference this issue when you push the codepage change! So I can take a look as well!

Thanks 👍

[redchair123]

I've been staring at this for a while, and I'm torn as to what is the right behavior:

The actual data representation implies that there are a few characters with unicode 0x2019 (which is rendered as ’) but for whatever reason Excel mangles that character, rendering Õ instead of the apostrophe. Which one did you intend to use (for example, character 2 of line 4)?

[mnmly]

Hmm, I tried this now and the file I put in the zip: demo-doesnt-work.xls does work now...
Probably my bad… let me close this for now. Sorry for troubles.

Also experiencing this issue. After trial and error narrowed it down to one cell which said "Question 5 : Dizziness" on the first row and last column, and resolved it simply by retyping it and saving. Undo and resave recaused the issue.

The file is proprietary so can't post it publicly. Strangely, deleting the first column to sanitize the dataset also made the problem disappear. Wonder if it's an issue with marking end of row? May be able to share the file privately for debugging.

buffer.js:579
    throw new RangeError('Trying to access beyond buffer length');
    ^
RangeError: Trying to access beyond buffer length
    at checkOffset (buffer.js:579:11)
    at Buffer.readUInt16LE (buffer.js:606:5)
    at Buffer.ReadShift (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:131:26)
    at parse_XLUnicodeRichExtendedString (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:1045:12)
    at Object.parse_SST [as f] (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:1214:13)
    at slurp (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4046:11)
    at parse_workbook (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4099:15)
    at parse_xlscfb (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4389:26)
    at Object.readFile (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4499:37)
    at /Users/me/projects/myproject/util/modules/MedLiveUtil.js:31:26
    at fs.js:266:14

[redchair123]

@gradualstudent Shoot me an email (use git log to get my address)

On Thu, Jul 18, 2013 at 8:40 AM, gradualstudent [email protected]:

Also experiencing this issue. After trial and error narrowed it down to
one cell which said "Question 5 : Dizziness" on the first row and last
column, and resolved it simply by retyping it and saving. Undo and resave
recaused the issue.

The file is proprietary so can't post it publicly. Strangely, deleting the
first column to sanitize the dataset also made the problem disappear.
Wonder if it's an issue with marking end of row? May be able to share the
file privately for debugging.

buffer.js:579
throw new RangeError('Trying to access beyond buffer length');
^
RangeError: Trying to access beyond buffer length
at checkOffset (buffer.js:579:11)
at Buffer.readUInt16LE (buffer.js:606:5)
at Buffer.ReadShift (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:131:26)
at parse_XLUnicodeRichExtendedString (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:1045:12)
at Object.parse_SST as f
at slurp (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4046:11)
at parse_workbook (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4099:15)
at parse_xlscfb (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4389:26)
at Object.readFile (/Users/me/projects/myproject/node_modules/xlsjs/xls.js:4499:37)
at /Users/me/projects/myproject/util/modules/MedLiveUtil.js:31:26
at fs.js:266:14

—
Reply to this email directly or view it on GitHubhttps://github.com/Niggler/js-xls/issues/12#issuecomment-21192521
.

[redchair123]

@gradualstudent the most recent commits appear to resolve the issue. Please create a new issue if it still persists