Bug 98353 - Display non printing characters in spreadsheet (like CTRL+F10 in Writer)
Summary: Display non printing characters in spreadsheet (like CTRL+F10 in Writer)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2016-03-02 16:38 UTC by Knut Wenzig
Modified: 2019-02-07 12:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Knut Wenzig 2016-03-02 16:38:07 UTC
In Writer there is an icon and a corresponding shortcut (Ctrl+F10) which switches Nonprinting Characters on/off. This feature is missing in Calc.
Comment 1 Joel Madero 2016-03-02 19:53:24 UTC
Valid request - moving to NEW.

Interestingly enough, Excel doesn't have it either....seems like an unnecessary omission.

@Knut - just so you don't have false expectations. LibreOffice volunteers almost exclusively tackle enhancement request. All I'm saying is that it's a valid request, not that it will ever be implemented. A volunteer would have to find it interesting enough to do.
Comment 2 Cor Nouws 2016-03-02 23:21:44 UTC
Hi guys,

Can we agree that a spreadsheet != a text document maybe? :)
Comment 3 Joel Madero 2016-03-03 01:54:56 UTC
@Cor - it is troubling that you're using a really really subjective methodology for enhancement requests. We have never been gate keepers but yet this is precisely what is being done here. 

Sure, spreadseets are not text documents, does that mean that non-printing characters are not there? Or that it would never be good to see them?

This is troubling that we're going down this road of gate keepers
Comment 4 Joel Madero 2016-03-03 01:55:32 UTC
(In reply to Cor Nouws from comment #2)
> Hi guys,
> Can we agree that a spreadsheet != a text document maybe? :)

To answer this question abundantly obviously - yes. But that doesn't go to the validity of the request.
Comment 5 Knut Wenzig 2016-03-03 08:01:59 UTC
Would a use case be a way to (In reply to Cor Nouws from comment #2)
> Can we agree that a spreadsheet != a text document maybe? :)

Of course. And therefore we use Calc and not Writer very sucessfully and happily because we are managing content of tables (in our cases: csv-files). However the content of these tables does not always contain numbers and formulas but also more or less plain text. And sometimes it would be great to identify those ugly nonprinting characters which succeeded in stealing in our content without having to copy the cell content to an editor.
Comment 6 Cor Nouws 2016-03-03 08:26:54 UTC
ah well, who am I, so fine of course.
Comment 7 Tatr 2019-02-07 12:52:32 UTC
I think it is usefull feature. I need it.
Comment 8 Tatr 2019-02-07 12:53:31 UTC
How to vote for this issue to implement this feature?