Child view performance with latest fp spread

Child view performance with latest fp spread

Posted by: ghiebert2 on 8 September 2017, 2:30 pm EST

• 

  ghiebert2

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:30 pm EST

  I upgraded to the latest Spread for Windows Forms v5 (5.0.3514.2008). Now in my application that was working before the upgrade it just hangs if I loop through the rows in the ChildViewCreated event and set a cell's text.  As soon as I comment out the 1 line in my code that sets that column's text, it loads fine.

  
  

  Also on a 3rd level child view, on the ChildViewCreated event, I am setting column widths and headers and then looping through the rows in that child view to set a column's value.  The column formatting only "sticks" on the last expanded child view.  All the other currently expanded 3rd level views revert back to the default column widths.  If I don't set any cell's text in the child view the formatting doesn't mess up. 

  
  

  Both of these bits of code worked fine with my previous version of Spread (5.0.2003).  Upgraded to 5.0.2014, got the strange behaviour and then tried using the .net 3.5 5.0.3514, but still the same things happening.

  
  

  Was using this in VB2008.net, but upgraded a copy of the project to VB2010.net just but it's still doing the same thing.

• 

  ghiebert2

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  I can send you the whole vb.net project if you like, but don't know where to send it as I can't attach a file here.  I'm not sure if just listing a few lines of code is going to help you solve the issue.

• 

  reeva

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  Hello,

  To attach the sample file, when you reply to a post there is an Options tab at the top of the message
  under the header.  If you click that then you can add the attachment. Make sure it is zipped and less than 256k, else you can mail the project to us at powersupport@grapecity.com with the forum post id in subject.

  Thanks.
  

• 

  ghiebert2

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  Attached is a very simple example derived from my bigger vb 2010 project.  Whenever I enter data in one of the cells, after the grid has been populated from the dataset, and I try to move to another cell, the cpu gets pegged and the application hangs.  This has only started happening after I upgraded to the latest FP Spread for Windows Forms.

  
  2010/11/WindowsApplication1.zip
  
• 

  ghiebert2

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  I forgot to add another performance issue.  If I leave previously expanded 3rd level child views open, then when I try to expand the 4th, 5th or higher 3rd level child view, it's takes longer and longer to open each subsequent view.
• 

  reeva

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  Hello,

  Can you please send us your sample replicating the issue showing how are you setting up column's width, headers, and child rows column's value and for performance related issue, we again need your sample in order to provide you with performance increasing measures. Please provide us with the sample for us to debug at our end and provide you with assistance.

  Thanks.
  

  <div class="ForumPostBodyArea"><div id="_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl1_PostViewWrapper" class="ForumPostContentText">

  
  

  
  
  
  </div>
  </div>

   

• 

  reeva

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  Hello,

  Can you send me the running application for the same having database too because it shows me this error "Cannot connect to database server - a272sm25"

  Thanks.
  

• 

  ghiebert2

  • Post Options:
  • Link
    Copy

  Replied 8 September 2017, 2:30 pm EST

  Never mind, I figured it out.....finally.  I set the Autocalculation to False on the child views and now the performance is back to where it was before this last version of FP Spread.