https://bugs.documentfoundation.org/show_bug.cgi?id=148544
Bug ID: 148544
Summary: proposal-option to remove whitespace characters (other
than space) in "paste special" and in Format-Text
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
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.
-Also a comparable feature in the other office suite programs.
Actual Results:
I cannot find the equivalent functionality, other than using cell formulas to
accomplish the same task: =trim(clean(*cell*))
Expected Results:
self explanatory..
Reproducible: Always
User Profile Reset: No
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.
This would help when importing/copy & paste from databases, websites, pdf's,
other spreadsheet programs, etc.
For example, when a website has a built in grid/spreadsheet, white space
characters often copy over with it. Same when copying data from a database. A
lot of whitespace characters and unnecessary padding that meets the needs of
the database column types, but not necessary for Calc users.
Often when I do import and I find the current formatting annoying, I will do a
"Clear Direct Formatting". Having it built into this functionality would also
be beneficial since it serves no purpose (I can't think of a use case) for
retaining those whitespaces after a "clear direct formatting" use.
--I assume that other latin letter based character sets have the same
whitespace problems. I am not sure if this is the case with non-latin (i.e.
16bit+ wide) character sets.
--
You are receiving this mail because:
You are the assignee for the bug.
