none
VSTO List Object Handling Data Type Validation RRS feed

  • Question

  • Hi,

    I am using LIST Object and binding with a data source.

    My problem is let's say after binding the data into list object my data type for each column is integer. Now if i am trying to insert integer value in cell it's normally get truncated automatically. how to handle it in excel code.

    What i want to do is show a warning message (Tool tip on cell) with different border color  if data type violate the rules against the one which is created previously.

    Any help would be appreciated.

     


    K K Sanghi
    Wednesday, February 1, 2012 6:41 AM

All replies

  • Hi K,

     

    Thanks for posting in the MSDN Forum.

     

    Would you please clarify your Excel version and VSTO runtime version for further research?

     

    In my opinion, I’m confused with your description. I don’t think Excel will truncate your integer value as normal. I suppose you use specific cell format there. However I can’t receive any information about your Excel cell’s format. Please clarify it.

     

    I would recommend you provide me a snippet to reproduce your issue. It will give me more help to understand what your said.

     

    Have a good day,

     

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Thursday, February 2, 2012 9:45 AM
    Moderator
  • Hi M,

    Sorry for the minor mistake and the for the description which is not clear.

    Excel : 2007/2010

    VSTO Run Time : 3.5 / VS 2008

    Scenario Steps :

    We have a list object, for binding i am using data source. Now While Binding Let's say all column is of type integer.

    Now if you try to insert some string which will be truncated automatically. How to avoid it ?

    Let me know still if i am not clear.

    I have another problem Related to LIST Object if you won't mind can u look into

    http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/1fe7d29d-7d98-40c2-964c-4d2c3d2f2db5

    Regards

     


    K K Sanghi
    Thursday, February 2, 2012 3:08 PM
  • Hi K,

    I have replied at http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/1fe7d29d-7d98-40c2-964c-4d2c3d2f2db5

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Friday, February 3, 2012 7:08 AM
    Moderator
  • Hi Tom,

     

    I replied too can you have a look @ last post.

    http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/1fe7d29d-7d98-40c2-964c-4d2c3d2f2db5


    K K Sanghi
    Monday, February 6, 2012 10:05 AM