You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Glenn Little WB4UIV <gl...@bellsouth.net> on 2020/07/10 19:50:28 UTC

Open Office Spreadsheet question

How can I display non printable characters?

Thank you
Glenn

-- 
-----------------------------------------------------------------------
Glenn Little                ARRL Technical Specialist   QCWA  LM 28417
Amateur Callsign:  WB4UIV            wb4uiv@arrl.net    AMSAT LM 2178
QTH:  Goose Creek, SC USA (EM92xx)  USSVI LM   NRA LM   SBE ARRL TAPR
"It is not the class of license that the Amateur holds but the class
of the Amateur that holds the license"


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Open Office Spreadsheet question

Posted by Chuck Spalding <cs...@gmail.com>.
Using OpenOffice 4.1.7 on macOS High Sierra (10.13.6), I do not see that
menu selection in *Calc*. (I do see View > "Nonprinting Characters" in
*Writer*.)

Chuck

On Fri, Jul 10, 2020 at 1:14 PM Martin Groenescheij <Ma...@groenescheij.com>
wrote:

>
>
> > On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <
> glennmaillist@bellsouth.net> wrote:
> >
> > How can I display non printable characters?
>
> Top menu select View than select View non printable characters
>
> [snip]

Re: Open Office Spreadsheet question

Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.

> On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <gl...@bellsouth.net> wrote:
> 
> How can I display non printable characters?

Top menu select View than select View non printable characters

> 
> Thank you
> Glenn
> 
> -- 
> -----------------------------------------------------------------------
> Glenn Little                ARRL Technical Specialist   QCWA  LM 28417
> Amateur Callsign:  WB4UIV            wb4uiv@arrl.net    AMSAT LM 2178
> QTH:  Goose Creek, SC USA (EM92xx)  USSVI LM   NRA LM   SBE ARRL TAPR
> "It is not the class of license that the Amateur holds but the class
> of the Amateur that holds the license"
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Open Office Spreadsheet question

Posted by Martin Groenescheij <ma...@groenescheij.com>.
On 10/07/2020 21:50, Glenn Little WB4UIV wrote:
> How can I display non printable characters?


So my first reply was wrong?

Now the real question here should not be how to display non printable 
characters,
but how do non printable characters came in the first place into your 
spreadsheet.

Using your keyboard as a source of input it will be impossible to enter 
non printable characters.

The only way is to copy data from an other source e.g. from a website. 
Websites have al kind of non
printable characters and you should clean the source before you paste 
them into your spreadsheet.

One way is to copy the data into a writer document and use the 
functionality to View non printable
characters there. Clean it and copy the result into your spreadsheet.


>
> Thank you
> Glenn
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org