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] what's the best way to make charts of spreadsheet data
On 2-1-2019 18:12, Dave Howorth wrote: The Y-axis is reasonable from 0 to 120, although it would be nice to trim the blank space at the top a bit, since the data can't exceed 100. Right click on the Y-Axis, and choose 'Format Axis' A popup will be schown where you can set Minimum- and Maximum value for the Axis (and more) -- 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
[libreoffice-users] what's the best way to make charts of spreadsheet data
I just made a chart of some data in LibreOffice Calc and was disappointed both by the process (very slow) and by the results (apparent lack of ability to modify the view). I've used spreadsheets and LO Calc specifically sporadically over the years to make calculations but wouldn't call myself an expert. I can't remember the last time I tried to make a chart. So I'm wondering if I've missed something in LO that would help me have a better experience with this chart, or if there are better tools to use to draw charts from spreadsheet data. I'm running Version 6.1.3.2 of LibreOffice (actually the openSUSE build for Leap 15.0). I'm running a machine with an i5-4460 CPU @ 3.20GHz and 8 GB main memory. It's normally fast enough for whatever I want to do. My spreadsheet data is in columns. Column A is the dates and column B is the times. Then ten columns of humidity data and eleven columns of temperature data. There are currently just over 5000 rows of samples. Making the chart was extremely slow. Every time I changed the Name of a line of the chart I had to wait whilst it cycled through several steps to make the change. Initially when I removed some empty columns from the data range, it took an age to do so. etc. Now I've created the chart and got some reasonable lines across it, but what I hope are the dates and times along the X axis are just a mess and I've no idea how to make them display usefully. The Y-axis is reasonable from 0 to 120, although it would be nice to trim the blank space at the top a bit, since the data can't exceed 100. I haven't found any way to select individual points on the chart to display the detailed value of that point or all the values at that time. Nor do I see a way to temporarily hide individual data lines to more clearly see other particular lines, for example. If there's any way to do these things with an LO chart, and to speed it up, I'd be grateful for any pointers. Or if there are better options out there that can read .ods or .csv and display charts, that would also be interesting. TIA, Dave -- 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