Re: Open Office Spreadsheet question
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-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office Spreadsheet question
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 wrote: > > > > On 10 Jul 2020, at 21:50, Glenn Little WB4UIV < > glennmaill...@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
> On 10 Jul 2020, at 21:50, Glenn Little WB4UIV > wrote: > > How can I display non printable characters? Top menu select View than select View non printable characters > > Thank you > Glenn > > -- > --- > Glenn LittleARRL Technical Specialist QCWA LM 28417 > Amateur Callsign: WB4UIVwb4...@arrl.netAMSAT 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-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office Spreadsheet Question......
On 1/07/2013 5:03 PM, Aj Marshall wrote: Hello there, I was just wondering if there is a way to lock the background color of a cell without locking the number in it. See, I'm using the spreadsheet as a points system and each week I have to move people around but what happens is I have to reformat a lot of the background colors. It depends on how you move people around when you drag cells around it doesn't work, but you could probably use conditional formatting it all depends on your data. If you like to share your spreadsheet we could give some advice but without seeing it we're unable. Anyway, please let know Thanks AJ - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office Spreadsheet Question...
At 00:03 01/07/2013 -0700, Aj Marshall wrote: I was just wondering if there is a way to lock the background color of a cell without locking the number in it. See, I'm using the spreadsheet as a points system and each week I have to move people around but what happens is I have to reformat a lot of the background colors. You need to move the values in your spreadsheet whilst keeping the background colours where they are? That's easy if you use Paste Special. o Copy the required cell(s). o Go to Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V). o In the Paste Special dialogue, remove the tick from Paste all if necessary and then ensure that Text, Numbers, or whatever are ticked and that Formats is *not* ticked. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org