Bug 60107 - Calc conditional formatting icon sets: Please add smilies :-)
Summary: Calc conditional formatting icon sets: Please add smilies :-)
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.2 rc
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-31 07:50 UTC by Gerry
Modified: 2013-09-21 01:04 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
example-with-thicker-mouths.svg (12.38 KB, image/svg+xml)
2013-03-13 22:42 UTC, Gerry
Details
Smilies with thicker smiles (11.15 KB, image/svg+xml)
2013-09-08 18:17 UTC, Gerry
Details
Smilies with thicker smiles and different colours (13.11 KB, image/svg+xml)
2013-09-08 18:18 UTC, Gerry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gerry 2013-01-31 07:50:49 UTC
Icon sets in the new conditional formatting dialog are great. At the moment, there are just a few different icon sets available. 

Please add "Smilies" to these icon sets, 3 smilies from "Smile" over "Plain" to "Sad".

If license allows it, these smilies-sets on Openclipart fit very well:

Option A:
http://openclipart.org/detail/100759/smiley-by-zorro (the third, the fifth and the seventh in the list)

Option B:
http://openclipart.org/detail/30217/tango-face-smile-by-warszawianka
http://openclipart.org/detail/30229/tango-face-plain-by-
http://openclipart.org/detail/30223/tango-face-sad-by-warszawianka

Option C:
http://openclipart.org/detail/22384/emoticons:-simple-face-by-nicubunu
http://openclipart.org/detail/22390/emoticons:-worried-face-by-nicubunu
http://openclipart.org/detail/22388/emoticons:-sad-face-by-nicubunu
Comment 1 Kohei Yoshida 2013-01-31 15:31:50 UTC
Valid feature request.  Putting Markus on CC.
Comment 2 Markus Mohrhard 2013-01-31 15:41:47 UTC
Let's add the UX people into this one. I think the feature request is valid and it makes sense but the UX team should have a look at they should decide which design to use.

If you have more additional icon sets that you think are nice to have please open a bug report and put Astron and me in CC.

@Astron: What is your opinion here? can you/the UX team create a set of smilies or provide me with a link to some that fit nicely into the existing icon sets?
Comment 3 Stefan Knorr (astron) 2013-01-31 19:05:05 UTC
I love option B – it's Tango style already and Public Domain too, so we really only need to fish the appropriate 16*16 PNG files from the Tango icons TGZ [1].

We would also probably have the option to use Gnome's (updated) Tango-style icons, which would probably look a bit snazzier – however, those are under CC-BY-SA. We already include icons under this exact license, though. These can be found at [2].

Ideas?

[1] http://tango.freedesktop.org/releases/tango-icon-theme-0.8.90.tar.gz , inside it look in the folder 16*16/emotes

[2] http://git.gnome.org/browse/gnome-icon-theme/tree/gnome/16x16/emotes
Comment 4 Markus Mohrhard 2013-01-31 20:29:04 UTC
Astron you know that I will happily implement what you/the UX team thinks is perfect. I have nearly no design skill.

If you tell me that these 3 icons are ok I can add them.
Comment 5 Gerry 2013-01-31 20:34:09 UTC
Happy, you like it :-)
Comment 6 Stefan Knorr (astron) 2013-01-31 20:44:40 UTC
> Astron you know that I will happily implement what you/the UX team thinks is
> perfect. I have nearly no design skill.

Haha, great!

Markus, I was mostly referring to the licensing, though. However, I just compared the Tango ones to those in Gnome, and they are almost the same, so using the Public Domain ones seems the natural choice.

I.e. see the files
16x16/emotes/face-{sad,plain,smile}.png from inside of:

