Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Ryuichiro opened this issue Apr 15, 2021 · 0 comments
Labels

Comments

@Ryuichiro
Copy link

Ryuichiro commented Apr 15, 2021

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": []
}
@Ryuichiro Ryuichiro added the bug label Apr 15, 2021
@Ryuichiro Ryuichiro changed the title (Bug) Title (Bug) 'Export sheet arrays' + 'Export contents as array' only exports one sheet Apr 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant