Cell style background colour

classic Classic list List threaded Threaded
11 messages Options
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Cell style background colour

Sorry for bothering everyone again, but I can't find how to add colours to
the background colour palette. In older LibreOffice versions, or maybe it
was even Apache OpenOffice, I could add colours in Tools → Options… →
somewhere, but it seems to be removed. I miss quite a few colours in the
colour selection area in (right click a style) → Modify… → Background →
Background colour, so I want to add my own and give them names (other than
”#15a3b7” or similar). I'm pretty sure I could do that in old versions, and
I guess it's still possible in today's versions, I just seem to not being
able to figure out how… What am I missing here?

Kind regards

Johnny Rosenberg

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Robert Großkopf Robert Großkopf
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

Hi Jonny,

> Sorry for bothering everyone again, but I can't find how to add colours to
> the background colour palette. In older LibreOffice versions, or maybe it
> was even Apache OpenOffice, I could add colours in Tools → Options… →
> somewhere, but it seems to be removed.

https://wiki.documentfoundation.org/ReleaseNotes/5.3#Change_of_color_palettes

> I miss quite a few colours in the
> colour selection area in (right click a style) → Modify… → Background →
> Background colour, so I want to add my own and give them names (other than
> ”#15a3b7” or similar).

I have tested a littel bit. Don't use Calc so often. I haven't found a
possibility to give a name to the added colors any more. Seems it could
only be modified in the palette-definition of the source code. See:
https://design.blog.documentfoundation.org/2016/12/30/new-color-palettes-in-libreoffice/
Something like
<draw:color draw:name="Azure" draw:color="#f0ffff"/>
in <libreoffice>/share/palette

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
htietze htietze
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

In reply to this post by Johnny Rosenberg
We have some places where the new palette handling is still missing [1]. Actually the task was way too hard for a GSoC student and we have some minor regressions. I hope the benefit of the new workflow compensate for it. Good news is that this issue got fixed recently [2] and it will be included in the upcoming release 6.2. So please be patient one more month - or download the release candidate [3].

Cheers,
Heiko

[1] https://bugs.documentfoundation.org/show_bug.cgi?id=105225
[2] https://gerrit.libreoffice.org/plugins/gitiles/core/+/45b030a3e219bc2876472e1ada12cff602ec6549%5E%21
[3] https://www.libreoffice.org/download/pre-releases/

On 01.01.19 22:58, Johnny Rosenberg wrote:

> Sorry for bothering everyone again, but I can't find how to add colours to
> the background colour palette. In older LibreOffice versions, or maybe it
> was even Apache OpenOffice, I could add colours in Tools → Options… →
> somewhere, but it seems to be removed. I miss quite a few colours in the
> colour selection area in (right click a style) → Modify… → Background →
> Background colour, so I want to add my own and give them names (other than
> ”#15a3b7” or similar). I'm pretty sure I could do that in old versions, and
> I guess it's still possible in today's versions, I just seem to not being
> able to figure out how… What am I missing here?
>
> Kind regards
>
> Johnny Rosenberg
>

--
Dr. Heiko Tietze
UX designer
Tel. +49 (0)179/1268509


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

In reply to this post by Johnny Rosenberg
Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker <[hidden email]>:

> At 22:58 01/01/2019 +0100, you wrote:
> >... I can't find how to add colours to the
> >background colour palette. In older LibreOffice
> >versions, or maybe it was even Apache
> >OpenOffice, I could add colours in Tools -> Options… -> somewhere, ...
>
> Yup: at Tools | Options... | LibreOffice | Colours.
>
Exactly, and it's gone now since version 5.something.


>
> >... but it seems to be removed. I miss quite a
> >few colours in the colour selection area in
> >(right click a style) -> Modify… -> Background
> >-> Background colour, so I want to add my own
> >and give them names (other than "#15a3b7" or
> >similar). I'm pretty sure I could do that in old
> >versions, and I guess it's still possible in
> >today's versions, I just seem to not being able
> >to figure out how… What am I missing here?
>
> The Getting Started Guide says "You can [...]
> change individual colors to your own taste. To do
> this, use the Area dialog by selecting Format >
> Area on the Menu bar or clicking the Area icon on
> the Sidebar, then selecting the Colors tab." (The
> Calc Guide - currently at 4.1 - does not appear to have caught up.)
>
> Does this not work?
>

Yes, but that was obviously not what I was asking for, that is change the
suggested colours in the modifying background colour of a style dialogue.


>
> I trust this helps.
>

But it didn't, since the answer was not related to my question (or maybe I
just didn't understand the answer).


> Brian Barker - privately
>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

In reply to this post by htietze
Den ons 2 jan. 2019 kl 12:03 skrev Heiko Tietze <[hidden email]>:

> We have some places where the new palette handling is still missing [1].
> Actually the task was way too hard for a GSoC student and we have some
> minor regressions. I hope the benefit of the new workflow compensate for
> it. Good news is that this issue got fixed recently [2] and it will be
> included in the upcoming release 6.2. So please be patient one more month -
> or download the release candidate [3].
>

Thanks! I'll patiently wait for it to arrive to my distribution (Manjaro).
It's usually not far behind.


Kind regards

Johnny Rosenberg


> Cheers,
> Heiko
>
> [1] https://bugs.documentfoundation.org/show_bug.cgi?id=105225
> [2]
> https://gerrit.libreoffice.org/plugins/gitiles/core/+/45b030a3e219bc2876472e1ada12cff602ec6549%5E%21
> [3] https://www.libreoffice.org/download/pre-releases/
>
> On 01.01.19 22:58, Johnny Rosenberg wrote:
> > Sorry for bothering everyone again, but I can't find how to add colours
> to
> > the background colour palette. In older LibreOffice versions, or maybe it
> > was even Apache OpenOffice, I could add colours in Tools → Options… →
> > somewhere, but it seems to be removed. I miss quite a few colours in the
> > colour selection area in (right click a style) → Modify… → Background →
> > Background colour, so I want to add my own and give them names (other
> than
> > ”#15a3b7” or similar). I'm pretty sure I could do that in old versions,
> and
> > I guess it's still possible in today's versions, I just seem to not being
> > able to figure out how… What am I missing here?
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
>
> --
> Dr. Heiko Tietze
> UX designer
> Tel. +49 (0)179/1268509
>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

In reply to this post by Johnny Rosenberg
Inline post

On 1/2/19 7:17 PM, Johnny Rosenberg wrote:

> Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker <[hidden email]>:
>
>> At 22:58 01/01/2019 +0100, you wrote:
>>> ... I can't find how to add colours to the
>>> background colour palette. In older LibreOffice
>>> versions, or maybe it was even Apache
>>> OpenOffice, I could add colours in Tools -> Options… -> somewhere, ...
>> Yup: at Tools | Options... | LibreOffice | Colours.
>>
> Exactly, and it's gone now since version 5.something.

      Colors can be added to the Custom pallet with colors you name.
These are available in Base, Impress, and Writer. Once you have created
and named them, they are available for Font colors and Background colors
in the Formatting toolbar in Calc.

      I recommend you open a new document in Writer. Styles > Edit
Style. Click the Color Button. Select the RGB values you desire on the
right side of the dialog. Click the Pick button (bottom right). This
puts the new color in the Resent Colors box on the left side. Click this
color there and then click the Add button. Enter you color name in the
popup window and click OK.

      There is a drop down list with the names of color pallets that are
available for your use. One of them in the Custom pallet.

Dan

>
>
>>> ... but it seems to be removed. I miss quite a
>>> few colours in the colour selection area in
>>> (right click a style) -> Modify… -> Background
>>> -> Background colour, so I want to add my own
>>> and give them names (other than "#15a3b7" or
>>> similar). I'm pretty sure I could do that in old
>>> versions, and I guess it's still possible in
>>> today's versions, I just seem to not being able
>>> to figure out how… What am I missing here?
>> The Getting Started Guide says "You can [...]
>> change individual colors to your own taste. To do
>> this, use the Area dialog by selecting Format >
>> Area on the Menu bar or clicking the Area icon on
>> the Sidebar, then selecting the Colors tab." (The
>> Calc Guide - currently at 4.1 - does not appear to have caught up.)
>>
>> Does this not work?
>>
> Yes, but that was obviously not what I was asking for, that is change the
> suggested colours in the modifying background colour of a style dialogue.
>
>
>> I trust this helps.
>>
> But it didn't, since the answer was not related to my question (or maybe I
> just didn't understand the answer).
>
>
>> Brian Barker - privately
>>
>>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour


On 1/3/19 11:14 AM, Dan Lewis wrote:

> Inline post
>
> On 1/2/19 7:17 PM, Johnny Rosenberg wrote:
>> Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker
>> <[hidden email]>:
>>
>>> At 22:58 01/01/2019 +0100, you wrote:
>>>> ... I can't find how to add colours to the
>>>> background colour palette. In older LibreOffice
>>>> versions, or maybe it was even Apache
>>>> OpenOffice, I could add colours in Tools -> Options… -> somewhere, ...
>>> Yup: at Tools | Options... | LibreOffice | Colours.
>>>
>> Exactly, and it's gone now since version 5.something.
>
>      Colors can be added to the Custom pallet with colors you name.
> These are available in Base, Impress, and Writer. Once you have
> created and named them, they are available for Font colors and
> Background colors in the Formatting toolbar in Calc.
>
>      I recommend you open a new document in Writer. Styles > Edit
> Style. Click the Color Button. Select the RGB values you desire on the
> right side of the dialog. Click the Pick button (bottom right). This
> puts the new color in the Resent Colors box on the left side. Click
> this color there and then click the Add button. Enter you color name
> in the popup window and click OK.
>
>      There is a drop down list with the names of color pallets that
> are available for your use. One of them in the Custom pallet.
>
> Dan

      Styles > Edit Style > Area is the correct path to take. (I forgot
about "Area", sorry.)

Dan

>
>>
>>
>>>> ... but it seems to be removed. I miss quite a
>>>> few colours in the colour selection area in
>>>> (right click a style) -> Modify… -> Background
>>>> -> Background colour, so I want to add my own
>>>> and give them names (other than "#15a3b7" or
>>>> similar). I'm pretty sure I could do that in old
>>>> versions, and I guess it's still possible in
>>>> today's versions, I just seem to not being able
>>>> to figure out how… What am I missing here?
>>> The Getting Started Guide says "You can [...]
>>> change individual colors to your own taste. To do
>>> this, use the Area dialog by selecting Format >
>>> Area on the Menu bar or clicking the Area icon on
>>> the Sidebar, then selecting the Colors tab." (The
>>> Calc Guide - currently at 4.1 - does not appear to have caught up.)
>>>
>>> Does this not work?
>>>
>> Yes, but that was obviously not what I was asking for, that is change
>> the
>> suggested colours in the modifying background colour of a style
>> dialogue.
>>
>>
>>> I trust this helps.
>>>
>> But it didn't, since the answer was not related to my question (or
>> maybe I
>> just didn't understand the answer).
>>
>>
>>> Brian Barker - privately
>>>
>>>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Robert Großkopf Robert Großkopf
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

Hi Dan,
>
>      Styles > Edit Style > Area is the correct path to take. (I forgot
> about "Area", sorry.)

You are right. But who will search for a special defined color in
paragraph styles?

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

In reply to this post by Johnny Rosenberg
Hi Johnny,

Johnny Rosenberg schrieb am 01-Jan-19 um 22:58:
> Sorry for bothering everyone again, but I can't find how to add colours to
> the background colour palette. In older LibreOffice versions, or maybe it
> was even Apache OpenOffice, I could add colours in Tools → Options… →
> somewhere, but it seems to be removed. I miss quite a few colours in the
> colour selection area in (right click a style) → Modify… → Background →
> Background colour, so I want to add my own and give them names (other than
> ”#15a3b7” or similar). I'm pretty sure I could do that in old versions, and
> I guess it's still possible in today's versions, I just seem to not being
> able to figure out how… What am I missing here?

The general rule is, that adding colors happens at that place, where the
color is used. Only very few dialogs are not yet changed.

It depends on the version, which dialog is already adapted. The new
dialog version for cell styles is not in version 6.0.7 or 6.1.4, but
version 6.3 has it. I'm not sure about version 6.2.

When ever you have a situation, where the new dialog is not yet
available, you can take a different object, which already has the new
dialog, to add your custom color, e.g. a shape. Draw a shape, use its
area property, add your color, delete the shape, for example.

Kind regards
Regina


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel <[hidden email]
>:

> Hi Johnny,
>
> Johnny Rosenberg schrieb am 01-Jan-19 um 22:58:
> > Sorry for bothering everyone again, but I can't find how to add colours
> to
> > the background colour palette. In older LibreOffice versions, or maybe it
> > was even Apache OpenOffice, I could add colours in Tools → Options… →
> > somewhere, but it seems to be removed. I miss quite a few colours in the
> > colour selection area in (right click a style) → Modify… → Background →
> > Background colour, so I want to add my own and give them names (other
> than
> > ”#15a3b7” or similar). I'm pretty sure I could do that in old versions,
> and
> > I guess it's still possible in today's versions, I just seem to not being
> > able to figure out how… What am I missing here?
>
> The general rule is, that adding colors happens at that place, where the
> color is used. Only very few dialogs are not yet changed.
>
> It depends on the version, which dialog is already adapted. The new
> dialog version for cell styles is not in version 6.0.7 or 6.1.4, but
> version 6.3 has it. I'm not sure about version 6.2.
>
> When ever you have a situation, where the new dialog is not yet
> available, you can take a different object, which already has the new
> dialog, to add your custom color, e.g. a shape. Draw a shape, use its
> area property, add your color, delete the shape, for example.
>

Yes, but I can't just figure out how to use a colour as a style background…
Well, I guess I could make a style adapt to changes in cells, then use that
style on a cell and change the background colour of that cell. Now the cell
style should have the same background colour.
But wait, isn't that feature (having cells adapt to changes in cell
formats) removed…? At least I can't find it. Even Excel has it… (as well as
older LibreOffice versions and, I think, Apache OpenOffice).


Kind regards

Johnny Rosenberg



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: Cell style background colour

Den fre 4 jan. 2019 kl 11:56 skrev Johnny Rosenberg <[hidden email]
>:

> Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel <
> [hidden email]>:
>
>> Hi Johnny,
>>
>> Johnny Rosenberg schrieb am 01-Jan-19 um 22:58:
>> > Sorry for bothering everyone again, but I can't find how to add colours
>> to
>> > the background colour palette. In older LibreOffice versions, or maybe
>> it
>> > was even Apache OpenOffice, I could add colours in Tools → Options… →
>> > somewhere, but it seems to be removed. I miss quite a few colours in the
>> > colour selection area in (right click a style) → Modify… → Background →
>> > Background colour, so I want to add my own and give them names (other
>> than
>> > ”#15a3b7” or similar). I'm pretty sure I could do that in old versions,
>> and
>> > I guess it's still possible in today's versions, I just seem to not
>> being
>> > able to figure out how… What am I missing here?
>>
>> The general rule is, that adding colors happens at that place, where the
>> color is used. Only very few dialogs are not yet changed.
>>
>> It depends on the version, which dialog is already adapted. The new
>> dialog version for cell styles is not in version 6.0.7 or 6.1.4, but
>> version 6.3 has it. I'm not sure about version 6.2.
>>
>> When ever you have a situation, where the new dialog is not yet
>> available, you can take a different object, which already has the new
>> dialog, to add your custom color, e.g. a shape. Draw a shape, use its
>> area property, add your color, delete the shape, for example.
>>
>
> Yes, but I can't just figure out how to use a colour as a style background…
> Well, I guess I could make a style adapt to changes in cells, then use
> that style on a cell and change the background colour of that cell. Now the
> cell style should have the same background colour.
> But wait, isn't that feature (having cells adapt to changes in cell
> formats) removed…? At least I can't find it. Even Excel has it… (as well as
> older LibreOffice versions and, I think, Apache OpenOffice).
>

Ok, found it, my bad. It was moved from inside the style modifying dialogue
to a button in the format panel. It didn't work in my corrupted file, but
when I created a new one from scratch it worked perfectly.
This will do for now, until I can do this directly inside the style
modifying dialogue in a future version of LibreOffice Calc.


>
>
> Kind regards
>
> Johnny Rosenberg
>
>
>
>> Kind regards
>> Regina
>>
>>
>> --
>> To unsubscribe e-mail to: [hidden email]
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy