Posted 8 September 2017, 2:21 pm EST
While working with .net Farpoint spread , version 5 , I found the following issue.
Issue: When the leading columns in a spread are hidden , and the user tries to scroll across the remaining columns ( form width is such that the last column of spread is visible partially) by clicking on the "scroll far" (Zip) button , the scroll does not work. However when the user clicks on the scroll bar (shaft) the scroll works without any issue.
In my sample WindowsForm application containing a farpoint spread , the issue could be easily seen by adding the below sample code. The horizontal and vertical scroll policy is set to "as needed" and smallchange is set to 1. The scroll bar button set to Lineupdown and thumb.
this.fpSpread1_Sheet1.ColumnCount = 5;
this.fpSpread1_Sheet1.SetColumnLabel(0, 0, "1");
this.fpSpread1_Sheet1.SetColumnLabel(0, 1, "2");
this.fpSpread1_Sheet1.SetColumnLabel(0, 2, "3");
this.fpSpread1_Sheet1.SetColumnLabel(0, 3, "4");
this.fpSpread1_Sheet1.SetColumnLabel(0, 4, "5");
This looks to be a farpoint spread issue related to scroll positions however I am still unclear on the rootcause of this issue.
The possible work around I found would be :
1. Making the first two columns visible solves the issue without any changes to UI and the scroll buttons work as expected.
2. This issue can also be fixed using the farpoint spread's scrollbar buttons PageUpdown or HomeEnd along with Lineupdown and thumb, however this is will result in changes to UI where the icons for the scroll bar buttons change.
Can any of you please let me know if you have encountered such issue.