We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to syncronize viewed the rows of two sfspreadsheets ?

Thread ID:





126335 Oct 8,2016 09:01 AM Oct 11,2016 04:43 AM WPF 3
Tags: SfSpreadsheet
Asked On October 8, 2016 09:01 AM

Hi Sf & users,

I have two SfSpreadsheet, shown left & right (say "SfSpreadsheet_Left" & SfSpreadsheet_Right) containing two different but complementary .xlsx
I would like the two to always display the same rows (but not necessary the same columns)

ie, if the user scrolls on the left, for example to visible rows 6 to 20, I would like the right SfSpreadsheet to scroll automatically to sthe ame rows
And same if user scrolls vertically on the right, the left to update its views
(note of course that I am speaking of the scrolling of the excel grid inside the control, not the native WPF scrollviewer around the control, that scrolls the control itself)

Fo other controls, I see the corresponding event or binding. What should be used for SfSpreadsheet ?
A XAML bindind would be ok for me, but also a code behing with some event solution would be OK
Any help please ?


Kanimozhi Bharathi [Syncfusion]
Replied On October 10, 2016 08:18 AM

Hi Fabrice Pin, 
Thank you for contacting Syncfusion Support. 
We have analyzed your query and prepared a sample based on your requirement. In this sample, you can set the changed scroll value in the Changed event of ScrollRows in active SpreadsheetGrid while scrolling vertically. Please find the Sample link below, 
Kanimozhi B 

Replied On October 10, 2016 10:21 AM

Hi all,

It's a jewel of nested events :
   a workbook event --> grid event --> scrollrows event --> that gets and updates the scroll bar value
very smart & works very good

Kanimozhi & Sf team --> a big THANK YOU to all !


Kanimozhi Bharathi [Syncfusion]
Replied On October 11, 2016 04:43 AM

Hi Fabrice Pin, 
Thank you for your update. 
Kanimozhi B 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.