Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
Thanks Mark... After prior replies, it appears it may still be there in the 4.4.x series, but maybe only on Windows. I'll be installing the latest 4.4 soon, and will test some more before opening a bug. Will report back here, and ask others to test a bit more and comment, to try to determine a) if it is indeed still there, and b) if it is, is it windows only. Thanks to all for replying... On 4/17/2015 5:18 PM, libreoffice-ml.mbou...@spamgourmet.com libreoffice-ml.mbou...@spamgourmet.com wrote: LibreOffice 4.4.2.2 on Windows Vista 32 bit. Using a new, empty sheet. It only seems to happen with rows, not columns. Or at least, if it does happen with columns, more need to be selected before the delay becomes noticeable. With rows 1, 3, 5, etc. for a total of 7 selected, the delay was barely noticeable, but with 15 selected it was. There seems to be more of a delay right-clicking in the row labels, rather than clicking in the highlighted cells, although there is a delay in both cases. Mark. Gary Collins wrote: I've just tried this with a new empty sheet in LO 4.3.2.2 and haven't noticed anything - right-click seems to respond quite instantly. I have 7 non-contiguous columns selected - is that enough? Or perhaps it makes a difference if a fully populated sheet is used. I don't think I've got one handy here, I'll try when I get home later - but won't be able to post back for a few days. /Gary From: Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk To: users@global.libreoffice.org Cc: aikempsh...@btinternet.com Sent: Friday, 17 April 2015, 14:30 Subject: Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow Yes same here. The more discontiguous rows selected - right click is painfully slow to respond selecting subsequent rows is slow to respond Good luck On 17/04/15 11:56, Tanstaafl wrote: Hello, Before I go open a bug (didn't find an existing one), can someone please confirm this for me? Been meaning to do this for a while, but something always got in the way, but it is just started to annoy me even more... I have been experiencing this for some time, and if memory serves it was still a problem on the 4.1.x series... I'm currently on 4.3.6 The problem is in Calc, has to do with selecting discontiguous rows and a subsequent right-click action The more discontiguous rows you select, the slower the right-click is to respond. If one or more can confirm I'll go open a bug for it... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
Am 19.04.2015 um 15:05 schrieb Tanstaafl: Thanks Mark... After prior replies, it appears it may still be there in the 4.4.x series, but maybe only on Windows. I'll be installing the latest 4.4 soon, and will test some more before opening a bug. Will report back here, and ask others to test a bit more and comment, to try to determine a) if it is indeed still there, and b) if it is, is it windows only. Thanks to all for replying... Same behaviour with LO 3.5 LO 4.4.2 AOO 4.1.1 tested under Windows (the latter 2) and Linux (all 3). -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
Oh dear! One of us clicked the wrong button. :) James On 2015-04-18 09:37, County Court wrote: Notice to Appear, You have to appear in the Court on the April 23. You are kindly asked to prepare and bring the documents relating to the case to Court on the specified date. Note: If you do not come, the case will be heard in your absence. The Court Notice is attached to this email. Regards, Curtis Hart, Clerk of Court. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On April 19, 2015 1:09:42 PM PDT, Virgil Arrington wrote: I am an attorney and no court in the USA would use email to summon a I've forgotten the cite, but in a pleading justifying the use of posting a summons to the individual's FaceBook account, the lawyers cited half a dozen cases where the courts had ruled that service via email was acceptable. jonathon -- Multilingual ODF Office Suite Support. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color
At 14:10 15/04/2015 +0200, Alain Ronly wrote: I'm looking for a simple and automatic way how to tell to my tables in a writer document, to be formatted with alternat[]e rows color for example even rows will be blue in the background and odd rows will have a light blue as background color. I did not find any easy way to do it. Is there someone who has already solved this topic ? Not me. o Once you have set the background colour for one row, you can use the Format Paintbrush to paint the same colour on other rows. If you double-click the button, you can drag the paint bucket across alternate rows to achieve one colour and then repeat the process for the other colour. o For large numbers of rows, you can copy an entire existing table and paste it immediately following - and you can repeat that process. You'll end up with multiple tables, but that may suffice, providing you delete the empty paragraph between them. If you need to, you can put the cursor into the second table and go to Table | Merge Tables (or right-click | Merge Tables) to merge the two tables into one. o It is somewhat easier to set up such background colouring in a spreadsheet than in a Writer table. If you colour two rows you can easily copy them to two more. Then you can copy four rows to create eight in total. With this binary multiplication, you can very quickly achieve the desired size. If you then copy an appropriately-sized section of the spreadsheet and paste it into your text document using Paste Special... and HTML (HyperText Markup Language) you will get a table with the same background formatting. The table properties can be adjusted as necessary. o The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function to determine the oddness or evenness of the row number and control the background colouring using cell styles. But unfortunately - and as you might expect - the effect of such formatting is lost if you paste a copy into a text document as a table. So that's a dead duck. o It's probably much easier to set up formatting such as this before you insert your data. If necessary, you should be able to copy any existing material and paste it into a new, formatted table. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function names with primes
At 20:46 19/04/2015 +0200, Kolbjørn Stuestøl wrote: In Getting started with Math I found this: To write function names with primes, as is usual in school notations, you must first add the signs to the catalog. (The catalog is a list of characters in a font). What are primes in this context? Something like a single quotation mark or apostrophe - but different. See http://en.wikipedia.org/wiki/Prime_%28symbol%29 . It's Unicode 2032 and HTML prime; . How and for what are they used? I don't know about schools, but mathematicians use them to indicate derivatives, so f'(x) is shorthand for df(x)/dx. Some Americans (or others) able to explain this to a non American? Sorry: I'm only an other. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC
Brian Barker wrote: At 11:07 19/04/2015 -0400, Rob All Jr wrote: While I'm working in calc, the program is frequently adding a colon followed by a number (usually 2 sometimes 3) at the end of the file name (i.e. after the 'xlsx'). What's that all about? You say it adds a colon and number at the end of the file name, as if the file name is being thereby modified. But that's not so: the file name is unchanged but the title bar of the LibreOffice window shows the additional element in addition to the file name. It happens, I think, when you have two windows open to the same file (or perhaps when LibreOffice thinks you do); you can see this easily by clicking Windows | New Window with an existing file open. It also seems to happen when using Print Preview. On one document I just tried, opening Print Preview appends :2. After closing the preview, :3 is appended, even though only one window is open. Although I recall previously seeing :2 added when previewing, I think it used to revert to normal on closing the preview, not leave a :3, so there may be something slightly odd crept in there. LibreOffice 4.4.2 on Windows. Rob - as Brian mentioned, rest assured that the : 2 etc. following the filename in LibreOffice's title bar is not actually indicating a change to the name of the file on disk. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
I'm currently on 4.3.6 The problem is in Calc, has to do with selecting discontiguous rows and a subsequent right-click action The more discontiguous rows you select, the slower the right-click is to respond. If one or more can confirm I'll go open a bug for it... Thanks I am not able to verify this problem. Test 1: Selected 15 non-contiguous rows. Test 2: Selected 30 non-contiguous rows. Windows 8.1 all updates, 64b OS, LibreOffice 4.1.2.3: No problem. Right-clicking opens the menu immediately. Windows 8.1, all updates, 64b OS, LibreOffice 4.3.4.1: No problem. Windows 7, all updates,64b OS, LibreOffice 4.4.2.2: No problem. But, if I selects the entire rows by clicking on the row numbers at the left side, the Windows 8.1 computer running LO 4.3.4.1 (laptop) slows down. Perhaps something to do with the computer? Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
Am 19.04.2015 um 16:01 schrieb Tanstaafl: On 4/19/2015 9:16 AM, Andreas Säger ville...@t-online.de wrote: Am 19.04.2015 um 15:05 schrieb Tanstaafl: After prior replies, it appears it may still be there in the 4.4.x series, but maybe only on Windows. I'll be installing the latest 4.4 soon, and will test some more before opening a bug. Will report back here, and ask others to test a bit more and comment, to try to determine a) if it is indeed still there, and b) if it is, is it windows only. Thanks to all for replying... Same behaviour with LO 3.5 LO 4.4.2 AOO 4.1.1 tested under Windows (the latter 2) and Linux (all 3). Hmmm... Graham replied that he saw no evidence of the problem on Linux Mint with 4.4.2... Graham? Can you confirm? It really depends on how many rows you have selected. And it does not happen with a selection of columns as you can see when using my macro with the word Rows replaced with Columns. With 500 selected rows there is a lag of several seconds. With 5000 selected rows the CPU is used up for minutes. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On April 19, 2015 1:57:46 AM PDT, James Wilde wrote: Oh dear! One of us clicked the wrong button. :) The scary thing is that despite being sent to the wrong email address, the intended recipient is presumed to have been legally served, n most parts of the United States. jonathon -- Multilingual ODF Office Suite Support. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On 4/19/2015 12:05 PM, Cley Faye wrote: 2015-04-19 20:48 GMT+02:00 toki kantoor toki.kant...@gmail.com: The scary thing is that despite being sent to the wrong email address, the intended recipient is presumed to have been legally served, n most parts of the United States. I doubt that anyong was the intended recipient. I got the exact same mail as spam, outside of the LO list. 1. The version I got (on this list) came from County Court curtis.h...@cpanel.emidhost.com.br, which carries Brazilian (br) registration. That's almost certainly a silly prank -- a virus that's not particularly malicious. 2. Is it accurate that the intended recipient is presumed to have been legally served? I'm not an attorney, but I believe that some documentation is required to prove that the process has been served, at least in most US jurisdictions. See Wikipedia, Service of process. Spencer -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Function names with primes
In Getting started with Math I found this: To write function names with primes, as is usual in school notations, you must first add the signs to the catalog. (The catalog is a list of characters in a font). What are primes in this context? How and for what are they used? Some Americans (or others) able to explain this to a non American? Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
2015-04-19 20:48 GMT+02:00 toki kantoor toki.kant...@gmail.com: The scary thing is that despite being sent to the wrong email address, the intended recipient is presumed to have been legally served, n most parts of the United States. I doubt that anyong was the intended recipient. I got the exact same mail as spam, outside of the LO list. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function names with primes
On 04/19/2015 03:15 PM, Piet van Oostrum wrote: A prime is the symbol ' or also written as ′ or ’ so in school math you often has variables x and x' or even x'' or x''' These are called x prime x double prime or x triple prime. So, suspect' would be prime suspect? ;-) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Notice to Appear in Court
On 2015-04-19, 12:48 PM toki kantoor wrote: On April 19, 2015 1:57:46 AM PDT, James Wilde wrote: Oh dear! One of us clicked the wrong button. :) The scary thing is that despite being sent to the wrong email address, the intended recipient is presumed to have been legally served, n most parts of the United States. jonathon Legally served in an email from Brazil ??? Give me a break. PS: check the headers to see where it's from -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function names with primes
Kolbjørn Stuestøl wrote: In Getting started with Math I found this: To write function names with primes, as is usual in school notations, you must first add the signs to the catalog. (The catalog is a list of characters in a font). What are primes in this context? How and for what are they used? Some Americans (or others) able to explain this to a non American? Kolbjoern A prime is the symbol ' or also written as ′ or ’ so in school math you often has variables x and x' or even x'' or x''' These are called x prime x double prime or x triple prime. for example x' = 2x. x'' = x' + y. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On Sun, 19 Apr 2015, Cley Faye wrote: 2015-04-19 20:48 GMT+02:00 toki kantoor toki.kant...@gmail.com: The scary thing is that despite being sent to the wrong email address, the intended recipient is presumed to have been legally served, n most parts of the United States. I doubt that anyong was the intended recipient. I got the exact same mail as spam, outside of the LO list. it's also weird it came from a 'county court' in Brazil! f. -- Felmon Davis All you need to know is the user interface. -- J. Redford -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Function names with primes
Am 19.04.2015 um 21:33 schrieb James Knott: On 04/19/2015 03:15 PM, Piet van Oostrum wrote: A prime is the symbol ' or also written as ′ or ’ so in school math you often has variables x and x' or even x'' or x''' These are called x prime x double prime or x triple prime. So, suspect' would be prime suspect? ;-) at times' -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function names with primes
Thank you all for answering me. It helped a lot, Americans or not :-). Kolbjoern Den 19.04.2015 21:29, Brian Barker skreiv: At 20:46 19/04/2015 +0200, Kolbjørn Stuestøl wrote: In Getting started with Math I found this: To write function names with primes, as is usual in school notations, you must first add the signs to the catalog. (The catalog is a list of characters in a font). What are primes in this context? Something like a single quotation mark or apostrophe - but different. See http://en.wikipedia.org/wiki/Prime_%28symbol%29 . It's Unicode 2032 and HTML prime; . How and for what are they used? I don't know about schools, but mathematicians use them to indicate derivatives, so f'(x) is shorthand for df(x)/dx. Some Americans (or others) able to explain this to a non American? Sorry: I'm only an other. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On 04/19/2015 03:32 PM, Spencer Graves wrote: 2. Is it accurate that the intended recipient is presumed to have been legally served? I'm not an attorney, but I believe that some documentation is required to prove that the process has been served, at least in most US jurisdictions. See Wikipedia, Service of process. I am an attorney and no court in the USA would use email to summon a person to court. It's spam. Virgil -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Editing Calc styles: returning to a default
martin f krafft wrote: Hi Andreas, thanks for taking your time to respond. also sprach Andreas Säger ville...@t-online.de [2015-04-15 17:44 +0200]: Not sure if I understand what you're after. The [Standard] button on the style editor dialog resets all attributes to the attribute values of the parent style. This is better than recreating the style, so thank you for the hint. I guess what I am really after is some sort of text-file export or a UI allowing me to individually add and remove attributes from a style. I imagine some tree arrangement and attributes, such as underline, and then I can select whether this attribute - is set to on (forces underlining) - is set to off (forces no underlining) - is not set (inherits underlining from other formatting/styles) While this does not exist, I can make do with your solution. If you're comfortable editing text-based files describing the styles, note that OpenDocument Format (ODF) files, including ODT and ODS, are actually zip archives containing the content, styles, etc. Working on a copy of the file (so you don't lose the original if you make a mistake!) you can unzip the .ods file, ensuring the directory structure is preserved. Within it is a styles.xml file, which contains the style definitions in an XML format. After editing it, zip of the contents again, ensuring the original directory structure is preserved, give the file a .ods extension, and it should open in LibreOffice. There's probably a formal specification of ODF somewhere, but it may be easier to work out the parts you're interested in by making one change at a time and seeing what effect it has on the styles.xml. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Notice to Appear in Court
On 04/19/2015 05:36 PM, toki kantoor wrote: I am an attorney and no court in the USA would use email to summon a I've forgotten the cite, but in a pleading justifying the use of posting a summons to the individual's FaceBook account, the lawyers cited half a dozen cases where the courts had ruled that service via email was acceptable. IIRC, that was to notify of some proceeding, not a summons to court. It's similar to sending a letter to the last know address or taking ads in newspapers. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users]
postmas...@btinternet.com) Subject: Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Alain, I don't know whether you consider this to be simple and automatic but what I've found is this: Use LibreOffice to create a spreadsheet. Select the table space. Use Format=Conditional Formatting=Condition Condition 1: Formula is ISEVEN(ROW()) select or create your style for even rows Add Condition 2: Formula is ISODD(ROW()) select or create your style for odd rows OK Copy the selected cells and paste them into your writer document. This is the best solution I have found. Maybe it will tickle someone else's creativity to come up with a better solution. -- Jim -Original Message- From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 19 Apr 2015 16:23 Subject: Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color At 14:10 15/04/2015 +0200, Alain Ronly wrote: I'm looking for a simple and automatic way how to tell to my tables in a writer document, to be formatted with alternat[]e rows color for example even rows will be blue in the background and odd rows will have a light blue as background color. I did not find any easy way to do it. Is there someone who has already solved this topic ? Not me. o Once you have set the background colour for one row, you can use the Format Paintbrush to paint the same colour on other rows. If you double-click the button, you can drag the paint bucket across alternate rows to achieve one colour and then repeat the process for the other colour. o For large numbers of rows, you can copy an entire existing table and paste it immediately following - and you can repeat that process. You'll end up with multiple tables, but that may suffice, providing you delete the empty paragraph between them. If you need to, you can put the cursor into the second table and go to Table | Merge Tables (or right-click | Merge Tables) to merge the two tables into one. o It is somewhat easier to set up such background colouring in a spreadsheet than in a Writer table. If you colour two rows you can easily copy them to two more. Then you can copy four rows to create eight in total. With this binary multiplication, you can very quickly achieve the desired size. If you then copy an appropriately-sized section of the spreadsheet and paste it into your text document using Paste Special... and HTML (HyperText Markup Language) you will get a table with the same background formatting. The table properties can be adjusted as necessary. o The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function to determine the oddness or evenness of the row number and control the background colouring using cell styles. But unfortunately - and as you might expect - the effect of such formatting is lost if you paste a copy into a text document as a table. So that's a dead duck. o It's probably much easier to set up formatting such as this before you insert your data. If necessary, you should be able to copy any existing material and paste it into a new, formatted table. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Table with alternat[]e row color
At 20:21 19/04/2015 -0700, James E Lang wrote: From: Brian Barker: The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function to determine the oddness or evenness of the row number and control the background colouring using cell styles. But unfortunately - and as you might expect - the effect of such formatting is lost if you paste a copy into a text document as a table. So that's a dead duck. Alain, I don't know whether you consider this to be simple and automatic but what I've found is this: Use LibreOffice to create a spreadsheet. Select the table space. Use Format=Conditional Formatting=Condition Condition 1: Formula is ISEVEN(ROW()) select or create your style for even rows Add Condition 2: Formula is ISODD(ROW()) select or create your style for odd rows OK. Copy the selected cells and paste them into your writer document. This is the best solution I have found. Maybe it will tickle someone else's creativity to come up with a better solution. It's not clear whether you appreciate that this is the method that I described as a dead duck! Could you come clean about exactly how you are making this work, please? Depending on how I paste the cell range from a spreadsheet, I can create: o a striped graphic with no row or column structure - just a picture, o an embedded spreadsheet section, o a blank picture, o a stack of paragraphs containing only sequences of tab characters, or o the required table - but without the background formatting! In particular, freezing the effect of the conditional formatting in the spreadsheet before copying the range of cells to the text document might be expected to work, but I didn't see any way to do this. A striped panel is not going to provide the alternately coloured table rows that the questioner wanted. Do please explain how you have managed to paste the spreadsheet range to create a *formatted table* in the text document. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users]
postmas...@btinternet.com) Subject: Re: [libreoffice-users] Table with alternat[]e row color MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit I performed a simple paste. I guess that technically it's an image (or if you like, a picture) but the contents can be editted. I don't generally use Writer but I do use Calc a lot. I knew that I could generate the alternating color bands in Calc by means of formulas so I first looked for that functionality in Writer to no avail. Then I tried the technique I posted and editted the data successfully so I posted it. Maybe I'm being over sensitive but I sensed hostlity in your response to me. I thought this list was one where everyone (expert or novice) shared for the benefit of all. -- Jim -Original Message- From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Sun, 19 Apr 2015 22:27 Subject: Re: [libreoffice-users] Table with alternat[]e row color At 20:21 19/04/2015 -0700, James E Lang wrote: From: Brian Barker: The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function to determine the oddness or evenness of the row number and control the background colouring using cell styles. But unfortunately - and as you might expect - the effect of such formatting is lost if you paste a copy into a text document as a table. So that's a dead duck. Alain, I don't know whether you consider this to be simple and automatic but what I've found is this: Use LibreOffice to create a spreadsheet. Select the table space. Use Format=Conditional Formatting=Condition Condition 1: Formula is ISEVEN(ROW()) select or create your style for even rows Add Condition 2: Formula is ISODD(ROW()) select or create your style for odd rows OK. Copy the selected cells and paste them into your writer document. This is the best solution I have found. Maybe it will tickle someone else's creativity to come up with a better solution. It's not clear whether you appreciate that this is the method that I described as a dead duck! Could you come clean about exactly how you are making this work, please? Depending on how I paste the cell range from a spreadsheet, I can create: o a striped graphic with no row or column structure - just a picture, o an embedded spreadsheet section, o a blank picture, o a stack of paragraphs containing only sequences of tab characters, or o the required table - but without the background formatting! In particular, freezing the effect of the conditional formatting in the spreadsheet before copying the range of cells to the text document might be expected to work, but I didn't see any way to do this. A striped panel is not going to provide the alternately coloured table rows that the questioner wanted. Do please explain how you have managed to paste the spreadsheet range to create a *formatted table* in the text document. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] CALC
While I'm working in calc, the program is frequently adding a colon followed by a number (usually 2 sometimes 3) at the end of the file name (i.e. after the 'xlsx'). What's that all about? How can I stop it? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC
At 11:07 19/04/2015 -0400, Rob All Jr wrote: While I'm working in calc, the program is frequently adding a colon followed by a number (usually 2 sometimes 3) at the end of the file name (i.e. after the 'xlsx'). What's that all about? You say it adds a colon and number at the end of the file name, as if the file name is being thereby modified. But that's not so: the file name is unchanged but the title bar of the LibreOffice window shows the additional element in addition to the file name. It happens, I think, when you have two windows open to the same file (or perhaps when LibreOffice thinks you do); you can see this easily by clicking Windows | New Window with an existing file open. How can I stop it? Why would you want to? Save the document and close the unnecessary windows. Do you have the document open in some other application? Alternatively, if you prefer not to see the indication, I'd suggest royal blue correcting fluid ... I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
On 4/19/2015 9:16 AM, Andreas Säger ville...@t-online.de wrote: Am 19.04.2015 um 15:05 schrieb Tanstaafl: After prior replies, it appears it may still be there in the 4.4.x series, but maybe only on Windows. I'll be installing the latest 4.4 soon, and will test some more before opening a bug. Will report back here, and ask others to test a bit more and comment, to try to determine a) if it is indeed still there, and b) if it is, is it windows only. Thanks to all for replying... Same behaviour with LO 3.5 LO 4.4.2 AOO 4.1.1 tested under Windows (the latter 2) and Linux (all 3). Hmmm... Graham replied that he saw no evidence of the problem on Linux Mint with 4.4.2... Graham? Can you confirm? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow
I don't get the problem on 4.4.2 running Slackware 14.1 I do get the problem on 4.3.2 and 4.3.6 running Slackware 14.1 I get an erratic selection bug on 4.4.2 under writer which has caused be to go back to 4.3.6. Alex On 19/04/15 15:01, Tanstaafl wrote: On 4/19/2015 9:16 AM, Andreas Säger ville...@t-online.de wrote: Am 19.04.2015 um 15:05 schrieb Tanstaafl: After prior replies, it appears it may still be there in the 4.4.x series, but maybe only on Windows. I'll be installing the latest 4.4 soon, and will test some more before opening a bug. Will report back here, and ask others to test a bit more and comment, to try to determine a) if it is indeed still there, and b) if it is, is it windows only. Thanks to all for replying... Same behaviour with LO 3.5 LO 4.4.2 AOO 4.1.1 tested under Windows (the latter 2) and Linux (all 3). Hmmm... Graham replied that he saw no evidence of the problem on Linux Mint with 4.4.2... Graham? Can you confirm? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
