Incorrect handling of table:number-columns-repeated in ODS #177

New Issue

2015-02-20T11:25:55Z

ziacik commented

2015-02-20 11:25:55 +00:00

(Migrated from github.com)

Hi. I think there may be incorrect handling of number-columns-repeated attribute in ODS files.

If I have a table where two adjacent cells have the same value, the second will not be present in Sheet object.

For example, having an ODS with A1 cell set to "A" and B1 cell set to "A" too,

console.log(require('xlsx').readFile('./Test.ods').Sheets.Sheet1);

outputs this:

{ A1: { t: 's', v: 'A', w: 'A' }, '!ref': 'A1' }

So B1 is missing there.

Version I tried this on is 0.7.12.

Hi. I think there may be incorrect handling of number-columns-repeated attribute in ODS files. If I have a table where two adjacent cells have the same value, the second will not be present in Sheet object. For example, having an ODS with `A1` cell set to "A" and `B1` cell set to "A" too, `console.log(require('xlsx').readFile('./Test.ods').Sheets.Sheet1);` outputs this: `{ A1: { t: 's', v: 'A', w: 'A' }, '!ref': 'A1' }` So B1 is missing there. Version I tried this on is 0.7.12.

SheetJSDev commented

2015-02-20 18:37:01 +00:00

(Migrated from github.com)

@ziacik do you have a sample file so I can take a look?

ziacik commented

2015-02-20 21:46:25 +00:00

(Migrated from github.com)

@SheetJSDev Sample file is at this link http://www.koliksoftware.net/Stuff/Test.ods