[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

Yousuf Philips (jay)  changed:

   What|Removed |Added

 Blocks||102946


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=102946
[Bug 102946] [META] Styles bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

raal  changed:

   What|Removed |Added

 CC||yanp...@gmail.com

--- Comment #22 from raal  ---
*** Bug 96542 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #21 from Yousuf (Jay) Philips  ---
Created attachment 118876
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118876=edit
Chart Styles for LibreOffice

Have attached the document i've been working on in Google Docs.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #18 from Yousuf (Jay) Philips  ---
(In reply to Gerry from comment #17)
> Hi Jay, 

Hi Gerry,

> the styles system in LibreOffice is really powerful (and outstanding
> compared to MS Office), but has not really been improved in recent years (it
> lacks picture styles, document styles, colour sets, table styles and chart
> styles).

Yes LO's styling system isnt optimal at the moment, but progress is being made
with document styles (bug 90497) and i'm hopeful that table styles will soon
come after that. Not sure what picture styles are, so you'll have to enlighten
me on that.

> With regard to chart styles, there are existing synergies with character,
> paragraph and frame styles, e.g. for chart headings, sub-headings, axis
> descriptions, legend, legend frames, chart frames, etc. It would be a pity
> if that is being duplicated.

Presently LO's chart system is a completely independent module and doesnt
support character, paragraph, or cell styles, only direct formatting.

> Also, a predefined set of colours is something which has synergies beyond
> charts, because it should be also possible to have the same default colours
> sets for drawings as for charts (when color sets will exist). 

Yes this is hoped for with the work going on with document theming (bug 90497).

> I understand that the chart edit mode might make it difficult (impossible?)
> to implement it with the existing styles system. But it would be also a
> pity, if LibreOffice makes with table styles, color sets and chart styles
> the same mistake like with "auto-formats" for Writer tables. This system was
> 100% not integrated in the styles system. Not even the logic behind...

I believe that once document theming is implemented, that there would likely be
a means of giving the chart edit mode access to the document theming in the
file that the chart is placed in. Yes its unfortunate that LO hasnt implemented
table styles and more worrying that it doesnt support importing ODF table
styles (bug 94076). Looking at Writer's Autoformats dialog, it seems to be
copied from WordPerfect. You can read details i've been collecting about table
styles here.

https://docs.google.com/document/d/1zOsEe_cj-VnFyuPZcld4-WPjwmdsfsaHuOO8e2dfhU0/edit?usp=sharing

> Thanks for every progress on chart styles (and others like table styles)!

Glad i could move the needle forward.

> I think it would be great if the system would allow to "switch" a chart from
> one chart style with one click to another chart style. Imaging if you have a
> publication with dozens of charts for an online publication in color and
> then for the print publication in greyscale. At the moment, this takes ages
> to reformat those charts in LO.

Yes i'm hopeful that it can be achieved in the future, though presently there
isnt any developer who has committed to do it, but atleast we can get things as
ready as possible so that it can be implemented or possibly be a GSoC project.
Please do give my chart styles document a read when you get a chance, as i have
just completed it, with samples.

https://docs.google.com/document/d/1QZ2JchTHZ0_o4CZwMNB-xVqIKJVomrnSw8LetfX-uZ8/edit?usp=sharing

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #19 from Gerry  ---
Thanks a lot Jay.

picture styles: bug 59906. IMHO they should be low priority, but were
implemented in MS Office 2007.


Reading your chart styles document, I have more the feeling that LibreOffice
should not copy what MS Office did with regard to chart styles. I think the
solutions of statistical software are much more powerful (and leave out
unuseful chart style options). Also, the idea that it is generally possible to
script new chart styles and provide them to other users is great. For example,
Stata provides a style made for the "Economist" journal.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #20 from Yousuf (Jay) Philips  ---
(In reply to Gerry from comment #19)
> picture styles: bug 59906. IMHO they should be low priority, but were
> implemented in MS Office 2007.

Thanks for the link. Yep i had seen them before but totally forgot about it. :D
I doubt that would ever get implemented.

> Reading your chart styles document, I have more the feeling that LibreOffice
> should not copy what MS Office did with regard to chart styles.

I'm hoping big but its possible that all of the chart styles might not be
implementable, so by having the various pieces that make up the style, it gives
us flexibility for implementation, and gives users more customizable options.

> I think the
> solutions of statistical software are much more powerful (and leave out
> unuseful chart style options). Also, the idea that it is generally possible
> to script new chart styles and provide them to other users is great. For
> example, Stata provides a style made for the "Economist" journal.

Havent used stats software, so i'll have to take your word for it, but if users
are to create their own custom chart style, there isnt any options that should
be lost because it was deemed unuseful.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #5 from Yousuf (Jay) Philips  ---
(In reply to Bastián Díaz from comment #4)
> Does this only comes to the colors of charts?

The colors of the chart data series is one of the pieces that is hoped to be
covered by this bug enhancement, the others being element layout and element
styles.

> See: https://bugs.documentfoundation.org/show_bug.cgi?id=93088
> 
> Please check, and if necessary, mark as duplicate.
> So I can create another report, including color palettes like styles.

I think your bug maybe related to document theming (bug 90497).

As an update to this bug report, I brought up the topic of chart styles in
wednesday's design meeting and discussed it with Heiko and Matthias. I've asked
them to proposed data series color sets and chart element layouts, and others
are welcome to do the same.

My current research on this, as well as chart styles from competing office
suites can be found at the following link.

https://drive.google.com/folderview?id=0B6qJrVIa0SAlfmZTWFI4MWpCLUh0OXlnYVV5bmtoMXNVU25kRzlHNDZZQ3FDdVFvcHU1emc=sharing

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #6 from Gerry  ---
Dear Jay, that's great that you look into chart styles. There are two other
bugs which request something very similar and might be duplicates: bug 62925
and bug 39097 and bug 62860. These bugs also include examples from statistical
software like Stata and SAS. They all have chart theming/styles. If you like, I
can also provide some more examples from Stata.

Overall, it would be great if something is moving with regard to chart styles.
Even a simple switch between a coloured and greyscale mode (which is relevant
for most publications) would be already a big step forward. 

When you think about the design of that feature, please include it well into
the existing styles system in LibreOffice and not something completely separate
(like the awful auto-formats did for Writer tables). It would be just superbe
if it integrates nicely with the existing page-, paragraph-, character-,
frame-, list-styles system in LO.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 CC|libreoffice-ux-advise@lists |diaz.bast...@openmailbox.or
   |.freedesktop.org|g
  Component|ux-advise   |UI
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=62
   ||925

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

Gerry  changed:

   What|Removed |Added

URL||https://wiki.documentfounda
   ||tion.org/Chart_styles

--- Comment #7 from Gerry  ---
Play also see the wiki page on Chart styles:
https://wiki.documentfoundation.org/Chart_styles There are also some examples
from Excel and Stata.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #16 from Gerry  ---
Created attachment 118838
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118838=edit
Stata: Selection of five different chart styles applied to the same chart

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #15 from Gerry  ---
Created attachment 118837
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118837=edit
Stata: Screenshot of UI to apply the different chart styles in Stata

Attached screenshot of Stata UI for chart styles. 

Chart styles in Stata are indeed very simple to use. It is a predefined set of
12 style sets. There are many additional style sets available which can be
defined in a kind of programming language (see the Chart Styles wiki page).

These style sets can be applied in the creation of new charts, but also to
change charts which do already exist.

The chart styles change a number of features of the charts:
* Chart colours
* Background colour
* Font, Font colour and size
* Frames around the charts
* Size and place of legend

In another screenshot, I will attach a selection of chart styles (applied to
the same chart) in Stata.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #17 from Gerry  ---
> The chart styles would have to be implemented in the chart edit mode, so it
> wouldnt be possible to integrate it into the current styling system found in
> LO. It will likely be implemented in a dialog, where a user could select
> from a collection of various styling options to be applied to their chart,
> and also hopefully implement in the chart sidebar.

Hi Jay, 

the styles system in LibreOffice is really powerful (and outstanding compared
to MS Office), but has not really been improved in recent years (it lacks
picture styles, document styles, colour sets, table styles and chart styles). 

With regard to chart styles, there are existing synergies with character,
paragraph and frame styles, e.g. for chart headings, sub-headings, axis
descriptions, legend, legend frames, chart frames, etc. It would be a pity if
that is being duplicated.

Also, a predefined set of colours is something which has synergies beyond
charts, because it should be also possible to have the same default colours
sets for drawings as for charts (when color sets will exist). 

I understand that the chart edit mode might make it difficult (impossible?) to
implement it with the existing styles system. But it would be also a pity, if
LibreOffice makes with table styles, color sets and chart styles the same
mistake like with "auto-formats" for Writer tables. This system was 100% not
integrated in the styles system. Not even the logic behind...

Thanks for every progress on chart styles (and others like table styles)!

I think it would be great if the system would allow to "switch" a chart from
one chart style with one click to another chart style. Imaging if you have a
publication with dozens of charts for an online publication in color and then
for the print publication in greyscale. At the moment, this takes ages to
reformat those charts in LO.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 CC||gerry.trep...@googlemail.co
   ||m

--- Comment #8 from Yousuf (Jay) Philips  ---
(In reply to Gerry from comment #6)
> Dear Jay, that's great that you look into chart styles. There are two other
> bugs which request something very similar and might be duplicates: bug 62925
> and bug 39097 and bug 62860. These bugs also include examples from
> statistical software like Stata and SAS. They all have chart theming/styles.
> If you like, I can also provide some more examples from Stata.

Hi Gerry,

Yes i had read though the chart styles wiki page previously and noticed the
various similar bug reports mentioned in bug 62925, but didnt go through those
yet. Yes it would be good to get screenshots of how Stata presents the
theming/styles and some examples of the various styles.

> Overall, it would be great if something is moving with regard to chart
> styles. Even a simple switch between a coloured and greyscale mode (which is
> relevant for most publications) would be already a big step forward. 

In order to move this forward, we have to propose some chart color sets,
element layouts and element styles that can be then passed onto a developer to
take the next step.

> When you think about the design of that feature, please include it well into
> the existing styles system in LibreOffice and not something completely
> separate (like the awful auto-formats did for Writer tables). It would be
> just superbe if it integrates nicely with the existing page-, paragraph-,
> character-, frame-, list-styles system in LO.

The chart styles would have to be implemented in the chart edit mode, so it
wouldnt be possible to integrate it into the current styling system found in
LO. It will likely be implemented in a dialog, where a user could select from a
collection of various styling options to be applied to their chart, and also
hopefully implement in the chart sidebar.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #13 from Alex Thurgood  ---
Created attachment 118832
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118832=edit
Numbers Chart Styles Graph type

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #9 from Alex Thurgood  ---
Created attachment 118828
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118828=edit
Numbers ChartStyles Settings top

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #11 from Alex Thurgood  ---
Created attachment 118830
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118830=edit
Numbers Chart Styles Background Border detail

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #10 from Alex Thurgood  ---
Created attachment 118829
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118829=edit
Numbers Chart Styles Background Border general

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #12 from Alex Thurgood  ---
Created attachment 118831
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118831=edit
Numbers Chart Styles Shadow

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #14 from Bastián Díaz  ---
(In reply to Yousuf (Jay) Philips from comment #5)
> (In reply to Bastián Díaz from comment #4)
> > Does this only comes to the colors of charts?
> 
> The colors of the chart data series is one of the pieces that is hoped to be
> covered by this bug enhancement, the others being element layout and element
> styles.
> 
> > See: https://bugs.documentfoundation.org/show_bug.cgi?id=93088
> > 
> > Please check, and if necessary, mark as duplicate.
> > So I can create another report, including color palettes like styles.
> 
> I think your bug maybe related to document theming (bug 90497).
> 
> As an update to this bug report, I brought up the topic of chart styles in
> wednesday's design meeting and discussed it with Heiko and Matthias. I've
> asked them to proposed data series color sets and chart element layouts, and
> others are welcome to do the same.
> 
> My current research on this, as well as chart styles from competing office
> suites can be found at the following link.
> 
> https://drive.google.com/
> folderview?id=0B6qJrVIa0SAlfmZTWFI4MWpCLUh0OXlnYVV5bmtoMXNVU25kRzlHNDZZQ3FDdV
> FvcHU1emc=sharing

I understand. I will change the title of my report to distinguish the concept
of "themes". Actually I propose an easy way to attach a color palette to a
document (a form could be styles).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #4 from Bastián Díaz  ---
Does this only comes to the colors of charts?

See: https://bugs.documentfoundation.org/show_bug.cgi?id=93088

Please check, and if necessary, mark as duplicate.
So I can create another report, including color palettes like styles.

(to order a bit).

Cheers

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

A (Andy) stgohi-lob...@yahoo.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||stgohi-lob...@yahoo.de
 Ever confirmed|0   |1

--- Comment #3 from A (Andy) stgohi-lob...@yahoo.de ---
Great proposal, I would really like to have this feature.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #1 from Jay Philips philip...@hotmail.com ---
Created attachment 114661
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114661action=edit
FreeOffice Color Palettes

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 90490] Providing chart style/color presets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=90490

--- Comment #2 from Jay Philips philip...@hotmail.com ---
Created attachment 114662
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114662action=edit
iWork chart styles

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs