Form with a Gridview is very slow when used in the AddIN compared to within an Application

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

Form with a Gridview is very slow when used in the AddIN compared to within an Application
 
AdamK




Posts: 25
Joined: 2014-03-09
I use the same form from a shared Project within an application and the AddIn
Both function properly but the speed difference is very noticeable

Within the Application and the Gridview has over 5000 rows it takes under a second to filter the rows
Within the Addin called the same way and when the row filter happens it takes almost 10 seconds

What would I need to look at that may be causing the issue?

I have a text box that can be typed into and it applies a filter to the gridview
From a standard vb.net application, this is quick compared to when the same form is used within the AddIn
Posted 08 Mar, 2020 23:09:44 Top
Andrei Smolin


Add-in Express team


Posts: 17178
Joined: 2006-05-11
Hello Adam,

I wonder if your Office version is Office from Windows Store. Check https://www.add-in-express.com/creating-addins-blog/2019/02/27/office-from-store-issues/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Mar, 2020 03:34:20 Top
AdamK




Posts: 25
Joined: 2014-03-09
It's an Office 365 not installed from the Store.
I am going through the code to ensure it isn't something I have done to slow it down just to be sure
Posted 15 Mar, 2020 23:53:11 Top
Andrei Smolin


Add-in Express team


Posts: 17178
Joined: 2006-05-11
Hello Adam,

Please provide some code for me to test it; send it to the support email address, if you can.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 16 Mar, 2020 04:15:42 Top
Andrei Smolin


Add-in Express team


Posts: 17178
Joined: 2006-05-11
Hello Adam,

At https://insider.office.com/en-us/releasenotes/pc/fast, I've found the following fix:

We fixed an issue that was causing delays when users were programmatically editing a large range of cells.


Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 18 Mar, 2020 16:52:40 Top