stop refreshing the farpoint spread sheet

I have a problem with farpoint spread sheet, that while loading the data into the spread sheet, the sheet refreshes each time a value is set.

I have large number of rows and columns so, the sheet take quite large time till loading.

any idea how to disable the refresh and enable it again after the data is completely loaded.

Thanks in advance.

Answers


I Got it, just suspend the layout of the spreadsheet, then resume after executing your code.

FpSpread.SuspendLayout()

' your code

FpSpread.ResumeLayout(True)

Need Your Help

Upload files with Apache

html c apache http

I'm writing a CGI program in C to get an uploaded file through HTTP multipart/form-data.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.