audreyt
Delete a file
Hello,
Is it possible to delete a file (a spreadsheet) and how ?
For this kind of request, does a forum exist or is it the good place here ?
Thanks
This is a good place.
Currently, the easiest way in the UI is select all cells and click erase.
Programmatically, use a PUT request with an empty spreadsheet content to overwrite an existing sheet work as well.
If your use case is not covered by either of them, please re-open this ticket with more details. Thanks!
We're using file-based storage and even after deleting the contents, the reference to the spreadsheet remains in the dump.json, leading to increased size of the file over time. Is there any way to remove the sheet completely from the JSON file - maybe by using an external tool to cleanup the JSON and forcing ethercalc to re-read the smaller file afterwards?
Yeah, the audit trail would still exist in the JSON file (or Redis DB).
Is storage space a concern for you? How large, roughly, is the dump.json file?
The name (as used in the URL) of the spreadsheet remains in the JSON file, if I'm not mistaken. That name can be freely chosen by visiting a made-up URL – so, one does not have to use the default random names. Which means that when using private information in a name by mistake, one cannot unpublish this later by deleting the sheet. IMHO it would be cleaner to be able to delete sheets …
This would be an important feature - even a legal requirement. Especially in light of the GDPR if a spread sheet e.g. contains names or also more sensitive data, a user must have the possibility to effectively delete everything with a button.
