(Bug) 'Export sheet arrays' + 'Export contents as array' only exports one sheet
Opened this issue · 0 comments
Ryuichiro commented
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:
- Create a 2. Sheet
- Set A1 of Sheet1 and Sheet2 to
{#SHEET}{#ROW}Id
- Set A2 of Sheet1
1
and A2 of Sheet2 to2
- Enable 'Nested Elements' && 'Export sheet arrays' && 'Export contents as array'
- Set 'Export Sheets' to All Sheets (or Custom and select both Sheet1 and Sheet2)
- Export or Visualize data
- 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.
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": []
}