none
VSTO Excel Addin - Interaction with other addins or macros RRS feed

  • Question

  • Hi i've developed an addin that writes spedific data into each worksheet footer.

    On our development/testing environment works as a charm, but when i tested using the customer pcs in some of them (3/20) has strange behavior.

    I discovered that each time i do 

    _sheet.PageSetup.RightFooter = "My Footer Text";

    takes about 2 seconds to complete the action.(in normal conditions is nothing... less than 0.5 sec)

    It become a very heavy overhead when it has more than 5 sheets.

    Seems like another event/action is performed.

    So i have some questions...

    1) Is there any way to see if setting a text to the footer trigger something?

    2) Could it be a macro? XLA or XLAM, another addin?

    3) I is there a way to compare software related condition? any clue what should i have to compare? office service pack? vsto environment? what?

    Im using Visual Studio 2010 and Office 2010.

    I appreciate any help.

    Thanks in advance.



    • Edited by Holden-ar Thursday, July 25, 2013 2:52 AM
    Thursday, July 25, 2013 2:50 AM

Answers

  • i can only think of heavy duty approach - copy windbg to that machine, attach to excel process, set breakpoint on your function that sets footer and single step debug from there - see what gets called and compare it to your machine's results (the same step debugging with windbg)
    Thursday, July 25, 2013 6:32 AM