New properties in cell object #782

Closed
opened 2017-08-17 10:59:37 +00:00 by the-spyke · 0 comments
the-spyke commented 2017-08-17 10:59:37 +00:00 (Migrated from github.com)

After updating to 0.11.2 I saw new properties in cell objects on xls import.

        "C7": {
            "ixfe": 15,
            "XF": {
                "ifnt": 0,
                "numFmtId": 164,
                "flags": 1,
                "fStyle": 0,
                "data": {
                    "patternType": null
                }
            },
            "v": 20120101,
            "t": "n"
        },
        "D7": {
            "v": "store-1",
            "ixfe": 15,
            "t": "s",
            "XF": {
                "ifnt": 0,
                "numFmtId": 164,
                "flags": 1,
                "fStyle": 0,
                "data": {
                    "patternType": null
                }
            }
        },

Is this okay? I don't see ixfe or XF in Common Spreadsheet Format.

Also opening this file in Excel 2016 shows all cells in General format. And I'm parsing it with raw flag set to true. But 20120101 is parsed an a number. What differs from csv behavior (see #781).

After updating to `0.11.2` I saw new properties in cell objects on `xls` import. ``` "C7": { "ixfe": 15, "XF": { "ifnt": 0, "numFmtId": 164, "flags": 1, "fStyle": 0, "data": { "patternType": null } }, "v": 20120101, "t": "n" }, "D7": { "v": "store-1", "ixfe": 15, "t": "s", "XF": { "ifnt": 0, "numFmtId": 164, "flags": 1, "fStyle": 0, "data": { "patternType": null } } }, ``` Is this okay? I don't see `ixfe` or `XF` in Common Spreadsheet Format. Also opening this file in Excel 2016 shows all cells in `General` format. And I'm parsing it with `raw` flag set to `true`. But `20120101` is parsed an a number. What differs from `csv` behavior (see #781).
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#782
No description provided.