Sort by Cell Background Color?

Aspose.Cells Product Family
1

Do you know the Excel feature where you can sort based on a cell’s background color? Is that possible with Cells?

I have been digging around but not found it anywhere.

Thanks, Mitch

2

@mitch_milam,

Thanks for your query.

This feature is currently not available however we need to look into it more. We have logged the issue in our database for investigation and for a feedback. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46500 - Sort by cell background color
3

Thanks! That would be a great enhancement and one that would put Cells more on-par with Excel - and I use this feature all of the time with Excel.

4

@mitch_milam,

You are welcome. We will analyze it thoroughly on its turn and share our feedback at the earliest.

5

@mitch_milam,

We have noticed that it only moves the cells with selected background color to top or bottom, other cells only moves down or up and their colors are ignored. We will support this feature later, and it will work same as MS Excel.

6

@mitch_milam,

Please try our latest version/fix: Aspose.Cells for .NET v18.12.3 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells18.12.3 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells18.12.3 For .Net4.0.Zip (4.7 MB)

7

The issues you have found earlier (filed as CELLSNET-46500) have been fixed in Aspose.Cells for .NET v19.1. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi