Issue with double click on partially visible rows at the bottom of the Spread

Posted by: vidhyadevi on 8 September 2017, 3:12 pm EST

  • Posted 8 September 2017, 3:12 pm EST

    Prerequisite: When a row is partially visible in the bottom of the Spread and has vertical scroll bar.

    Action performed: Double click in any column of that partially visible row.

    Actual Behavior: 1. The vertical scroll bar moves little bit down, making that row fully visible.
    2. Single click event fired to the actual row clicked, followed by double click event fired to the row below the actual double-clicked row.

    Expected Behavior: Double click event to be fired to the actual partially visible row not the below one.

    How do we avoid this misbehavior of the events being fired?
  • Replied 8 September 2017, 3:12 pm EST

    Hello,

    I tested the given issue with latest version 7.35.20132.1 and it worked properly at my end i.e. when I double click on the partially visible row then the same partially visible row enters in edit mode and it becomes fully visible. Also, the CellDoubleClick event fires for the same partially visible row.

    Could you kindly check with the latest version and let me know if I missed out something .

    regards
  • Replied 8 September 2017, 3:12 pm EST

    Hi Ashish,

    Thanks for your reply.

    We are using Spread 6. Can you please confirm if this was a bug earlier and got fixed in the higher versions?

    Thanks.
  • Replied 8 September 2017, 3:12 pm EST

    The two events which we are handling are as below:
    1. CellClick event is fired to add a '+' symbol on that particular cell
    2. CellDoubleClick event is fired to open up a dialog with the details of that particular row

    So now when I double click on a partially visible row, '+' is added to the row i and dialog is opened for i+1 row after the auto scroll of the vertical scroll bar.

    Is there any workaround to fix this issue?
  • Replied 8 September 2017, 3:12 pm EST

    Hello,

    As per your response, I checked this issue with the latest version of Spread 6 i.e. 6.0.3507.2008 and the events were fired correctly for the partially visible row. Could you kindly check the attached sample and let me know your observations ?

    The latest version is available at:
    ftp://ftp.fpoint.com/SpreadNet6/spreadnetfullinstall.zip

    Regards

    2013/12/Spread_PartialRow.zip
  • Replied 8 September 2017, 3:12 pm EST

    I couldn't reproduce this issue in the attached sample.

    We are using in VC++,
    ON_MESSAGE(SSM_CLICK, OnSpreadClick)
    ON_MESSAGE(SSM_DBLCLK, OnSpreadDoubleClick)
    to fire events and execute the event handlers.

    SSM_CLICK & SSM_DBLCLK are different from CellClick & CellDoubleClick ?
  • Replied 8 September 2017, 3:12 pm EST

    Hello,

    Please let us know if you are using Spread for Win Forms or is it Spread for COM.
    I would suggest you yo check for Edit start event instead of Double click event in order to get to know the correct row index. It applies to both windows and COM version because Double Click would get Spread into Edit Mode.

    If it is Spread for WinForms please provide me a sample application to debug it further.

    Thanks,
    Deepak Sharma
  • Replied 8 September 2017, 3:12 pm EST

    It's Spread for COM.

    Or is there any way to stop the vertical auto scroll when the partial row is clicked?
  • Replied 8 September 2017, 3:12 pm EST

    Hello,

    The partial visible row gets the double click event. You can get the row index in double click event and
    to stop scrolling you may catch the TopLeftChange event and set the NewTop =OldTop.


    Thanks,
    Deepak Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels