https://bugs.documentfoundation.org/show_bug.cgi?id=148544
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needsUXEval Whiteboard| QA:needsComment | CC| |libreoffice-ux-advise@lists | |.freedesktop.org --- Comment #1 from Buovjaga <[email protected]> --- (In reply to Eric Williamson from comment #0) > Description: > In Calc: > 1. a tick box in Paste Special to remove "all whitespace" as a pasting > feature > 2. a menu option in Format -> Text. To do the same thing. --Since other > formatting options like *case (UPPER/lower/etc) exist, it might also makes > sense to have it here as well since whitespace characters affect the > positioning and formatting. > 3. Import data dialog box... same as #1 but in the import dialog box to > allow whitespace removing while importing data. > 4. (Optional) have it as part of the "Clear Direct Formatting" menu option. ... > Additional Info: > The proposal would be the equivalent of (in Calc): =trim(clean(*cell*)) & > paste special -> text, then copy the new cell, over the old one. Clean function description: https://wiki.documentfoundation.org/Documentation/Calc_Functions/CLEAN CLEAN removes a specific set of non-printable characters that are defined in the C0 Controls and Basic Latin Unicode block. The exact non-printable characters that will be removed by CLEAN are: Any character in the code point range U+0000 to U+001F (inclusive). The character with code point U+007F. Space characters (code point U+0020) are not removed by CLEAN. CLEAN does not currently remove any non-printable characters defined in other Unicode code blocks and thus is not totally compliant with ODF 1.2. -- You are receiving this mail because: You are the assignee for the bug.
