Bug att xlsx.read #938

Closed
opened 2018-01-03 09:38:58 +00:00 by ghost · 3 comments
ghost commented 2018-01-03 09:38:58 +00:00 (Migrated from github.com)

ERROR TypeError: Cannot read property 't' of undefined
at parse_workbook (xlsx.js:15493)
at parse_xlscfb (xlsx.js:15924)
at read_cfb (xlsx.js:18822)
at Object.readSync [as read] (xlsx.js:18889)

Fixed it by checking t first.

// if (sst[val.isst] && sst[val.isst].t) {	
	temp_val=make_cell(sst[val.isst].t, val.ixfe, 's');
	temp_val.XF = XFs[temp_val.ixfe];
	if(BIFF2Fmt > 0) temp_val.z = BIFF2FmtTable[(temp_val.ixfe>>8) & 0x1F];
	safe_format_xf(temp_val, options, wb.opts.Date1904);
	addcell({c:val.c, r:val.r}, temp_val, options);
// }
ERROR TypeError: Cannot read property 't' of undefined at parse_workbook (xlsx.js:15493) at parse_xlscfb (xlsx.js:15924) at read_cfb (xlsx.js:18822) at Object.readSync [as read] (xlsx.js:18889) Fixed it by checking t first. ``` // if (sst[val.isst] && sst[val.isst].t) { temp_val=make_cell(sst[val.isst].t, val.ixfe, 's'); temp_val.XF = XFs[temp_val.ixfe]; if(BIFF2Fmt > 0) temp_val.z = BIFF2FmtTable[(temp_val.ixfe>>8) & 0x1F]; safe_format_xf(temp_val, options, wb.opts.Date1904); addcell({c:val.c, r:val.r}, temp_val, options); // } ```
SheetJSDev commented 2018-01-03 14:37:04 +00:00 (Migrated from github.com)

Can you share a file that triggers this error?

Can you share a file that triggers this error?
ghost commented 2018-01-03 14:48:13 +00:00 (Migrated from github.com)

Where can i send them? xls is unsupported.

Where can i send them? xls is unsupported.
SheetJSDev commented 2018-01-03 14:49:29 +00:00 (Migrated from github.com)

Attach in an email to hello@sheetjs.com

Attach in an email to hello@sheetjs.com
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#938
No description provided.