Re: [libreoffice-users] LO 4.0.0.3: Calc Crashes when setting data validity

On 21 February 2013 21:33, Dan Lewis <elderdanlewis@gmail.com> 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: users+help@global.libreoffice.org
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