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
--
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
