https://bugs.documentfoundation.org/show_bug.cgi?id=148544
--- Comment #3 from ady <[email protected]> --- (In reply to Heiko Tietze from comment #2) > Clean() removes non-printable characters from the string but keeps multiple > spaces, for example. Calc has TRIM() for this purpose. Does that help, Eric? TRIM() is already mentioned in comment 0. There are several ways to accomplish the deletion of "extra" characters, including "Find and Replace". Generally speaking, I am in favor of adding options to accomplish an objective that is currently not achievable, or when it currently requires several steps or too much time (or more-advance knowledge), or when it would add the possibility to achieve alternative results according to users' needs. However, I don't see this request as such case. > > For the CSV/text import and paste special it could be a nice-to-have. There are conflicting options already present in some of the importing or paste special dialogues. For instance, the current "Trim spaces" check box is aimed at trimming the initial and trailing spaces (only); there other potentially conflicting options (in relation to this request), while there are several alternatives to achieve the goal of this request already. > -Also a comparable feature in the other office suite programs. @Eric, for whoever would be interested in implementing this request, it would be helpful to have screenshots of those comparable features as attachments in this request ticket. -- You are receiving this mail because: You are the assignee for the bug.
