Click here to Skip to main content
15,898,035 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: my strcpy funcution! Pin
Richard MacCutchan11-May-10 5:17
mveRichard MacCutchan11-May-10 5:17 
AnswerRe: my strcpy funcution! Pin
David Crow12-May-10 3:01
David Crow12-May-10 3:01 
QuestionCDialog::PumpMessage hangs (endless WM_PAINT?) Pin
VictorSotnikov11-May-10 3:41
VictorSotnikov11-May-10 3:41 
Questionhow to use select() function with file descriptors on windows Pin
Vijay_Vijay11-May-10 1:04
Vijay_Vijay11-May-10 1:04 
AnswerRe: how to use select() function with file descriptors on windows Pin
Richard MacCutchan11-May-10 2:36
mveRichard MacCutchan11-May-10 2:36 
QuestionHow to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Gaurav171011-May-10 0:28
Gaurav171011-May-10 0:28 
AnswerRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Stuart Dootson11-May-10 0:44
professionalStuart Dootson11-May-10 0:44 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
KTTransfer11-May-10 18:19
KTTransfer11-May-10 18:19 
Hi Stuart,

When cell is inserted, only cell where the new cell is inserted or deleted will be tracked in sheetchange event. But whereas the allignment of data cannot be tracked.

For example: if following is the data before cell insert


c0 c1 c2 c3
r0 1 2 3 4

r1 2 3 4 5

r2 3 4 5 6

If say I have inserted cell at r1c1 then the allignment of data after cell insert will be:

c0 c1 c2 c3 c4
r0 1 2 3 4

r1 2 * 3 4 5

r2 3 4 5 6

* represents blank cell is inserted.

How to track this change in allignment? For above example allignment change data will be:(r1c2:3,r1c3:4,r1c4:5)

Following is the code in sheet change:

_bstr_t result= target->GetAddress(1,1,Excel::XlReferenceStyle::xlR1C1,1,1);

In result we are getting only r1c1.

As of now we are able to do it when user inserts the cell using context menu: right click->insert, this we are tracking in sheetbeforerightclick, where we are setting the bool flag , and immediately in sheet change we are checking the same bool flag for true , if it is true then we are reading that complete row and complete col.But this will not work when user inserts/deletes the cell through menu.

Please guide us to get this change in allingment of data for all the four options: cell insert/delete(shift cells right, shift cells down)/(shift cells up, shift cells left) when user inserts cell either through context menu or menu.

Thanks in Advance,

Regards,
KTTransfer.
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Stuart Dootson11-May-10 23:24
professionalStuart Dootson11-May-10 23:24 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Gaurav171012-May-10 1:34
Gaurav171012-May-10 1:34 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Stuart Dootson12-May-10 2:01
professionalStuart Dootson12-May-10 2:01 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Gaurav171012-May-10 2:04
Gaurav171012-May-10 2:04 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Stuart Dootson12-May-10 2:15
professionalStuart Dootson12-May-10 2:15 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
Gaurav171012-May-10 2:17
Gaurav171012-May-10 2:17 
GeneralRe: How to Track the event in Excel for cell insert/delete in C++ or VC++ for ? Pin
KTTransfer13-May-10 1:04
KTTransfer13-May-10 1:04 
Questioninclude directory Pin
john563211-May-10 0:23
john563211-May-10 0:23 
AnswerRe: include directory Pin
Stuart Dootson11-May-10 0:47
professionalStuart Dootson11-May-10 0:47 
Questionconvert mjpeg to mpeg4 Pin
gmallax10-May-10 23:51
gmallax10-May-10 23:51 
AnswerRe: convert mjpeg to mpeg4 Pin
«_Superman_»11-May-10 7:42
professional«_Superman_»11-May-10 7:42 
QuestionHow to register a dll on Window 7 machine. Pin
pandit8410-May-10 20:39
pandit8410-May-10 20:39 
AnswerRe: How to register a dll on Window 7 machine. [modified] Pin
_AnsHUMAN_ 10-May-10 21:47
_AnsHUMAN_ 10-May-10 21:47 
QuestionRe: How to register a dll on Window 7 machine. Pin
pandit8411-May-10 0:02
pandit8411-May-10 0:02 
AnswerRe: How to register a dll on Window 7 machine. Pin
Electron Shepherd11-May-10 2:49
Electron Shepherd11-May-10 2:49 
QuestionCreate Visual Studio Project Pin
Game-point10-May-10 19:51
Game-point10-May-10 19:51 
AnswerRe: Create Visual Studio Project Pin
Richard MacCutchan10-May-10 21:21
mveRichard MacCutchan10-May-10 21:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.