Vertical scrolling very slow with many rangegroups

Posted by: escs-fpoint on 8 September 2017, 1:39 pm EST

  • Posted 8 September 2017, 1:39 pm EST

    Hello,

    we have a sheet with about 400 or more rows with nearly all rows in rangegroups of some rows, so we have e.g. about 70 rangegroups of rows. The vertical scrolling with the mouse is very slow, the visual effect is that you seem to see the same row multiple times until all rows are painted new. If you use the arrow-keys to step from one cell to another, you have to wait one or two seconds after one keypress to step to the next cell. Without the rangegroups the scrolling works fine and you can step through the cells with the arroy-keys without delay. The number of columns is without influence to this behaviour.

    Is there a possibility to increase the scrollingspeed while having the rangegroups?

    Greets,

    Ulrich

     

  • Replied 8 September 2017, 1:39 pm EST

    We use the following statements:                           

    ActiveSheet.AddRangeGroup(RowIndex + 1, lRowCounter - RowIndex - 1, True)                          

    ActiveSheet.RangeGroupBackgroundColor = System.Drawing.SystemColors.Control                           

    ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced

    All rangegroups are on the same level, no interlaced rangegroups. So for example rows 10 to 13 are grouped together, rows 14 to 16, rows 17 to 20 and so on.

  • Replied 8 September 2017, 1:39 pm EST

    How are you setting up the range groups?  I am not seeing this behavior.
  • Replied 8 September 2017, 1:39 pm EST

    Here is a testproject. If you show the sheet with/without rangegroups you should get the difference if you scroll through the sheet or use the arrowkeys.

    (I hope that the project is really attached)


    2008/12/WindowsApplication3.zip
  • Replied 8 September 2017, 1:39 pm EST

    I set up range groups covering three rows each for all 400 rows and I do not see any degradation in the scrolling.  Make sure you have the latest maintenance release.  If you do can you attach a small project showing this for us to debug?
  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    bad news, with the Version 05.00.2005 of Spread for Windows Forms for 2.0 Framework (VS2005)
    5 this effect is back! Again the scrolling with many rangegroups is very slow, and if you select one cell and click or doubleclick in another cell, you have to wait two or three seconds until the cell becomes the activecell or gets into editmode, the same effect while stepping through the cells with the arrow-keys. This is very dissapointing. I'm wondering about it, because you fixed this problem in the version 4...., I think.

    Greetings,

    Ulrich

  • Replied 8 September 2017, 1:39 pm EST

    This has been fixed and is pending release.  We just did a maintenance release toward the end of the year.  I am not sure when the next one will come out but it should be in the first quarter of this year.
  • Replied 8 September 2017, 1:39 pm EST

    Ok, so my question is: Will it be fixed in the next update and when will be the next update? 

  • Replied 8 September 2017, 1:39 pm EST

    I was able to reproduce this and will write it up as a bug.
  • Replied 8 September 2017, 1:39 pm EST

    Hello Ulrich,


    I have forwarded your request to our project management team requesting the fix of this issue. Will update you soon about the same.


    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    I am not able to replicate this issue with a blank Spread while I have enabled selecting multiple ranges of cells. I am using Spread 5 latest build (5.0.2005.2005).I click on a and then selected another cell by clicking/double clicking on it and it gets selected in a fraction of second(no 2-3 seconds).I would request you to please test it with the same build and post a zipped sample application for us to debug if you are still able to replicate this issue.

     

    Thanks,

     

  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    we are using already the buildversion 5.0.2005.2008 from the update of 4/12/2010. But I can try to make a sample application.

     We have another problem with the actual version. The saving to an excel-file with the  method  SaveExcel of the spread is very slow, too. For example I tested it with a spread with two sheets, the first wtih 650 rows and 17 columns, the second with 0 rows and 17 columns. It took about 6 minutes (!) to save the excelfile. We have never had this behaviour in any earlier version of spread for windows. A workaround is to set the spread visible = false befor the saving and afterwards back to visible. Then the savingprocedure is much faster, but this could not be the final way, I think.

    Greetings,

    Ulrich

  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    I am again not able to replicate the said behavior using Spread 5.0.2005.2008. 

    Here is what I did

    1. Created a Spread with two sheets.

    2. Sheet[1] contains 700 rows and 17 columns and Sheet[2] contains 0 rows and 17 columns.

    3. I filled all the cells with values such as "i+j".

    4. I exported the spread to Excel using fpspread1.saveExcel() method.

    5. The spread gets exported to excel in  less than 2 seconds.

    I have attached an image that shows the time taken to export to excel and the exported excel file as well.Please have a look and let me know if I am missing something.

     

    Thanks,

     


    2010/06/SlowExport.rar
  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    I think, I have found the problem. If you have a sheet
    with some use of notes for the cells, it slows down dramatically, the
    saving as excel and the scrolling, navigating and editing in the
    spreadsheet is nearly impossible. I have added a testapplication where
    you can check this problem.

     Greetings,

     Ulrich
    2010/06/WindowsApplication2.zip
  • Replied 8 September 2017, 1:39 pm EST

    Hello Ulrich,


    I am able to replicate the issue using your sample and the time taken for saving and scroling Spread doesn't seems to be resonable due to cell notes being set on cells as that feature requires lots of text width calculations on each change to the data in a cell. However, i have reported it as bug #99916727 in Spread.


    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    so our problem is, that our customer works with this state of the spread in our application and is constricted in his working very much. So I think you understand that we need an updateversion with smoother properties very urgent. Can you give us at least a time frame in which an update for this version of spread for windows forms is planned to make?

    Greetings,

    Ulrich

  • Replied 8 September 2017, 1:39 pm EST

    Ulrich,

    Our Project Management Team has already started working on the reported bug and since it requires some big changes to be made in Spread, hence we need some more time for the same. Will try to provide you with the hot-fix as soon as it will be fixed.

    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Hello again,

    I know that you have written that you will inform us, if the problem isf fixed, but more than a month has passed without any information so I think that it ist ok if I ask again about a solution of the problem because  we still need it and we need it and we need it badly! So please do not let us down. We hope for your help.

    Greetings,

    Ulrich

  • Replied 8 September 2017, 1:39 pm EST

    Hello Ulrich,


    Currently there is no ETA regarding the same, its still in progress. Will update you once it will be fixed.


    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Hello,

    now we have updated with the newest update to version 5.0.2011.2008 the problem still remains. In the testapplication that I have attached some messages ago you can prove it. It seems that the use of grouping and notes together does not work correctly. If you use only one of these things, the editing and scrolling seems to work in an acceptable way, but if you use both together, it is nearly impossible to edit or scroll the data.The saving-problem also still exists. If you use notes for about 10% of the cells or more then the saving to excel slows down dramatically.

    We need a fast solution for this problem and can't wait until a new update-release. So I hope you can provide a hotfix so our customer can work again with the spread as he did in the earlier version 4. There seems to be a change from version 4 to 5 that caused this problem. All these problems came with version 5.

    Greetings,

    Ulrich

  • Replied 8 September 2017, 1:39 pm EST

    Hello Ulrich,


    Our project management team is trying to fix this issue, and hopefully it will be fixed in the upcoming release else will try to provide you with a hotfix for the same soon and there will be a new v5 maintenance release in about two weeks.


    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Ulrich,

    We are ready with the hot fix build for your critical issue and they have been posted at the below mentioned location. However, these
    builds are not fully tested and not intended for redistribution. They are intended to use for verifying the fix only and for development and testing purpose until
    the next maintenance release is out which is scheduled to be out about 4 weeks from now.

    ftp://ftp.fpoint.com/transfer/EN_SPREAD_WINFORMS_RA_5.0.2013.4828.zip

    ftp://ftp.fpoint.com/transfer/EN_SPREAD_WINFORMS_RA_5.0.3513.4828.zip


    Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Ulrich,

    I have put forward your request to know the status of the same. Will update you soon. Thanks.

  • Replied 8 September 2017, 1:39 pm EST

    Ulrich,

    The above mentioned links are working fine at my end, transfer folder is hidden, you just copy-paste the complete link in your browser and you will get a prompt to download it. If it doesn't help then
    please let me know your Email Address so that we can mail you the same.

    Thanks.
  • Replied 8 September 2017, 1:39 pm EST

    Hello again,

    I tried to download the zip-files about two weeks ago, but it failed. The last two weeks I didn't have the time to try it another way. Today I tested the links with an ftp-client to download the zip-files, but the folder "transfer" seems to be empty. Could you please check it and prepare the hotfix for download, maybe with a link in the answer here? Thanks.

     Greetings,

    Ulrich

     

Need extra support?

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

Learn More

Forum Channels