At 10:07 16/01/2013 -0500, Nobody Noname wrote:
Have looked for an hour online and in the help texts trying to
figure out how to edit what I see in the Selection List when I right
click on a cell in Calc and get the pulldown list.
I've been through the data validity drill but see nothing in the "list" there.
And I've gone through the autocorrect options with no help. I don't
see any of the text that is in my "selection list" displayed in the
Autocorrect options at all.
I found the files in the users .config directory but they don't
appear to be editable via text tools.
I hesitate to suggest this, but I believe you may be conflating two
different facilities here.
o If you right-click a cell and choose Selection List..., the list
you are presented with is simply the collection of different entries
already present in the same column. There is no way of editing this
list, I think, except by adding values to or removing existing values
from elsewhere in the same column - which you would probably not want
to do. This facility is presumably intended to obviate repetitive
typing, not to control the contents of cells.
o To control the values in the list, select the required range of
cells (quite possibly a column) and go to Data | Validity... |
Criteria. Against Allow, select an appropriate choice from the
drop-down menu - probably List. Ensure "Show selection list" is
ticked and type your required entries, one per line, in the Entries
box. (The other tabs provide facilities for restricting possible
entries as well as setting an error message.) Now you will see your
desired entries if you either use right-click | Selection List... or
click the down arrow next to the current cell.
I trust this helps.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy