表格导出后在WPS打开显示错乱

收藏

正常显示的：

导出后显示异常：

{
      version: "14.0.7",
      customList: [],
      sheets: {
         Sheet1: {
            name: "Sheet1",
            isSelected: true,
            activeRow: 6,
            activeCol: 2,
            theme: "Office",
            data: {
            dataTable: {
               0: { 0: { value: 1 } },
               1: { 0: { value: 2 } },
               3: { 0: { value: 3 } },
               4: { 0: { value: 4 } },
               6: { 0: { value: 5 } },
               7: { 0: { value: 6 } },
            },
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            rowHeaderData: {
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            colHeaderData: {
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            leftCellIndex: 0,
            topCellIndex: 0,
            selections: {
            0: { row: 6, rowCount: 1, col: 2, colCount: 1 },
            length: 1,
            },
            rowOutlines: { items: [] },
            columnOutlines: { items: [] },
            cellStates: {},
            outlineColumnOptions: {},
            autoMergeRangeInfos: [],
            printInfo: { paperSize: { width: 850, height: 1100, kind: 1 } },
            index: 0,
         },
      },
      pivotCaches: {},
      }

Derrick.Jiao · Derrick.Jiao

您好，麻烦您提供一份能复现问题的ssjson这边调研一下

yfy · yfy

DerrickJiao 发表于 2021-2-23 08:45
您好，麻烦您提供一份能复现问题的ssjson这边调研一下

{
      version: "14.0.7",
      customList: [],
      sheets: {
         Sheet1: {
            name: "Sheet1",
            isSelected: true,
            activeRow: 6,
            activeCol: 2,
            theme: "Office",
            data: {
            dataTable: {
               0: { 0: { value: 1 } },
               1: { 0: { value: 2 } },
               3: { 0: { value: 3 } },
               4: { 0: { value: 4 } },
               6: { 0: { value: 5 } },
               7: { 0: { value: 6 } },
            },
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            rowHeaderData: {
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            colHeaderData: {
            defaultDataNode: { style: { themeFont: "Body" } },
            },
            leftCellIndex: 0,
            topCellIndex: 0,
            selections: {
            0: { row: 6, rowCount: 1, col: 2, colCount: 1 },
            length: 1,
            },
            rowOutlines: { items: [] },
            columnOutlines: { items: [] },
            cellStates: {},
            outlineColumnOptions: {},
            autoMergeRangeInfos: [],
            printInfo: { paperSize: { width: 850, height: 1100, kind: 1 } },
            index: 0,
         },
      },
      pivotCaches: {},
      }