Re: [libreoffice-users] More problems with styles
Den lör 5 jan. 2019 kl 18:39 skrev Remy Gauthier : > Hi, > > If you apply any style that has borders re-defined in any way (including > "no borders"), setting the cell style will override whatever settings you > previously made. I did a few tests and if, in your style definition you > only change - for instance - the background color, then the borders that > were set previously around the cell (Format > Cells...) remain unchanged > when the style is applied. > Yes, I know that ”no borders” means ”no borders”, so pre-existing ones will be removed. But when you select your borders in the borders tab of the style dialogue, clicking a border once makes it look like a black (or whatever selected in the colour combo box) line. If I click it again, the line turns thicker and gray. I though THAT meant ”don't change”, at least that would have made sense. So what does it mean instead? And if I click it again, the line disappears, which obviously means ”no border”. > > If you want to re-initialise the border definition, you can press the > "Standard" button in the bottom right corner of the Style Edit panel when > the Borders tab is selected. This will reset the definition to the setting > of the parent (Herited from on the Organizer tab) - important note here: if > the parent has any border settings, then you will not be able to achieve > your objective of having a style that uses "whatever was already there". > This means you should create your styles as children of Default, and never > change Default itself unless it's for font settings or background color. > > Now, what is it you are trying to do? Are you creating styles to apply > Conditional Formatting? > No. > Or are you just trying to make your table "pretty"? > No. > If it's the latter, I suggest you do it "à la Excel" and just apply the > formatting (background, borders, fonts, etc.) manually, without styles. If > it's Conditional Formatting, apply the borders manually, then apply the > highlighting styles to obtain the effect you are looking for, based on the > condition set. You can also use the STYLE function to dynamically apply a > style from a formula: > > - If the result is a number, the formula would then be: > =Calculation_of_the_number+STYLE("StyleName") > - If the result is text, the formula could be: > =CONCATENATE(Calculatiom_of_the_text,TEXT(STYLE("StyleName")," ")) > > This also works, but still requires you to manually apply the borders. > Also note that trying multiple styles to a cell does not work (e.g. > =Calculation_of_the_number+STYLE("StyleName1")+STYLE("StyleName2")+STYLE("StyleName3")+...): > only the last applied style is kept. > I think I described what I was trying to do in my first post. I have that table looking thing with borders. I have a few cell styles with different background colours representing different ”modes” of something. If this thing worked properly (which it maybe does once I understand it), all I have to do is to select a cell range and double click a style in the right hand panel. It has to be easy and quick, because I am going to do this a lot and also I prefer to use styles, since it's so easy to change specific things for a specific style rather than searching and replacing things directly on the spreadsheet. > > I hope this helps. > At least I now have some more things to try, but I'm still puzzled about that third boarder line mode that I mentioned above. I thing it would be awesome if the third mode actually was the ”don't change” mode. That would be intuitive. Overall though, unfortunately I think that the styles thing in LibreOffice (and Apache OpenOffice) is a mess. There are som many ways to format a cell that it's sometimes very hard to find the source for a cell format when something isn't correctly formatted and it's not obvious where the problem lies. If you format a cell in several ways at once, it's hard to realise which format will ”dominate”. Never mind, that spreadsheet document isn't my most important one anyway, I just thought that if I ran into a bug I could report it. I just wanted to check here first if I maybe missed something. I don't want to annoy the developers with imaginary bugs… Kind regards Johnny Rosenberg > Rémy. > Le vendredi 04 janvier 2019 à 23:33 +0100, Johnny Rosenberg a écrit : > > Sorry for bothering again, but how do I set certain things in a style to > > ”don't change”? > > For instance, I have cell styles with different background colours that I > > apply to cells in a sheet looking like a table with different borders and > > things like that, for instance the first cell in a column has an upper > > border line, the last one has a lower border line. When I apply a cell > > style to these, the lines disappear and I have to add them again, manually. > > Or if I add the lines to the style, they are also added where I don't want > > them. Creating a style for each thinkable scenario is of course > > overwhelming, and not a convenient way to go. > > I just wa
Re: [libreoffice-users] More problems with styles
Hi, If you apply any style that has borders re-defined in any way (including "no borders"), setting the cell style will override whatever settings you previously made. I did a few tests and if, in your style definition you only change - for instance - the background color, then the borders that were set previously around the cell (Format > Cells...) remain unchanged when the style is applied. If you want to re-initialise the border definition, you can press the "Standard" button in the bottom right corner of the Style Edit panel when the Borders tab is selected. This will reset the definition to the setting of the parent (Herited from on the Organizer tab) - important note here: if the parent has any border settings, then you will not be able to achieve your objective of having a style that uses "whatever was already there". This means you should create your styles as children of Default, and never change Default itself unless it's for font settings or background color. Now, what is it you are trying to do? Are you creating styles to apply Conditional Formatting? Or are you just trying to make your table "pretty"? If it's the latter, I suggest you do it "à la Excel" and just apply the formatting (background, borders, fonts, etc.) manually, without styles. If it's Conditional Formatting, apply the borders manually, then apply the highlighting styles to obtain the effect you are looking for, based on the condition set. You can also use the STYLE function to dynamically apply a style from a formula: - If the result is a number, the formula would then be: =Calculation_of_the_number+STYLE("StyleName") - If the result is text, the formula could be: =CONCATENATE(Calculatiom_of_the_text,TEXT(STYLE("StyleName")," ")) This also works, but still requires you to manually apply the borders. Also note that trying multiple styles to a cell does not work (e.g. =Calculation_of_the_number+STYLE("StyleName1")+STYLE("StyleName2")+STYL E("StyleName3")+...): only the last applied style is kept. I hope this helps. Rémy. Le vendredi 04 janvier 2019 à 23:33 +0100, Johnny Rosenberg a écrit : > Sorry for bothering again, but how do I set certain things in a style to > ”don't change”? > For instance, I have cell styles with different background colours that I > apply to cells in a sheet looking like a table with different borders and > things like that, for instance the first cell in a column has an upper > border line, the last one has a lower border line. When I apply a cell > style to these, the lines disappear and I have to add them again, manually. > Or if I add the lines to the style, they are also added where I don't want > them. Creating a style for each thinkable scenario is of course > overwhelming, and not a convenient way to go. > I just want to set all border lines to ”whatever was already there”, and I > thought I could, but it didn't work. > When I click a line in the border line section in the styles dialogue, a > line appears, if I click again the line turns thicker and grayer and a > third click removes the line again, but neither of those three states seems > to do what I want. Either lines are drawn or removed, never left untouched > when applying the style. > What am I missing? > > Yes, even the bug-monster Excel can do this. :o > > > Kind regards > > Johnny Rosenberg > > -- 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
Hi Luuk, I have started with "What is the purpose of the chart?" 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
[libreoffice-users] Draw: page numbering
Hi all, I want to create a rather huge document in LO Draw (actually a photo collection) with numbered pages. Thus, I want to split the document into multiple parts, export them separately as PDF, and glue the resulting PDF together. Adding the page/slide number in the master is of course simple, but it starts with "1" for each document. Is it possible to change the start number somehow, i.e. to print e.g. "20" on the 1st page of the 2nd document part? Thanks in advance, Albrecht. -- 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 5-1-2019 12:29, Dave Howorth wrote: On Sat, 5 Jan 2019 10:50:42 +0100 Luuk wrote: The fact that a screen has only (a limited) number of pixels, has NOTHING to do with how many items are used, or can be used, in a graph. You're clearly not a programmer. I, indeed, fail to see the logic in this conclusion. -- 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 Sat, 5 Jan 2019 10:50:42 +0100 Luuk wrote: > On 4-1-2019 18:54, Regina Henschel wrote: > > Hi Dave, > > > > Dave Howorth schrieb am 02-Jan-19 um 18:12: > >> [..] > >> > >> 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. > > > > Each data item produces an object, which is selectable in edit mode > > of the chart. Your data produce 5000*(10+11)=105000 objects. That > > cannot be fast. > > > > What is the purpose of the chart? You do not need 105000 objects to > > illustrate something. > > > > With 5000 items in x-direction a lot of them will be on top of > > others. My screen has only 1920 dots width and yours? > > > The fact that a screen has only (a limited) number of pixels, has > NOTHING to do with how many items are used, or can be used, in a > graph. You're clearly not a programmer. > Maybe the user has a A0-plotter to print this graph? In which case the resolution of the output device is greater. > This should still be possible with software like LibreOffice, or the > should kill the option to create graph's > just 2 cents My 2p -- 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 4-1-2019 18:54, Regina Henschel wrote: Hi Dave, Dave Howorth schrieb am 02-Jan-19 um 18:12: [..] 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. Each data item produces an object, which is selectable in edit mode of the chart. Your data produce 5000*(10+11)=105000 objects. That cannot be fast. What is the purpose of the chart? You do not need 105000 objects to illustrate something. With 5000 items in x-direction a lot of them will be on top of others. My screen has only 1920 dots width and yours? The fact that a screen has only (a limited) number of pixels, has NOTHING to do with how many items are used, or can be used, in a graph. Maybe the user has a A0-plotter to print this graph? This should still be possible with software like LibreOffice, or the should kill the option to create graph's just 2 cents -- 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