"Unsupported value type" in ODS #546

New Issue

2017-01-30T08:33:45Z

lgodard commented

2017-01-30 08:33:45 +00:00

(Migrated from github.com)

Hi,

Thanks a lot for your tool that seems very promising after first tests on heavy files

btw,
on a large production ODS file, i encounter error messages like this in ods.js:277

     Error: Unsupported value type error
{"t":"error","v":null}

     Error: Unsupported value type undefined
{"v":null}

It seems that the undefined one is related to issue #148 (but the proposed patch is not integrated in my xlsx 0.8.1 version)

I tried the following, and no more error (but can't say it solves the underlying problem)

                        case 'error': q.t='error';break;
                        case undefined: q.t='undefined';break;
                        default: throw new Error('Unsupported value type ' + q.t)

The same file transformed as xlsx works without error

Is there anything that can be done to solve this issue ? feel free to ask if more detail needed

Thanks a lot again for your great work

Laurent

Hi, Thanks a lot for your tool that seems very promising after first tests on heavy files btw, on a large production ODS file, i encounter error messages like this in ods.js:277 ``` Error: Unsupported value type error {"t":"error","v":null} Error: Unsupported value type undefined {"v":null} ``` It seems that the `undefined` one is related to issue #148 (but the proposed patch is not integrated in my xlsx 0.8.1 version) I tried the following, and no more error (but can't say it solves the underlying problem) ``` case 'error': q.t='error';break; case undefined: q.t='undefined';break; default: throw new Error('Unsupported value type ' + q.t) ``` The same file transformed as xlsx works without error Is there anything that can be done to solve this issue ? feel free to ask if more detail needed Thanks a lot again for your great work Laurent

lgodard commented

2017-01-30 14:29:46 +00:00

(Migrated from github.com)

here are some precision, regarding the offending xml statements (Rn content)

     Error: Unsupported value type error
{"t":"error","v":null}
<table:table-cell table:style-name="ce56" table:formula="of:=code_:pj" office:value-type="string" office:string-value="" calcext:value-type="error">,,table:,table-cell

note here the 2 value-type tags : office:value-type & calcext:value-type

 Error: Unsupported value type undefined
{"v":null}
<table:table-cell table:style-name="ce161" table:formula="of:=IF([.$AG$54]=0;&quot;&quot;;[.G52]/[.$AG$54]*100)">,,table:,table-cell

here are some precision, regarding the offending xml statements (Rn content) ``` Error: Unsupported value type error {"t":"error","v":null} <table:table-cell table:style-name="ce56" table:formula="of:=code_:pj" office:value-type="string" office:string-value="" calcext:value-type="error">,,table:,table-cell note here the 2 value-type tags : office:value-type & calcext:value-type ``` ``` Error: Unsupported value type undefined {"v":null} <table:table-cell table:style-name="ce161" table:formula="of:=IF([.$AG$54]=0;"";[.G52]/[.$AG$54]*100)">,,table:,table-cell ```

lgodard commented

2017-02-04 06:22:49 +00:00

(Migrated from github.com)

Hi,
Thanks a lot for the resolution
I confirm the second case undefined is solved
the first error remains, see #548
Thanks again for xlsx geat library
Laurent

Hi, Thanks a lot for the resolution I confirm the second case `undefined` is solved the first `error` remains, see #548 Thanks again for xlsx geat library Laurent

Sign in to join this conversation.