Hi Vasanti
This is behaviour that is to be expected, the renderer cannot know on which page of the dataset you want to start. It sorts the whole data set. Normally you want rows from other pages to fit in nicely in your newly ordered table...
If you want to change this behaviour you will have to build custom pagination, that will take some designing
jacob