OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Add New Functionality: Sort by Color

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
AnthonyOOo
Newbie
Newbie


Joined: 05 May 2012
Posts: 2

PostPosted: Sat May 05, 2012 12:55 pm    Post subject: Add New Functionality: Sort by Color Reply with quote

How to I request a new feature? Or hire someone to build an add-on feature?

I need to be able to sort by color the way you can in Excel--by cell color or text color.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 05, 2012 1:11 pm    Post subject: Reply with quote

No, Excel can not sort by color. It requires a macro or add-in in any case. Basically this requirement is nonsense since there are thousands of color shades. A red color can be different from another red color without visual evidence.
*ALL* spreadsheet programs calculate, sort and filter by data and nothing but data. If you hide your information behind formatting attributes that is your individual mistake. Which crude requirement comes up next? Sorting by border thickness multiplied by font height?
Entering data in cells and then apply conditional formatting based on the data is by far easier, more efficient and you get the same result. You would sort by values which includes the conditional formatting (color or whatever combination of attributes).
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
AnthonyOOo
Newbie
Newbie


Joined: 05 May 2012
Posts: 2

PostPosted: Sat May 05, 2012 1:44 pm    Post subject: Reply with quote

Villeroy, you are wrong. I sort by color everyday in Excel.

Does anyone know how to request a new feature? Or hire someone to build a plug-in for it?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 05, 2012 1:53 pm    Post subject: Reply with quote

AnthonyOOo wrote:
Villeroy, you are wrong. I sort by color everyday in Excel.

Does anyone know how to request a new feature? Or hire someone to build a plug-in for it?

You have installed an extension or you are using Excel 2010. After 2 decades MS Excel subjected to its most stupid users.
When this software implements this bullshit it's be time to remove it from my disk. So I won't post the 4,978th link to the bug tracker. Instead I recommend to use MS Excel.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group