[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 --- Comment #9 from Mike Kaganski --- (In reply to Mike Kaganski from comment #8) > It may be useful to have in the UI. ... and it is there - I just missed that. So it is all good. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 --- Comment #8 from Mike Kaganski --- "Remove all whitespace" is definitely not a good pre-defined option. If someone finds them often in need of such, it indicates they face some ill-prepared sources. But generally, why not also introduce "remove all characters A to H"? and also "all numbers 3 to 7"? Import filter has an option to trim leading/trailing spaces - see option 11 in [1]. It may be useful to have in the UI. But not anything more special. For the infinite number of special cases, there are ways to pre-process the data, or post-process it (functions, macros, extensions, external scripts running on exported data...). It is not reasonable to try to build a "universal paste plain text" tool that would be able to do just anything any person on Earth may ever want to do with their data. Same for other UI places (like menu item). [1] https://help.libreoffice.org/7.6/en-US/text/shared/guide/csv_params.html?DbPAR=SHARED#bm_id181634740978601 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 Heiko Tietze changed: What|Removed |Added Blocks||108479 Status|UNCONFIRMED |NEW Keywords|needsUXEval | Ever confirmed|0 |1 CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #7 from Heiko Tietze --- We discussed the topic in the design meeting. Some alternative workflows exist and the use case is not clear. On the other hand some believe such a feature would be convenient. In the end we don't come to a conclusion and suggest to keep the ticket open. If more users request this addition it might be reconsidered. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108479 [Bug 108479] [META] Paste special bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 --- Comment #6 from ady --- (In reply to V Stuart Foote from comment #5) > (In reply to Eyal Rozenberg from comment #4) > > Why is it a common use case to want to remove all whitespace, as opposed to > > trimming the heading and trailing white space? Convince me please... FWIW... If the request is to remove absolutely _all_ whitespace, then there is no need to change anything; we can already do that by several methods. If the request is to remove _repeated_ whitespace characters (e.g. reduce multiple consecutive spaces to one), we can also do that by several methods. > > For the most part, when white space is included it is not desired--it Sorry but… is there any source for such claimed statistic? Some use-cases might require that behavior, and others do not. > represents ill-considered formatting and bloats the strings being > copy/pasted. That includes enclosing as well as included text runs of > spaces. Users could also mark the undesired character as separator in the import dialogue and also check Merge delimiters. After that, concatenate the resulting columns, if needed. That also eliminates _all_ whitespaces. > > Ability to suppress the paste of the unhelpful space runs, as opposed to > having to do repeated find/replace sequences, is appealing. There is no need to do "repeating" find/replace sequences. Select the relevant area, and replace _all_, current selection only, searching for 2 consecutive spaces (or whatever you want to replace) and replacing with only one (or none, or whatever). Perhaps there is some case/need to repeat the action in some particular case, but then using regular expressions in the "Find and Replace" could help in this regard too. If all the current alternatives are not enough, let's not forget that Calc is not a text editor. Many relevant requests for additional options in several different areas in Calc have been rejected just to "avoid clutter" (and I disagree with that reasoning). This time we have a request that has enough alternative solutions already. > > Toggle is sufficient, but I would suggest suppression of white space should > be the default. Having the requested option set to ON by default would be a terrible idea. Users then would ask why the import is now resulting in a different display content than the content of their original (CSV) file, especially if they had done the same import in the past. If you add an option for some particular (advance) case, then (advance) users should take responsibility for acting on such option. At most, you could make the option to be remembered within the session after the user sets it to ON, but changing the current default behavior with no good reason is bad practice. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 V Stuart Foote changed: What|Removed |Added CC||vsfo...@libreoffice.org --- Comment #5 from V Stuart Foote --- (In reply to Eyal Rozenberg from comment #4) > Why is it a common use case to want to remove all whitespace, as opposed to > trimming the heading and trailing white space? Convince me please... For the most part, when white space is included it is not desired--it represents ill-considered formatting and bloats the strings being copy/pasted. That includes enclosing as well as included text runs of spaces. Ability to suppress the paste of the unhelpful space runs, as opposed to having to do repeated find/replace sequences, is appealing. Toggle is sufficient, but I would suggest suppression of white space should be the default. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148544] Option to remove all whitespace in "Paste special" and other dialogs
https://bugs.documentfoundation.org/show_bug.cgi?id=148544 Eyal Rozenberg changed: What|Removed |Added Summary|proposal-option to remove |Option to remove all |whitespace characters |whitespace in "Paste |(other than space) in |special" and other dialogs |"paste special", "clear | |direct formatting", | |Format->Text and in import | |dialog box | -- You are receiving this mail because: You are the assignee for the bug.