Bug 100586 - Help Text does not include Range for Border Colours and Range for Fill Colours
Summary: Help Text does not include Range for Border Colours and Range for Fill Colours
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.1.4.1 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 80303
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2016-06-24 13:52 UTC by riesslibo
Modified: 2021-05-30 09:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
examples ods with a chart and trail and error for range of filling colors (13.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-06-24 13:54 UTC, riesslibo
Details
screenshot of the data range wizzard with possibility to enter y range of fill colours or border colors (93.02 KB, image/png)
2016-06-24 13:55 UTC, riesslibo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description riesslibo 2016-06-24 13:52:56 UTC
Problemstatement
If you have done a chart and want tu use the possibiliy, to define the border colour and the fill colour of each data series and want to know, which number entries in it cells should be written for which colour, the help text shows no explanation for both possible data series (see PNG).


See the example file colornumbers4dataseries.ods with a chart:
If you write some numbers in the cells, see D11:F13(as much as one data series have entries) they were interpreted as colour, but which number is which colour (or is it a RGB number in 3 cells)? Hitting the help button when having the data range assistant activated via symbol bar brings no explantaion for these border and fill range.

Expected behavior: you could use the name of a colour (e.g. Magenta, or gray 3 or s.l.t.) or at least an explanation in the help text, how this two data ranges have to be filled for a data series to get a specifik colour or a table of numbers corresponding to the colours.
Also I would expect, that the legend is updated with this colours, see in the example file, the old colours of the chart assistant are still shown. Is it something like a hard formatting of color properties of data series?

Can someone help with this?
Comment 1 riesslibo 2016-06-24 13:54:11 UTC
Created attachment 125883 [details]
examples ods with a chart and trail and error for range of filling colors
Comment 2 riesslibo 2016-06-24 13:55:16 UTC
Created attachment 125884 [details]
screenshot of the data range wizzard with possibility to enter y range of fill colours or border colors
Comment 3 riesslibo 2016-06-30 12:57:24 UTC
Perhaps I should add, if someone confirmes and gives me the information needed I will volounteer to add it to the help system ;-)
Thanks a lot
Lothar
Comment 4 Olivier Hallot 2016-07-20 14:07:40 UTC
Thank you for offering to improve our help contents.

The file to correct is wiz_data_series.xhp

You can see it live here:

vm173.documentfoundation.org/text/schart/01/wiz_data_series.xhp

There are 2 ways to fix this, the long way and the quick way.

The quick way is to write the content/modifications and attach it here, as a single text file (or odt file) and I will create a patch with your authorship and add to LO help.

Or you can do it yourself by editing and patching the file wiz_data_series.xhp in the source code (needs knowledge with git/gerrit/XHP files+schema/compile/test/submit).
Comment 5 riesslibo 2017-05-30 14:06:38 UTC
OK, in the meantime I tried and failed and tried and get the answer ;-)

For each cell of the data row (which is activated in the left listbox) you can define the colour for the filling and the border with the number of the hexcode of RGB colours, it is easy if you use the =Hexindez("<hex of colour>") and the hex representation of a colour you can find out via any colour dialog with a user defined colour at the bottom in the RGB area.

So if you want to give the diagramm field of a specific data item a spedial colour you can do this via the propertie of Filling colour in the data range writing the number representation of the hex code of the colour like =Hexindez("020202") for the color black.