tailieunhanh - Excel add in development in c and c phần 8

DLL có thể được gọi là hệ điều hành, ví dụ, DllMain () hoặc trong một back-gọi Windows. Gọi xlfCaller trong hoàn cảnh này là không cần thiết và có thể có hậu quả không mong muốn và kỳ lạ. Lưu ý rằng một số chức năng được tích hợp trong | Accessing Excel Functionality Using the C API 281 Note The trapped keyboard event is based on the physical keys pressed as mapped for the geographical settings rather than the character interpreted by the operating system. For this reason pressing the Caps Lock key is itself a keyboard event. Pressing say the A key will always return lowercase a regardless of the Caps Lock state. If you want to trap Ctrl-a you would pass the string Aa . If you pass the string A you will need to press Ctrl-Shift-a on the keyboard even if Caps Lock is set in other words the strings A and a are equivalent. Trapping a recalculation event xlcOnRecalc Overview Instructs Excel to call a specified command whenever Excel is about to recalculate the specified worksheet provided that this recalculation is a result of the user pressing F9 or the equivalent via Excel s built-in dialogs or as the result of a change in worksheet data. The command is not called where the recalculation is prompted by another command or macro. Unlike other event traps there can only be one trap for this event. Enumeration value 32995 x80e3 Callable from Commands only. Arguments 1 SheetRef A string of the format Sheet1 specifying the sheet to which the event applies. 2 Command The name of the command to be run as passed to Excel in the 4th argument to xlfRegister or the name of some other command macro or VB function. If SheetRef is missing the command is run whenever this event occurs on any sheet. If Command is missing the function clears the command associated with this combination of event and sheet. Trapping a window selection event xlcOnWindow Overview Instructs Excel to call a specified command whenever Excel is about to switch to the specified worksheet. The command is not called where the switch is the result of actions of another command or macro or as a result of a DDE instruction. Enumeration value 32906 x808a Callable from Commands only. Arguments 1 WindowRef A string of the .