search

protobi / js-xlsx

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

Two artefacts with resulting spreadsheet #68

Open xaviermarichal opened 7 years ago

xaviermarichal commented 7 years ago

We use this great library to generate XLSX export out of our online application. But we encounter two artefacts in the resulting files:

  1. (major) it is impossible to copy from that file, and paste into another Excel file (copy-pasting inside the file itself works fine though). Here is the message we systematically get (here when trying to paste in my blank file cell A1 from the file generated with the library): https://www.dropbox.com/s/xkmfv5ht6kmugim/Screenshot%202017-04-20%2012.12.07.png?dl=0

  2. (minor) Excel crashes when trying to print that file, on some old version of Excel (typically Windows - version 2010)

In both cases, doing a "Save as" of the file solves the issue. I send a test file right away by email.

File is attached (I'll also send by email): Conformity of Production Site of Carrefour Products_Coopérative de Grastine (Germany)_2014.xlsx

Thanks for any hint as to how to solve that. Xavier

pietersv commented 7 years ago

@xaviermarichal Thanks for reporting. Can confirm issue #1 with the attached file but don't see the issue on other workbooks we generate. I suspect it may be a specific aspect of your JS object which specifies the spreadsheet content that triggers a bug in the library.

If urgent, we can offer professional support. Email support@protobi.com, we can diagnose and resolve. Include the JS object you pass to XLSX. I think this would be modest, under a day.

SheetJSDev commented 7 years ago

@xaviermarichal looks like https://github.com/protobi/js-xlsx/issues/26 -- did you update your version?

xaviermarichal commented 7 years ago

Thanks, this is indeed the same symptom, so probably the same bug. We'll investigate and then I'll let you know.

On Thu, Apr 20, 2017 at 5:30 PM, SheetJSDev notifications@github.com wrote:

@xaviermarichal https://github.com/xaviermarichal looks like #26 https://github.com/protobi/js-xlsx/issues/26 -- did you update your version?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/protobi/js-xlsx/issues/68#issuecomment-295780293, or mute the thread https://github.com/notifications/unsubscribe-auth/AHiT2NXZYLhv3Tsea8OuBHLgmHs5Hd4Mks5rx3oJgaJpZM4NC08g .