Hello, how can I use macro (Basic) to save changes for only one sheet in Calc (by the way, the document has several sheets), without closing the document? Thanks in advance.
Hello, please clarify how exactly to save changes to a sheet: save one changed sheet as a new file or save the entire spreadsheet, discarding changes on other sheets? As you asked - there is no way, the .store() method will write to disk all the sheets with the changes made.