Open Office Spreadsheet question

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Open Office Spreadsheet question

Glenn Little WB4UIV
How can I display non printable characters?

Thank you
Glenn

--
-----------------------------------------------------------------------
Glenn Little                ARRL Technical Specialist   QCWA  LM 28417
Amateur Callsign:  WB4UIV            [hidden email]    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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Spreadsheet question

Martin Groenescheij


> On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <[hidden email]> 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            [hidden email]    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: [hidden email]
> For additional commands, e-mail: [hidden email]
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Spreadsheet question

Chuck Spalding
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 <[hidden email]>
wrote:

>
>
> > On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <
> [hidden email]> wrote:
> >
> > How can I display non printable characters?
>
> Top menu select View than select View non printable characters
>
> [snip]
Reply | Threaded
Open this post in threaded view
|

Re: Open Office Spreadsheet question

Martin Groenescheij
In reply to this post by Glenn Little WB4UIV

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: [hidden email]
For additional commands, e-mail: [hidden email]