GrapeCity Forums

Hi,

After sorting the webspread ascending or descending,the formulas giving wrong result,

and there is a function which delete the row does'nt work right after sorting.

So what to do and how to do,I know there are two types of coordinates in your spread,

but how can I use it in sorting that it start working fine.

I beg to u please help me to remove this problem.if u provide me a sample than it is great for me.

Hello Pradeep, 

Are you working with CustomSorting? I've created a sample application, in which I've enabled Sorting by clicking on the Smarttag located at the top right corner of the control and checking the "Allow sorting" option.

Using the Spread Designer, I've added 3 rows and 3 columns and set the Cell type of all the 3 columns to Integer. In Colum A and B I've entered some arbirary integer values and then I've set the formula for Column C, =Sum(A1,B1). I've also enabled "Allow Inserting" and "Allow Deleting". Finally, I've set ClientAutoCalculation property of the spread to true. 

I am successfully able to sort the columns and getting correct values for formulaes. I am able to insert new rows and delete existing rows and everything is working as expected. 

I am using the latest build of Spread for ASP.Net version 4.0.3506.2008

Attached is the sample.

Regards, 

Hi Harish,

I am using the sorting on a button click.and the spread is fill by a

datatable.I am binding the datatable with the spread.and write the button handlers for

sort ascending and descending.so after sorting its view coordinates are changed but using formula or anything

it is not providing the right result.

Mostly work is done on server side.so if provide me that how to bind those coordinates with the spread, so that after sorting it will

right answer.

Thanks.

Hello,

If you use the SortRows method of the Spread to sort the data, then the view coordiantes of the data is what is sorted to make this process as fast as possible. But as you noticed this causes issues if you are writing code using model coordinates. Formulas are using model coordinates automatically. If you were to use the Sort method instead of the SortRows method, then the DataModel is what is sorted and so the DataModel and ViewModel coordiantes would be in sync. However, this method would be slower to run in order to sync everything.

Hi Scott,

I am using spread 7 com component. I am facing problem to sort date type column. can you please help me... and from where I can find documentation for spread 7 com component.

thanks,

ajai  

Ajai,

You have posted the Spread COM issue to our Spread for ASP.net section. In the mean time, you may download the trial version of Spread 7 (COM) from following location and with it you will also get the control documentation installed on the machine.

http://www.clubfarpoint.com/FarPointSupportSite/Modules/Download/updates.aspx

Thanks