Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
3555
Copy and Paste to from excel...
posted
Ok,

When I copy from excel 5 horizontal cells and I then paste them into a
grouped by column grid, it doesnt seem to be pasting in order the correct
values. Why would this be? Is it a bug?
  • 3555
    posted
    ok I figured out the problem, just need help with the solution...

    In my aftercellupdate event, I take the one value then a user changes and
    pass it to a stored procedure (which recaluates a bunch of values in the
    backend) and it returns a new datatable, I then merge the new datatable with
    the current one.

    Now the problem is when pasting multiple values it just triggers the
    aftercellupdate on the first changed cell,

    I guess I need to put the aftercellupdate event on hold, gather which cells
    value changed and then loop through my stored proc of those new values. Is
    there a way to do this or a better approach.

    The overall problem with this is the tables in my grids come from pivoted
    stored procedures, thus I cannot use table adapters. Any recalculating all
    of my other grids in code will take way too long (there will be 30 grids).





    wrote in message news:14652@forums.infragistics.com...
    > Ok,
    >
    > When I copy from excel 5 horizontal cells and I then paste them into a
    > grouped by column grid, it doesnt seem to be pasting in order the correct
    > values. Why would this be? Is it a bug?
    >