Excel-DNA / Excel-DNA/IntelliSense

Add hyperlinks from formula tooltip args to actual formula compontent.

Open
#37 1 comment 0 reactions 0 assignees View on GitHub
enhancement up-for-grabs
Dominant language
C#
Stars
179
Forks
55
PR merge metrics
No merged PRs in 30d

Description

Okay, so this one might not be possible, but one of the coolest things about the inbuilt formula tooltip is the hyperlinks in the tooltip that terminate in the corresponding part of the formula in the formula bar. So if you click on an already-fleshed-out formula in the tooltip, Excel selects and highlights the bit within the formula bar that corresponds to that argument.

Okay, so it doesn’t seem so magical when you have a very simple formula with a very simple argument. But when you have a mega-formula whose arguments are in turn generated by other really long and complicated strings of formulas, it’s a freakin’ revelation because it selects all the nested formulas within that argument, which helps you clearly identify where a formula argument begins and ends...and doing this is pretty fiddly otherwise.

Is this possible? I suspect not, given you would have to give the formula bar focus and select the relevant part of the formula.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.