UPDATE ON: Autocomplete and DropDown box issues
- From: "Thomas P. Medill" <tpm5 arl psu edu>
- To: "gnumeric-list gnome org" <gnumeric-list gnome org>
- Subject: UPDATE ON: Autocomplete and DropDown box issues
- Date: Thu, 29 Nov 2012 23:12:30 +0000
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: Thomas P. Medill
Sent: Thursday, November 29, 2012 3:00 PM
To: 'gnumeric-list gnome org'
Subject: Autocomplete and DropDown box issues
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.
- 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.
Thanks for any help you can offer.
Tom
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]