http://tango.freedesktop.org/releases/tango-icon-theme-0.8.90.tar.gz
Comment 7 Markus Mohrhard 2013-01-31 21:11:14 UTC
(In reply to comment #6)
> > Astron you know that I will happily implement what you/the UX team thinks is
> > perfect. I have nearly no design skill.
> 
> Haha, great!
> 
> Markus, I was mostly referring to the licensing, though. However, I just
> compared the Tango ones to those in Gnome, and they are almost the same, so
> using the Public Domain ones seems the natural choice.
> 
> I.e. see the files
> 16x16/emotes/face-{sad,plain,smile}.png from inside of:
> 
> http://tango.freedesktop.org/releases/tango-icon-theme-0.8.90.tar.gz

I noted that it is nearly impossible to recognize the smilies in these versions. I fear we will have that problem in all of the 16x16 versions. I'll code an initial version and attach a screenshot.
Comment 8 Markus Mohrhard 2013-02-14 21:00:49 UTC
(In reply to comment #7)
> (In reply to comment #6)
> > > Astron you know that I will happily implement what you/the UX team thinks is
> > > perfect. I have nearly no design skill.
> > 
> > Haha, great!
> > 
> > Markus, I was mostly referring to the licensing, though. However, I just
> > compared the Tango ones to those in Gnome, and they are almost the same, so
> > using the Public Domain ones seems the natural choice.
> > 
> > I.e. see the files
> > 16x16/emotes/face-{sad,plain,smile}.png from inside of:
> > 
> > http://tango.freedesktop.org/releases/tango-icon-theme-0.8.90.tar.gz
> 
> I noted that it is nearly impossible to recognize the smilies in these
> versions. I fear we will have that problem in all of the 16x16 versions.
> I'll code an initial version and attach a screenshot.

@Astron: any comment about the size and the problems identifying the icons in 16x16? If you are fine with how it looks I will happily implement that.
Comment 9 Stefan Knorr (astron) 2013-03-13 21:27:37 UTC
Hi Markus, sorry for the long delay...
I and agree there are some problems.
Maybe it would be an option would be to go with more recognisable emoticons from
the set, e.g. we could use
* :o ("surprised") for "sad",
* use :D or :)) ("laugh" or "smile-big") instead of "happy"
* and keep "plain": :|
Comment 10 Gerry 2013-03-13 22:32:13 UTC
Aren't option A and C easier to recognize than the Tango ones?
Comment 11 Gerry 2013-03-13 22:42:55 UTC
Created attachment 76500 [details]
example-with-thicker-mouths.svg

(of couse, I refer to the options in the original bug entry)

Option A by Zorro is probably the best to recognize. It would be even easy to make the lines of the mouth a bit thicker to have it easier to recognize. An example attached
Comment 12 Gerry 2013-09-08 18:17:32 UTC
Created attachment 85444 [details]
Smilies with thicker smiles
Comment 13 Gerry 2013-09-08 18:18:25 UTC
Created attachment 85445 [details]
Smilies with thicker smiles and different colours
Comment 14 Gerry 2013-09-08 18:22:08 UTC
Dear Markus, dear Stefan,

I added attachment 85444 [details] where I changed the original smiles with bolder smiles. I think it should now be much better to be recognized if downsized to 16x16px.

I played a bit more and created attachment 85445 [details]. These are the same smilies like in the previous attachment, but with signal colours, green, yellow and red. I actually like them most :-)
Comment 15 Markus Mohrhard 2013-09-09 17:18:27 UTC
Are these smilies your work or are they based on some other work? 

We need to be a bit careful and check the license before we integrate anything into master. Especially since we need to distribute them for OOXML compatibility during OOXML export into the file. I need to talk to our license guru about the best license for these files.
Comment 16 Gerry 2013-09-09 18:25:11 UTC
(In reply to comment #15)
> Are these smilies your work or are they based on some other work? 

They are based on Zorro's work here: http://openclipart.org/detail/100759/smiley-by-zorro I think this is the license for all openclipart cliparts: http://openclipart.org/share
I made some changes to Zorro's work (thicker smiles and in the second set different colour settings).
Comment 17 Markus Mohrhard 2013-09-11 14:55:17 UTC
(In reply to comment #16)
> (In reply to comment #15)
> > Are these smilies your work or are they based on some other work? 
> 
> They are based on Zorro's work here:
> http://openclipart.org/detail/100759/smiley-by-zorro I think this is the
> license for all openclipart cliparts: http://openclipart.org/share
> I made some changes to Zorro's work (thicker smiles and in the second set
> different colour settings).

Ok can you then please send the icons to the developer mailing list with a statement where they come from and that your modifications are also public domain/CC0?

That would allow us to use them also for the OOXML export. After you did that I will push at least a patch that allows the use with the ODF filters.
Comment 18 Markus Mohrhard 2013-09-21 01:03:47 UTC
They are implemented now in master and are included in the daily builds.

Thanks a lot Gerry for the design work. I#ll work on the OOXML import/export when I have some free time.