Issue 106500 - allow to show nonprinting characters like in writer also in calc
Summary: allow to show nonprinting characters like in writer also in calc
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-30 17:00 UTC by meywer
Modified: 2019-02-22 22:14 UTC (History)
5 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description meywer 2009-10-30 17:00:23 UTC
Its ennoying, that if there is in a calc cell a string and after it a space
(which isn't shown), the auto-completition always wants to complete with this
space...
But when I want to delete this space, I have to find it, which is nearly
impossiblie missing the show-nonprinting-characters-option.
Comment 1 aceman_ooo 2009-10-31 20:41:46 UTC
This would be nice.
Comment 2 Edwin Sharp 2014-01-15 17:54:56 UTC
IMHO not useful.
Comment 3 Tatr 2019-02-07 12:41:00 UTC
I think it is usefull
Comment 4 Marcus 2019-02-10 14:53:32 UTC
I reopen this issue.

From the support forums (thanks David) there is the following use case:

"We do get occasional problems on the EN forum where a stray trailing non printing character causes unexpected problems with some formulae."
Comment 5 Yazen Zaghameem 2019-02-22 22:06:19 UTC
I too would find this feature useful, especially if we could set non-printing characters to display with a particular style (e.g red font).
Comment 6 Yazen Zaghameem 2019-02-22 22:14:01 UTC
Often times I am working with SQL data that has not been sanitized properly, and being able to readily differentiate non-printing characters (e.g spaces from tabs) would help in my use cases.