Issue with the Scroll Bar

Posted by: vishwa123 on 8 September 2017, 2:31 pm EST

  • Posted 8 September 2017, 2:31 pm EST

     

    Hi,


    I am facing one issue with the scroll bars of parent and child views of the farspread control.


    Situation:


    I have four rows(Parent rows we can say) in the farspread control.


    Each parent row has a child view associated with it and can have variable number of rows.I have enabled the vertical scroll bar policy of parent set to "Asneeded".


    Problem:


    When I expand the parent rows through the "+" sign and the data content overflows out of the sheet then both parent as well as child vertical scroll bars will appear for showing the overflown data.When I scroll down the parent vertical scroll bar for seeing the overflown data the height of the parent vertical scroll bar(Scroll Box) is automatically decreasing(It should remain the same while scrolling) as you scroll down and disappearing eventually.               


    Please find the attached screen shots for the reference and let me know your thoughts on this.


    Regards


    Vishwa


    2010/12/Scroll Bar Issue.zip
  • Replied 8 September 2017, 2:31 pm EST

    Vishwa,

    We are able to replicate the issue and have reported it as a bug in Spread 5 latest build and the bug number for the same is #99919471. It will be fixed in future maintenance build of Spread.

    Thanks.

  • Replied 8 September 2017, 2:31 pm EST

     

    Reeva,


    Is there any work around available for this issue?Please let me know it would be of great help.


    Thanks and Regards


    Vishwa

  • Replied 8 September 2017, 2:31 pm EST

     

    Thanks......


    --Vishwa

  • Replied 8 September 2017, 2:31 pm EST

    Hi,


     


     Please let us know wheather the next maintainance release is available now.... so that we can check the functionalities.


     


    Thanks and Regards,


    Vishwanath K

  • Replied 8 September 2017, 2:31 pm EST

    Hello,

    I tested this issue again with the latest build of Spread 5 which is spread version 5.0.3518.2008 and now I am unable to replicate the issue at my end. Please have a look at the attached sample for the same.

    Let us know your further observations on the same. Thanks.


    2011/05/Scroll Bar Issue.zip
  • Replied 8 September 2017, 2:31 pm EST

    Thanks Reeva!!


    I have tested the 5.0.3518.2008 version of farspread control and found that the scroll bar issue is resolved.


    Originally we had version 4.x.x of the farspread. Since Version 4 product key and serial number did not work for the version 5.0.3518.2008, so we have installed the trial version of the release and found the below issue.


    In our application we have table cells which contain hyperlinks. Upon clicking of the Hyperlink we are getting the below .NET Framework Exception, Exception text is pasted below.


    ************** Exception Text **************
    System.Exception: Exception handled in FpSpread.WndProc ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
       at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
       at System.Diagnostics.Process.Start()
       at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
       at System.Diagnostics.Process.Start(String fileName)
       at FarPoint.Win.FpHyperlink.OnMouseDown(MouseEventArgs e)
       at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at FarPoint.Win.ControlBase.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at FarPoint.Win.Spread.SpreadView.a(Control A_0, MouseEventArgs A_1)
       at FarPoint.Win.Spread.SpreadView.StartCellEditing(EventArgs e, Boolean formula)
       at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, MouseEventArgs A_2)
       at FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
       at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, MouseEventArgs A_2)
       at FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
       at FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
       at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
       --- End of inner exception stack trace ---
       at FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    Please can you help us regarding this issue.


     


    Thanks and Regards,


    Vishwanath K

  • Replied 8 September 2017, 2:31 pm EST

    Hello,

    May I know what code are you using to set the hyperlinkcelltype? I have created a sample for which has spread with a hyperlink cell please have a look and let me know if I am missing something.

     

    Thanks,

     

     


    2011/06/HyperLinkCell.zip
  • Replied 8 September 2017, 2:31 pm EST

    Unfortunately, I didn't find any workaround for the same as of now. 

Need extra support?

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

Learn More

Forum Channels