Ignore folded child grids when exporting to csv

[jn64]

I have some docs that are originally imported from csv, but I added some nested grids. If I want to export them back to csv with the original table structure, I have to manually delete all nested grids first.

Here is a screenshot to illustrate. I would like to be able to export grid 3 without having to manually delete its child grid.

---

Also, when trying to export grids 2 or 3, I have to enter a filename in the file dialog first, before it gives the error "Cannot export grid that is not flat" in the status bar, which is slightly unintuitive. Sometimes I miss the error and don't realise that no file was exported. It should check whether the operation is possible before showing the file dialog.

[aardappel]

There is a Edit -> Grid Reorganization -> Flatten that I added for the purpose of bringing things back to grids, but it doesn't retain the same structure.

I suppose either ignoring folded, or having it just allow it generally (maybe it could give a warning popup instead, saying hierarchical grids were lost)

[jn64]

For CSV, it would be fine to just automatically ignore child grids. But a benefit of ignoring folded is that it can be extended to other export formats.

One use case is making presentations. You could write things like presentation notes that you don't want to show in the presentation, and fold them. Currently that works for presenting with TreeSheets itself, but not with exporting to HTML (everything is unfolded in the HTML).

[AntonBogun]

What you can do (quite easily at that) is make a lobster script that deletes all subgrids within the selected grid, then perform the csv export, and then perform an undo which will reverse all the changes done with the script.