[Bug 135762] Provide an option in the UI to export all sheets as CSV

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135762

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Export all sheets as CSV    |Provide an option in the UI
                   |                            |to export all sheets as CSV
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
           Keywords|needsUXEval                 |
             Blocks|152086                      |
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=15
                   |                            |2086

--- Comment #29 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
We discussed the topic in the design meeting.

+ we should make sure not to break any standards
+ GSheet and Excel cannot export multiple sheets to CSV at all
+ users may also want to save multiple sheets in other formats such as txt,
tsv, html

Three solutions come in mind, none is perfect:

a) add another checkbox to the file dialog
   + breaks the system default layout further
b) another filter type like "Multiple Text CSV (*.csv)"
   + users could become greedy and want the same for other formats
     exploding the filter list
c) Tools > Options > Load/Save: "[ ] Save all sheets as separate CSVs"
   + would not be suited if user need to switch the option frequently
d) another top level command "Save Active Sheet As..." vs. "Save As..."
   with all the current filters below
   + changes the default and users familiar with the current workflow
     have to learn that Save As... exports all sheets as CSVs or the like


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=152086
[Bug 152086] FILESAVE: Export all/current sheet(s) to CSV from the "Export..."
menu
-- 
You are receiving this mail because:
You are on the CC list for the bug.