Copy-paste works, Cut-Paste doesn't

Add-in Express™ Support Service
That's what is more important than anything else

Copy-paste works, Cut-Paste doesn't
 
Abhijeet S




Posts: 12
Joined: 2017-03-27
I referred this article : https://www.add-in-express.com/forum/read.php?FID=5&TID=12832

I want to capture Cut, Copy, Paste events.

I have added all methods as suggested in the article.

Copy-paste works fine but not Cut-paste.



        private void _excelEvents_CommandBarsUpdate(object sender, EventArgs e)
        {
            //Check for copy paste events.  
            if (_CutCopyMode != ExcelApp.Application.CutCopyMode)
            {
                _CutCopyMode = ExcelApp.Application.CutCopyMode;
                _CutCopyRange = _CutCopyMode == XlCutCopyMode.xlCopy || _CutCopyMode == XlCutCopyMode.xlCut
                                    ? ExcelApp.Selection as Range
                                    : null;
            }
        }

        private void _excelEvents_SheetChange(object sender, object sheet, object range)
        {
            try
            {
                var range1 = range as Range;
                //....


When I press Ctrl+C (copy), _excelEvents_CommandBarsUpdate method is called and after I press Ctrl+v(paste) _excelEvents_SheetChange method is called. Everything works fine as expected.

But same doesn't work with Cut(Ctrl+x), Strage.
When I press Ctrl+x, _excelEvents_CommandBarsUpdate method is called and after I press Ctrl+v(paste) _excelEvents_CommandBarsUpdate method is called again and not _excelEvents_SheetChange method.

Please help.
Posted 04 May, 2017 20:36:24 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Hello Abhijeet,

Excel build number?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 May, 2017 01:43:56 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
Product : Add-in Express for Office and .NET (ver. Addin Express version 8.6.4408 )
OS : Windows 10
Host application : Excel 2016
IDE : Visual Studio 2015
Posted 05 May, 2017 02:40:37 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
Microsoft Office Professional Plus 2016
Version 1703 (Build 7967.2139 Click to Run)
Posted 05 May, 2017 02:44:39 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Please send me some code to the the support email address; you can find it in {Add-in Express installation folder}\readme.txt. Please make sure your email contains a link to this topic.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 May, 2017 03:16:14 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
Hello Andrei,

I have sent you AddinModule.cs file. Please let me know if you need anything.

thanks.
Posted 05 May, 2017 03:43:07 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
I've created a test project based o your code and I can't reproduce the issue. I've sent you a download link for the project by email. If the issue is reproducible on your side, I'll need to have an exact scenario. Make sure you have all other COM add-ins disabled.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 May, 2017 06:32:47 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
Hello Andrei,

I had sent you sample project along with a workbook which has this problem? Any news

Thanks.
Posted 08 May, 2017 05:43:04 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
Hello Andrei,

I know I am following up on this sorry but I am stuck on this problem.
Are you able to reproduce the issue now?

Abhijeet
Posted 09 May, 2017 02:08:20 Top
Abhijeet S




Posts: 12
Joined: 2017-03-27
I haven't heard back on this. I already have sent you scenario which will help you reproduce the issue?
Were you able to reproduce the issue? At least reply to me!
Posted 10 May, 2017 06:56:45 Top