Hi; When I right click on a cell in Calc I get a 'Selection List' option. It is a nice feature, however I would like to alter it for use in some Spreadsheet columns. I would like to restrict the list to just a few choices rather than all unique items taken from the whole column. I would like to order the list by priority rather than alphabetically.
I would like to turn it off in other columns. I have seen suggestions to use either the List Control or the Combo control but I can't see how to make these controls active in each cell like the 'Selection List' is. I can and will use those controls in an Input form, but they don't seem applicable to cell entries. Lastly I would like to assign a shortcut key to the 'Selection List' -- the Alt-S doesn't seem to work, at least not with or without the context (right click) menu. I would appreciate any pointers; or, perhaps there is another name that the 'Selection List' function goes under that has an explanation. -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
