On 21 February 2013 21:33, Dan Lewis <[email protected]> wrote:
> On 02/21/2013 03:00 PM, Rev. Nick Sharp wrote: > >> I have a spreadsheet to record financial transactions, and to save typing, >> I maintain a list of common transactions which can be selected in certain >> cells by a drop down box. I populate the list from a cell range in another >> sheet. >> >> When I add new transactions to the list, and try to redefine the Cell >> Range, Calc crashes. On re-opening, I find that it has saved the changes I >> made, but I can't stop the crashes. >> >> Any ideas? >> > Usually when are typing in a spreadsheet, Calc will suggest a word > based upon what you have typed in one of the cells before So, I'm not sure > you need a drop down list. > Also a simple database for your expenses will do what you want > including the use of drop down lists. > > --Dan > > Dan - thanks for the reply. Perhaps I am using a sledgehammer to crack a nut, though it is useful to be able to limit inputs to only a list of possibilities. What concerns me is the crashing. Have any other users found this problem? Nick -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
