All geek questions in one place

What does QFE_Richmond mean?

I am developing a VBA add-in for Excel that uses a RefEdit control.
One of my testers indicated that when selecting cells, he cannot use keyboard shortcuts. And I found a solution to this problem here: http://support.microsoft.com/kb/291110
Set the magic value of QFE_Richmond to 1 in the Excel section HKEY_CURRENT_USER . This solution works great.

My question is why? What is the value of the variable "QFE_Richmond"? Where is it from? Why do you need this obscure flag to fix a simple glitch that persists, at least through Excel 2010 and at least back in 2003? Does this flag do anything else?
And is it safe to automatically change this change for users of my add-in, even if it globally affects their Excel settings?

+4
source share
1 answer

The obvious answer is that they either forgot to apply it in each version, or do not consider it important enough to make a default, because it is on the verge of being considered a mistake or preference for usability, because it has a simple workaround (for example, using GUI instead of shortcuts). I would not have thought that applying the patch would hurt anything - they would not be available if that were the case.

Changing the QFE_Richmond registry key to 1 is to enable the fix.

http://support.microsoft.com/?kbid=291110

"As a rule, corrections are corrected for a specific situation of the client and may not be distributed outside the customer organization."

In addition, the RefEdit control has alternatives: http://peltiertech.com/WordPress/refedit-control-alternative/ Which was recommended because it has compatibility issues: http://peltiertech.com/WordPress/unspecified-painfully- frustrating-error / Therefore, you can probably assume that MS has some gaps in its quality control for the RefEdit function.

Good luck.

EDIT / Addition:

By the way

QFE stands for Quick Fix Engineering

+1
source

Source: https://habr.com/ru/post/1434261/

More articles:


All Articles