Problem Statement/Rationale
When exporting data to CSV format in version 1.36.4, where an array of objects is involved, the array is recorded as a single cell with a string value. However, in subsequent versions, the array is split into individual fields for each object, occupying multiple cells in the document. This new behavior significantly reduces data readability compared to the previous version.
Steps to Reproduce
To replicate the issue, follow these steps:
- Open version 1.36.4 and 1.37.0 or the latest of the application.
- Export data containing an array of objects to CSV.
- Observe the formatting of the exported CSV file.
Expected Results
We expect the exported CSV file to maintain consistent formatting across versions, ensuring that arrays of objects are presented in a readable manner.
Actual Results
In version 1.36.4, the exported CSV file contains arrays of objects within a single cell as a string value. In later versions, the array is split into multiple cells, corresponding to the fields within each object, leading to reduced readability.
Action Requested:
We kindly request the Engineering team to address this issue in one of the following ways:
- Option to Choose Array Export: Introduce a feature that allows users to choose how arrays are exported in CSV, either as single cells or split into individual fields.
- Revert to Previous Behavior: Alternatively, consider reverting to the previous behavior where arrays were exported as single cells, as it provided better readability.
Additional Notes
Sample data for reproduce - {events: [
{symbol: 'A', symbol: 'B'}
]}.
This issue significantly impacts the usability of exported data and hampers the analysis process. We appreciate your prompt attention to this matter and any potential solutions to improve the exporting functionality while maintaining data readability.
|