Synthoid/ExportSheetData

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

Opened this issue · 0 comments

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": []
}