Keeping a cell with the Specific Data at Last

Aspose.Cells Product Family
1

Dear Team,

I’m trying to Sort The Data. Which is working Perfectly fine .
And If I need some Specific Data to be on top I give it as
sorter.add(0,SortOrder.ASCENDING,"to be top Data");

But What Can I do For the Data to be always on the Bottom of the Sorting Range I have to Sort.
For Eg: I have a cell Value with Total as its data. I want this row to always come at the bottom
Attaching a Sample Screen Short and a File…

ScrrenSHot.PNG (8.0 KB)

SortExample.zip (10.4 KB)

2

@aymarzapak

From your image, the workaround could be that you sort by Col1 and then by Col2 but before that you replace the word “Total” in Col3 to “ZZTotal”. Since letter Z is the last letter, therefore ZZTotal will always be at the bottom or last. Once, you have done sorting, you replace ZZTotal to Total again.

3

Could be done. It’s the total row. I’ll try to add the total row after sorting. I’ll update if I find the fix.

4

@aymarzapak

Sure. Thanks for updating.

5

this thing is working for now. works well as far. No Issues as of Now…

6

@aymarzapak

Thanks for sharing good news with us. If you face any other issue, please feel free to let us know, we will be glad to help you further.