Was http://qa.openoffice.org/issues/show_bug.cgi?id=62729 "When I save a spreadsheet to CSV, only the active sheet is saved. The first time I ever did it, I might have cared about the warning, but now I do not. Please allow me, in a similar fashion to firefox, to elect to never see this message again via a checkbox. It should, ideally, default to checked." The dialog show to you just previously covers off much of the warning needed when it asks me if I wish to save in an open document format instead. That dialog has a 'never show me again' feature. If any warnings that were needed could be shown at that stage; this would remove one annoyance.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I can verify this behaviour is still a problem with 3.4.4 at the very least.
in 3.5.2.2 checkbox for disabling this warning not added yet
Neither fixed in 3.5.4 This more than annoying is a BIG bug: it avoids to transform documents into PDF from batch processes.
I'm not sure I can still reproduce this with LO Version: 4.5.0.0.alpha0+ Build ID: 09a1e4f36128f64029d45a38d9b059bf11ea0821 TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2015-04-15_23:40:09 Locale: de_ Please add exact reproduce steps for this bug and add a screenshot of the dialog which you do not want to see (or be able to "never show again"). Once the additional info has been provided set this bug back to NEW please.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-10-14
I can confirm this on 5.1.2.1. A warning dialog still shows up when saving to CSV from document with multiple sheets with no option to never see it again. The text is as follows. Title: "LibreOffice 5.1.2.1" Message: "Warning saving the document testfile: Only the active sheet was saved." Steps to reproduce: 1. Create a new sheet inside spreadsheet document (so you have at least 2 sheets). 2. File → Save as 3. Pick .csv as file format. 4. Save 5. The annoying dialog shows up.
Created attachment 124435 [details] The annoying dialog.
I am working on a patch for this.
Created attachment 162665 [details] Video demo of patch. Here I have saved a document with 2 sheets as a CSV file. I re-save it, and it shows the warning dialog. I uncheck the checkbox and click OK. The next time I save the document, it does not show the warning.
Created attachment 162666 [details] Current dialog on my system (Ubuntu 18.04).
Created attachment 162667 [details] Proposed new dialog.
That sounds interesting :-) Is this option available only for current file, or is it for all next CSV files? I would prefer only for current file. Text "Warn me about this in the future." may need some rewording: "Warn again for next saving"?
(In reply to Laurent BP from comment #13) Thanks for the suggestions. > That sounds interesting :-) > Is this option available only for current file, or is it for all next CSV > files? I would prefer only for current file. It applies for all files. I think this is required to fix the batch process issue in Comment #4 above. To be clear, it applies when saving from ODS to CSV as well as re-saving the CSV. > Text "Warn me about this in the future." may need some rewording: > "Warn again for next saving"? t actually applies to all future savings, so I prefer the original wording. I copied the text from the "replace existing content" dialog, which occurs when you paste into a cell where there is already something, so it is consistent. I'm planning to request feedback from the UX team, so let's see what they say.
Created attachment 162768 [details] Proposed new option in the preferences window. This is the corresponding new option in the Preferences Dialog. It's currently under "Calc --> General --> Input" which is probably the wrong place, so should be moved somewhere better.
UX Team -- please take a look at this enhancement. Thanks! The attached screenshots and video show my proposed patch. In particular, the option I propose to add in the Preferences Dialog should be moved to a different section than "Calc -- General -- Input". What section should it be moved to? (https://bugs.documentfoundation.org/attachment.cgi?id=162768) Also note the suggestions in Comment #13 and Comment #14.
Not perfectly sure how it works. Save on a sheet that has been saved as CSV only or also for every new document and/or session. The first doesn't need a global option. The other can be with "Show override warning" but ideally we create an extra section. Most input settings could go into Default or warnings to View. The text itself better align with the checkbox on the dialog. Something like "Show warning when saving only the active sheet". You label the checkbox "Warn me..." which is a bit uncommon. How about "[x] Show this warning when saving only active sheets". The checkbox is typically left-aligned placed at the very bottom of the dialog. See the tip of the day dialog what I have in mind [1] (first idea was to create a generic "extended" confirmation dialog, which could be used for other messages too). [1] https://design.blog.documentfoundation.org/wp-content/uploads/sites/2/2019/06/spectacle.png
(In reply to Pablo Beltran from comment #4) > This more than annoying is a BIG bug: it avoids to transform documents into > PDF from batch processes. (In reply to Martin van Zijl from comment #14) > It applies for all files. I think this is required to fix the batch process > issue in Comment #4 above. I'm sorry, but I don't see comment 4 relevant to this "Export to CSV" RFE at all; and so I don't see how this is necessary for batch-process. We definitely need some centralized infra for disabled dialogs - possibly per-module, like dedicated options tab under each module... but that's a separate task.
Martin's patch: https://gerrit.libreoffice.org/c/core/+/98174
Dear Martin van Zijl, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assign it back to yourself if you're still working on this.
Noel, you did a lot effort in https://gerrit.libreoffice.org/c/core/+/157440. I could imagine a more flexible solution with a list that picks up all strings from sc/inc/scerrors.hrc showing the list at the options dialog, plus a checkbox on each messagebox to disable the warning. Or just individually suppress the warning as Martin did (comment 19)?
(In reply to Heiko Tietze from comment #21) > flexible solution with a list that picks up all strings from I dont think that is a very good idea. There are only a few warnings that can usefully be suppressed, and they should each be carefully examined to see if it is a good idea.
Heiko Tietze committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/dbd851c35720ac6f0ebea8a212fa54e79259e36c Resolves tdf#33714 - Option to disable "only active sheet" It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.