Fonts
Forgive me if this is a stupid question: Is there a variety of fonts available with your WP program? I’m one of those quirky people who are firmly attached to fixed space typewriter fonts.
Re: Fonts
On Tue, 19 Apr 2016 01:54:23 -0500 "Gerry Turner" wrote: > Forgive me if this is a stupid question: Is there a variety of fonts > available with your WP program? I’m one of those quirky people who are > firmly attached to fixed space typewriter fonts. OpenOffice will use the fonts already installed on the computer. It detects these when it is started up. If you wish for a monospaced font, locate one that suits your taste, install it in the normal way for your operating system, then start OpenOffice and the font should be available to it. Note that you may need to stop the OO Quickstarter if this is running in the background. The easiest way to do this is to power down the computer (using the correct shutdown procedure), then power on again. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
elevation
When trying to open files I get a message stating file requires elevation. Please advise, I have found no link to answer this question.
Drop Down Menu, Again
AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) Win 8x64 I have done this once before, but am not able to repeat it. I want a drop down arrow that when clicked opens a list of pre-written choices. This list is presently located on a separate worksheet, titled "Lists", in AOO Calc; and it works locally there on the List worksheet. But, I want to introduce this "drop down menu selection" within an existing column within a separate worksheet; and not at the head of the column. I have tried Data-Filter-Auto Filter, but that seems to require beginning at the very top of a column. I will want to add additional choices at a later time; thus, I think the List must be on a separate worksheet so that I can resort the entries alphabetically. Thanks for reading this. Regards, Vince B. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Drop Down Menu, Again
> On 20 Apr 2016, at 7:05 AM, Vince wrote: > > AOO412m3(Build:9782) - Rev. 1709696 > 2015-10-21 09:53:29 (Mi, 21 Okt 2015) > > Win 8x64 > > > I have done this once before, but am not able to repeat it. > > I want a drop down arrow that when clicked opens a list of pre-written > choices. This list is presently located on a separate worksheet, titled > "Lists", in AOO Calc; and it works locally there on the List worksheet. > Start with selecting your choices on the "Lists" tab and give it a name (Insert Name from the menu) Go back to the Cell where you like the Drop Down menu and select Validity from the Data menu. In the window you select Cell Range and enter the name as the Source. > But, I want to introduce this "drop down menu selection" within an existing > column within a separate worksheet; and not at the head of the column. > > I have tried Data-Filter-Auto Filter, but that seems to require beginning at > the very top of a column. > > I will want to add additional choices at a later time; thus, I think the List > must be on a separate worksheet so that I can resort the entries > alphabetically. > > Thanks for reading this. > > Regards, > Vince B. > > > > > > > - > 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: Drop Down Menu, Again
At 17:05 19/04/2016 -0400, Vince Bonly wrote: I want a drop down arrow that when clicked opens a list of pre-written choices. This list is presently located on a separate worksheet, titled "Lists", in AOO Calc; and it works locally there on the List worksheet. But, I want to introduce this "drop down menu selection" within an existing column within a separate worksheet; and not at the head of the column. There is no such thing as a "worksheet" in OpenOffice (Calc): each spreadsheet (document) contains, potentially, a number of sheets. I'm not sure whether you mean another sheet in the same spreadsheet or a different spreadsheet; I'm guessing the former. Both are possible, but neither is necessary. o Prepare the list of prompted values. o Select the range of cells to which this should apply. o Go to Data | Validity... | Criteria. o For Allow, select "Cell range". o Either put the cursor into the Source box or click the Shrink button to its right. o Drag the cursor down the list of values. (This can be on another sheet.) o Click the Shrink button if necessary. o OK. It appears that you cannot drag down a cell range on a sheet in a separate spreadsheet document, but you *can* construct an expression in the Source box that refers to such a cell range. (But I'm guessing you don't want to do this anyway.) I will want to add additional choices at a later time; ... The simplest way to do this is probably to select a cell range (above) that is big enough to contain as many choices as you are likely to need. Then fill the as yet unneeded cells with copies of one of the original values. Your list may say something like one / two / three / four / one / one / one etc. Providing the sort option is used (see below), only one copy of such a repeated entry will appear in the drop-down menu. ... thus, I think the List must be on a separate worksheet so that I can resort the entries alphabetically. No, there are two misunderstandings here: o It is unnecessary to sort your list of prompted values alphabetically: you can leave it unsorted and tick the "Sort entries ascending" box on the Criteria tab in the Validity dialogue. o In any case, there would be nothing to stop you sorting this list separately if you wished - without sorting any rows or surrounding values. 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
