Re: [libreoffice-users] Cell style background colour
Den fre 4 jan. 2019 kl 11:56 skrev Johnny Rosenberg : > Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel < > rb.hensc...@t-online.de>: > >> 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: users+unsubscr...@global.libreoffice.org >> 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel : > 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 > Kind regards > Regina > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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 : 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
Inline post On 1/2/19 7:17 PM, Johnny Rosenberg wrote: Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker : 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker : > 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
Den ons 2 jan. 2019 kl 12:03 skrev Heiko Tietze : > 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Cell style background colour
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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] 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 in /share/palette Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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