Skip to content

(Bug) 'Export sheet arrays' + 'Export contents as array' only exports one sheet #141

Description

@Ryuichiro

Describe the bug
'Export sheet arrays' + 'Export contents as array' setting only exports the last sheet even if the export settings enable multiple 'targetSheets'.

To Reproduce
Steps to reproduce the behavior:

  1. Create a 2. Sheet
  2. Set A1 of Sheet1 and Sheet2 to {#SHEET}{#ROW}Id
  3. Set A2 of Sheet1 1 and A2 of Sheet2 to 2
  4. Enable 'Nested Elements' && 'Export sheet arrays' && 'Export contents as array'
  5. Set 'Export Sheets' to All Sheets (or Custom and select both Sheet1 and Sheet2)
  6. Export or Visualize data
  7. Get an array which only contains the item from Sheet2.

Expected behavior
Considering that exporting multiple files at a time is still a feature request, I would expect the generated array would concat the arrays of all enabled sheets.

Screenshots
image

Info (please complete the following information):

  • Browser: Chrome
  • Logged into a single account in an incognito tab.

Additional context
Complete Settings:

{
  "exportType": "jsonFormat",
  "exportFolderType": "custom",
  "exportFolder": "16eBHLQhCC3ZmEICSoUlr-HMHO7wXiqmu",
  "exportSheets": "custom",
  "targetSheets": "{\"Sheet1\":\"true\",\"Sheet2\":\"true\"}",
  "replaceExistingFiles": true,
  "unwrapSingleRows": false,
  "collapseSingleRows": false,
  "ignoreEmptyCells": true,
  "ignoreColumnsWithPrefix": true,
  "minifyData": false,
  "includeFirstColumn": false,
  "ignorePrefix": "NOEX_",
  "unwrapSheetsWithPrefix": false,
  "unwrapPrefix": "US_",
  "collapseSheetsWithPrefix": false,
  "collapsePrefix": "CS_",
  "nestedElements": true,
  "forceArrayNest": false,
  "forceArrayPrefixNest": "NA_",
  "forceString": false,
  "exportCellArray": false,
  "exportSheetArray": true,
  "exportValueArray": false,
  "exportContentsAsArray": true,
  "exportCellObject": false,
  "emptyValueFormat": "null",
  "nullValueFormat": "null",
  "separatorChar": "~",
  "forceArray": true,
  "forceArrayPrefix": "JA_",
  "exportChildElements": false,
  "exportBoolsAsInts": false,
  "rootElement": "data",
  "nameReplacementChar": "_",
  "includeDeclaration": false,
  "declarationVersion": "1.0",
  "declarationEncoding": "none",
  "declarationStandalone": "none",
  "forceAttributes": false,
  "attributePrefix": "ATT_",
  "forceChildElements": false,
  "childElementPrefix": "CE_",
  "forceInnerText": false,
  "innerTextPrefix": "IT_",
  "rootNamespace": "",
  "namespaces": []
}

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions