Some xlsx files produce html entities while others are backslash escaped about sheetjs HOT 4 CLOSED

Come to think of it, I'm not totally sure how the spreadsheet with entities was last edited, but I think it was most likely through google docs.

from sheetjs.

I'll dig further into the sheets in an hour, but http://i.imgur.com/x6pWDyj.jpg is what I see when i open both files in excel 2011. Both have F2 selected. Which one do you think is right?

from sheetjs.

@nathanathan I'll look into the issue in the screenshot later, but I pushed an update that added the missing xml entities (that should resolve the " issue).

from sheetjs.

Sorry, I forgot I quoted that cell when I was experimenting with it. I
don't think the quotes make a difference with the escaping issue.
Thanks for the quick fix!

By the way, phpjs has some entity decoding code that might be useful here:
https://github.com/kvz/phpjs/blob/master/functions/strings/html_entity_decode.js

On Wed, Mar 20, 2013 at 2:34 PM, Niggler [email protected] wrote:

@nathanathan https://github.com/nathanathan I'll look into the issue in
the screenshot later, but I pushed an update that added the missing xml
entities (that should resolve the " issue).

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/14#issuecomment-15205077
.

from sheetjs.