[Libreoffice-ux-advise] [Bug 148544] proposal-option to remove whitespace characters (other than space) in "paste special", "clear direct formatting", Format->Text and in import dialog box

[bugzilla-daemon at bugs.documentfoundation.org]

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

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval
         Whiteboard| QA:needsComment            |
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org

--- Comment #1 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(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 on the CC list for the bug.