Re: Formula Completion Feature
- From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
- Date: Fri, 12 May 2006 13:59:34 -0700
Already taken care of
http://blogs.msdn.com/excel/archive/2005/10/19/482826.aspx
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Kristoffer Andreas Berg" <KristofferAndreasBerg@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:F30BB02F-4A76-4808-A8EC-516EC4A0FA5C@xxxxxxxxxxxxxxxx
A useful enhancement for Excel would be a formula completion feature like
the
one in Delphi. You just type an equal sign, and a list of valid labels,
names
and functions pops up below the cell. There should be different colors for
the text telling what the word on that line is, i.e., label, name or
function.
As you type, all the entries not matching the text you have typed should
disappear. One could move up and down the list by the up and down arrow
keys.
To accept an entry one could just type a comma (if you have completed a
function argument), Enter (if choosing a label, name or function) or the
next
operator (if choosing a label or name or if you have closed a
parenthesis).
To avoid that the list gets in the way if you want to use the cells behind
it as arguments, there could be a hotkey and a mouse option to toggle the
position between above and below the cell.
When you choose a function, both the opening and closing parentheses
should
be inserted.
The parenthesis matching in Excel causes the cursor to disappear for a
moment. This is annoying to me, and I suggest that Excel could perform
parenthesis matching like Delphi, where the backgrounds of the matching
parentheses are set to cyan when the cursor is just to the left of one of
them.
I have created a few pictures to illustrate my idea. They can be found at
http://home.online.no/~gunnarab
--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=f30bb02f-4a76-4808-a8ec-516ec4a0fa5c&dg=microsoft.public.excel.misc
.
- Prev by Date: Re: AND with multiple conditions
- Next by Date: Re: Searchable archive
- Previous by thread: Re: Pivot Table-change Subtotal text?
- Next by thread: Re: format toolbar is displayed in Excel, but is inactive (gray).
- Index(es):
Relevant Pages
|
