RE: Autocomplete and DropDown box issues


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.


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


-----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 Guelzow <aguelzow pyrshep ca>

gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]