RE: Autocomplete and DropDown box issues

["Thomas P. Medill" <tpm5 arl psu edu>]

Andreas-

My original testing may have been before I discovered View-Properties. However, for my "UPDATE" email 
(inserted below), I first set Autocomplete ON in both Edit-Preferences-Tools and View-Properties, and then 
launched a new page to do my testing.

Looks like some installation-specific issues.

Thanks for your feedback.

-Tom

-----Original Message----- [THIS "UPDATE" INSERTED FOR CONTINUITY]
From: Thomas P. Medill 
Sent: Thursday, November 29, 2012 6:13 PM
To: 'gnumeric-list gnome org'
Subject: UPDATE ON: Autocomplete and DropDown box issues

Results of further experimentation with Autocomplete:

- Autocomplete sometimes works, sometimes doesn't. All sorts of seemingly unrelated actions cause it to stop 
working, sometimes for good, sometimes for short periods. I read everything I could find in the bug reports 
and manuals; some of it confirms my problem.
 
- Does not work on "referenced" values, but only on cells with the actual text string.

- Match is case sensitive (some of my earlier attempts failed because of this).

- Immediately after trying something that doesn't work (like a non-matching case), next try at autocomplete 
will fail. Try once more, and it works.


Thanks,
Tom


-----Original Message-----
From: gnumeric-list-bounces gnome org [mailto:gnumeric-list-bounces gnome org] On Behalf Of Andreas Guelzow
Sent: Friday, November 30, 2012 3:26 AM
To: gnumeric-list gnome org
Subject: Re: Autocomplete and DropDown box issues

On Thu, 2012-11-29 at 19:59 +0000, Thomas P. Medill wrote:
> Recently installed Gnumeric Spreadsheet 1.10.16 under Win7/64 and have a couple issues:
>
> - Autocomplete does not work. I have it checked under
> Edit-Preferences-Tools, but it acts as though it is turned off. I am
> assuming that it should work same as in Excel, namely, that it looks
> for matches above in same column.

You cannot turn Autocomplete on by using Edit-Preferences-Tools. That
setting only affects whether new views of a document have autocomplete
turned on. It does not affect existing views. For an existing view you
need to use View->ViewProperties
> - I created a drop down box using Data-Validate-"In a list". I can
> open the box using Alt-DownArrow, but I cannot figure out how to move
> down my list using the keyboard. It works when navigated with a mouse,
> but I need a keyboard method. In Excel, you navigate the list using
> the up and down arrows and then hit Enter on desired item.

I can navigate in it using the he up and down arrows and then hit Enter
on desired item. 

Of course I am not using a recent version of Gnumeric on Linux.

Andreas 


-- 
Andreas Guelzow <aguelzow pyrshep ca>

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list