protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer
http://oss.sheetjs.com/js-xlsx
Other
826 stars 416 forks source link

not working with OpenDocuments #37

Closed deltreey closed 8 years ago

deltreey commented 8 years ago

I'm getting partial styles back with .ods files but only fill data seems to come in, and it's not wrapped in a fill property, so it doesn't write back to the spreadsheet correctly.

Notably, if I create an xlsx file with LibreOffice, this problem occurs also, but at least some cell sizing is maintained (no idea why). If I try to re-save the file with excel, it does not appear to resolve this issue.

For reference, the object looks like this

{
  "A1": {
    "t": "s",
    "v": " ",
    "r": "<t xml:space=\"preserve\"> <\/t>",
    "h": " ",
    "w": " ",
    "s": {
      "patternType": "solid",
      "fgColor": {
        "rgb": "000000"
      },
      "bgColor": {
        "rgb": "450000"
      }
    }
  },
  "A2": {
    "t": "s",
    "v": "Text without formatting",
    "r": "<t xml:space=\"preserve\">Text without formatting<\/t>",
    "h": "Text without formatting",
    "w": "Text without formatting"
  }
}
deltreey commented 8 years ago

my mistake. I updated to the latest version and everything works fine. It was an issue back in 0.8.0