Re: [libreoffice-users] Reproducing doc files.
Hi :) It is fairly easy to have both office suites. Both are free and relatively light on resources. For your line of work it's probably best to have a few different suites and programs for the next couple of years until things settle down a bit. All the non-MS tend to be quite consistent with each other but many people are still on MS Office and that seems to continue causing these problems with formats. Are you sure it is Doc rather than the newer DocX? The newer one is different for each different version of MS Office so different programs are each better at dealing with different versions of that particular format. People asking for the older MS format might well be using OpenOffice, LibreOffice, Google-docs, Caligra/KOffice, Lotus Symphony or any of the other programs and suites that natively use ODF. They mostly ask for the older MS format because it's easier for them than the newer MS format. So, it might be worth asking some of them if they would prefer ODF instead. Regards from Tom :) On 24 April 2014 22:15, john Culleton j...@wexfordpress.com wrote: In general I use anything in preference to KDE Office apps, but a recent instruction received from a publisher in doc format was read more accurately in Calligra Word than in Libre Office 4.1. Specifically italic type was reproduced in oversized sans-serif bold face in Libre but was reproduced in oversized slanted type in Calligra. I misunderstood the publisher's desires until I used Calligra. He wants italics which is what I normally would have used in the particular situation in an index. Also in Libre certain bold face passages were interpreted as larger sans-serif type which caused some text to over print other text. Neither program scored 100% but Calligra came closer. So I will give it a closer look. Doc format is not my favorite choice of course but some customers insist on it. Copies of the original doc file are available on request. -- John Culleton Wexford Press Free list of books for self-publishers: http://wexfordpress.net/shortlist.html PDF e-book: Create Book Covers with Scribus available at http://www.booklocker.com/books/4055.html -- 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] paste into the edit box
Hi :) The Marketing Team are trying to run a Tip of the day by tweet. This means the tips have to be really tiny, but of course they can link to, or suggest, documentation for further detail. Can anyone here help create a list a of such snippets? Regards from Tom :) On 24 April 2014 20:01, John R. Sowden jsow...@americansentry.net wrote: On 04/23/2014 11:56 AM, libreoffice-ml.mbou...@spamgourmet.com wrote: John R. Sowden wrote: re: alternatives, this is how I use it-might apply to others: Pay credit card on line Copy verification number from web site paste verification number to an empty cell change font from not free sans to free sans copy updated cell with verification number (cannot add to exiting cell with payment description without deleting existing data) Yes, you can. Double-click on the cell to switch to edit mode (or press F2, for those preferring the keyboard), position cursor where you want to add text, right-click (or Edit menu) Paste. This also pastes as unformatted, so you don't even need faff around changing the font if the cell is already formatted as you want it. click on cell where verification number will be appended to description click on input line go to Edit-Paste to paste verification number to cell data press enter empty cell with verification number only If I've understood correctly, I think that routine could be: - Pay credit card on line - Copy verification number from web site - Double-click on cell where verification number will be appended to description (or click in the input line if you prefer, but then you have to use Edit Paste since there is no right-click menu) - Position cursor at the end of the existing content (or wherever you want it) - Right click and paste I agree-it's not a big deal-there are more important issues. Thanks to all, John Excellent. Learned a new LO feature. By the way, when I copied the text that was in a different font, it converted to the font in the edited cell, a win-win. Thanks, John -- 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] forums, The AOO one
On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum https://forum.openoffice.org/en/forum/ and noticed their header claims User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org They were very intentional about that. Does LO even have a separate forum? THe OOoForum has been plagued with spammers since the forum itself has not been maintained so spammers can access it at will. It seems that the spammers have hit it hard enough that it is always slow. When I connect I feel that I can be sure that I will see hundreds (or more) new spam messages since my last visit and not much else. I visited one of the forum topics today and the first 4000 posts on that topic were spam. There are so many that it is not feasible to control it without some level of automation. I gave up trying to keep up with the spam and disabling accounts because I just do not have sufficient time. The official AOO Forum, however, is well maintained and usable. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] forums, The AOO one
Hi On 25 avril 2014 13:06:20 CEST, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum https://forum.openoffice.org/en/forum/ and noticed their header claims User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org They were very intentional about that. Does LO even have a separate forum? THe OOoForum has been plagued with spammers since the forum itself has not been maintained so spammers can access it at will. It seems that the spammers have hit it hard enough that it is always slow. When I connect I feel that I can be sure that I will see hundreds (or more) new spam messages since my last visit and not much else. I visited one of the forum topics today and the first 4000 posts on that topic were spam. There are so many that it is not feasible to control it without some level of automation. I gave up trying to keep up with the spam and disabling accounts because I just do not have sufficient time. The official AOO Forum, however, is well maintained and usable. Having a forum for LibreOffice is an old project and we had several attempts for it. The issue is you need manpower and volunteers to manage and maintain them, clean and block spam etc. If we have these volunteers we will open a forum. As it stands today we have 4 support options: - mailing lists - Nabble (mailing lists via a forum interface) - Ask LibreOffice (Next generation collaborative support site ) - external forums (libreofficeforum.org) So far it may be observed we have pretty much everything covered ;-) . Best, Charles. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On 04/24/2014 06:09 AM, Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) Thanks for mentioning this. :)I think bug hunts are great, but I need to ask this question: how does the current backlog of bugs factor in with these bug hunts? I understand the bug hunts are great for finding new bugs, but I've filed several bug reports, some of which have been stagnant for over six months. Here is an example: https://bugs.freedesktop.org/show_bug.cgi?id=57116 I'm excited about LibreOffice 4.3's release because the software keeps getting better and better. However, it's also a bit frustrating when reported issues exist for a long period of time. Thanks! Peace... Tom On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ List archive: http://listarchives.documentfoundation.org/www/announce/ -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- 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] forums, The AOO one
On 25/04/2014 13:06, Andrew , Its a chame, there must be a solution save all this invaluable information, its still te best place to start coding wint LO and OO Greetz Fernand On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum https://forum.openoffice.org/en/forum/ and noticed their header claims User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org They were very intentional about that. Does LO even have a separate forum? THe OOoForum has been plagued with spammers since the forum itself has not been maintained so spammers can access it at will. It seems that the spammers have hit it hard enough that it is always slow. When I connect I feel that I can be sure that I will see hundreds (or more) new spam messages since my last visit and not much else. I visited one of the forum topics today and the first 4000 posts on that topic were spam. There are so many that it is not feasible to control it without some level of automation. I gave up trying to keep up with the spam and disabling accounts because I just do not have sufficient time. The official AOO Forum, however, is well maintained and usable. -- 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: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
Hello Tom, Le 2014-04-25 15:35, Tom Williams a écrit : On 04/24/2014 06:09 AM, Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) Thanks for mentioning this. :)I think bug hunts are great, but I need to ask this question: how does the current backlog of bugs factor in with these bug hunts? I understand the bug hunts are great for finding new bugs, but I've filed several bug reports, some of which have been stagnant for over six months. Well you're right, it is about finding new bugs (or previously fixed bugs that may reappear) in the development versions. Actually, old or open bugs get fixed at every new release, while others get (unfortunately) introduced. That's the factor you were asking about I guess? Here is an example: https://bugs.freedesktop.org/show_bug.cgi?id=57116 It's not really stagnant. As I read on the bug reports comments, you filed that bug against the 3.6.2 version. This version is obsolete; but someone actually tested the problematic behaviour with a 4.2.0 and the bug was no longer observed: So even it is not informed here, it is solved for the releases in production. So it was fixed somehow. Please keep in mind that bug fixes are only brought to actively supported versions (the ones you can download from the website), not obsolete ones like the 3.6.x branch. I'm excited about LibreOffice 4.3's release because the software keeps getting better and better. However, it's also a bit frustrating when reported issues exist for a long period of time. I hope I have answered your question;of course there are always unresolved issues that are still in the actively supported versions. Devs try hard to squash these bugs, and are very successful at doing that, but there are always some leftovers. Cheers, Charles. Thanks! Peace... Tom On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ List archive: http://listarchives.documentfoundation.org/www/announce/ -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- 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: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On Thursday, April 24, 2014 08:40:40 PM Charles-H. Schulz wrote: Hello Upscope, On 24 avril 2014 18:16:29 CEST, upscope upsc...@nwi.net wrote: On Thursday, April 24, 2014 02:09:16 PM Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe / List archive: http://listarchives.documentfoundation.org/www/announce/ Tom thanks for the heads up. Will 4.3 be available for download in advance of the actual Beta release date/ I have been using the 4.2.4 RC1 on my openSUSE 13.1 for the last week. So far no issues with CALC (at least my spreadsheets). Writer still has problems with a .docx document I get each month. Does not show some of the graphics. The version of Word is 2010. I can enter a bug report if necessary and attach the Writer page and one from the PDF to show what it should look like. By any means, please do, that would help a lot. LibreOffice Bugzilla but it will not accept it under 4.2.3 or 4.3.1. I have attached the .docx and .pdf to this email. I do not know if attachments are allowed. Let me know if you need anything else or if I can test something. I do have the 4.2.4 (direct from LO site) and installed. Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 TDF version on openSUSE 13.1 CODE: -- Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 -- openSUSE version on openSUSE 13.1 CODE: -- Version: 4.1.5.3 Build ID: 410m0(Build:3) -- -- Let me know where to post the bug. Here: https://www.libreoffice.org/get-help/bug/ Thanks, Charles. Thanks -- Russ openSUSE 13.1(Linux 3.11.10-7-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-331.49)|KDE 4.12.4 -- 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: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
Hello Upscope, On 25 avril 2014 19:03:22 CEST, upscope upsc...@nwi.net wrote: On Thursday, April 24, 2014 08:40:40 PM Charles-H. Schulz wrote: Hello Upscope, On 24 avril 2014 18:16:29 CEST, upscope upsc...@nwi.net wrote: On Thursday, April 24, 2014 02:09:16 PM Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe / List archive: http://listarchives.documentfoundation.org/www/announce/ Tom thanks for the heads up. Will 4.3 be available for download in advance of the actual Beta release date/ I have been using the 4.2.4 RC1 on my openSUSE 13.1 for the last week. So far no issues with CALC (at least my spreadsheets). Writer still has problems with a .docx document I get each month. Does not show some of the graphics. The version of Word is 2010. I can enter a bug report if necessary and attach the Writer page and one from the PDF to show what it should look like. By any means, please do, that would help a lot. LibreOffice Bugzilla but it will not accept it under 4.2.3 or 4.3.1. I have attached the .docx and .pdf to this email. I do not know if attachments are allowed. Let me know if you need anything else or if I can test something. I do have the 4.2.4 (direct from LO site) and installed. That's weird. There should be an entry for beta/rc. May I suggest you wait for the bug hunting session? Otherwise I can file the bug myself. Best, Charles. Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 TDF version on openSUSE 13.1 CODE: -- Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 -- openSUSE version on openSUSE 13.1 CODE: -- Version: 4.1.5.3 Build ID: 410m0(Build:3) -- -- Let me know where to post the bug. Here: https://www.libreoffice.org/get-help/bug/ Thanks, Charles. Thanks -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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: Reproducing doc files
Curiously wondering if you're saying that changing the font will change the meaning of the text ;-) surely I've mis-read this message ;-) From: john Culleton j...@wexfordpress.com To: users@global.libreoffice.org Date: Thu, 24 Apr 2014 17:15:08 -0400 Subject: [libreoffice-users] Reproducing doc files. In general I use anything in preference to KDE Office apps, but a recent instruction received from a publisher in doc format was read more accurately in Calligra Word than in Libre Office 4.1. Specifically italic type was reproduced in oversized sans-serif bold face in Libre but was reproduced in oversized slanted type in Calligra. I misunderstood the publisher's desires until I used Calligra. He wants italics which is what I normally would have used in the particular situation in an index. Also in Libre certain bold face passages were interpreted as larger sans-serif type which caused some text to over print other text. Neither program scored 100% but Calligra came closer. So I will give it a closer look. Doc format is not my favorite choice of course but some customers insist on it. Copies of the original doc file are available on request. John Culleton Wexford Press Free list of books for self-publishers: http://wexfordpress.net/shortlist.html PDF e-book: Create Book Covers with Scribus available at http://www.booklocker.com/books/4055.html -- 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: Create Firefox Personas for LibreOffice 4 in LibreOffice 4
I can't access to Youtube. Can anybody tell me what the video say or the steps to Create Firefox Personas for LibreOffice 4? -- View this message in context: http://nabble.documentfoundation.org/Create-Firefox-Personas-for-LibreOffice-4-in-LibreOffice-4-tp4037000p4106442.html Sent from the Users mailing list archive at Nabble.com. -- 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: Envelope printing misplaced
sounds to me as if this is a printer problem; I learned to adjust the paper a certain way in the printer in order to have it print appropriately - for a laser printer, you have to open the machine ... have only the 1 sheet in the slot ... then the page comes out right ;-) BTW - be sure to cross your fingers ;-) From: Stray Feathers brucewhitting...@shaw.ca To: users@global.libreoffice.org Date: Thu, 24 Apr 2014 22:22:50 -0700 (PDT) Subject: [libreoffice-users] Envelope printing misplaced I'm unable to properly print a #10 envelope using Apple Mavericks on a Canon iP2700 printer. Both Sender and Addressee are printed about 25 mm too low. This printer's paper feed automatically centres the envelope so no way to physically adjust it. All settings appear to be correct, with correct sizes and margin spacings indicated, but they print incorrectly. It is possible to adjust these text blocks lower, but not higher in LO. Still learning LO so any suggestions appreciated. -- View this message in context: http://nabble.documentfoundation.org/Envelope-printing-misplaced-tp4106358.html -- 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: Create Firefox Personas for LibreOffice 4 in LibreOffice 4
The Personas used by LibreOffice is stored in the User/Gallery/Personas folder. The access information is stored in the User/registrymodifications.xcu file. The settings are in the PersonasSettings. An example is given below. item oor:path=/org.openoffice.Office.Common/Miscprop oor:name=PersonaSettings oor:op=fusevalueHeader.jpg;Footer.jpg;#ff;#f5f5f5/value/prop/item Where the header and footer are .jpg or .png format. The text colour is #rrbbgg format and the accent the same. Where #00 is black and #ff is white. The Firefox footer and accent are not currently used in LibO. By careful copying and renaming, you can change the LibO personas without needing the Firefox website. Be careful when modifying the registrymodifications.xcu file. Always take a backup before making any changes. Peter -- View this message in context: http://nabble.documentfoundation.org/Create-Firefox-Personas-for-LibreOffice-4-in-LibreOffice-4-tp4037000p4106447.html Sent from the Users mailing list archive at Nabble.com. -- 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: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On Friday, April 25, 2014 07:53:17 PM you wrote: Hello Upscope, On 25 avril 2014 19:03:22 CEST, upscope upsc...@nwi.net wrote: On Thursday, April 24, 2014 08:40:40 PM Charles-H. Schulz wrote: Hello Upscope, On 24 avril 2014 18:16:29 CEST, upscope upsc...@nwi.net wrote: On Thursday, April 24, 2014 02:09:16 PM Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0) , where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri be / List archive: http://listarchives.documentfoundation.org/www/announce/ Tom thanks for the heads up. Will 4.3 be available for download in advance of the actual Beta release date/ I have been using the 4.2.4 RC1 on my openSUSE 13.1 for the last week. So far no issues with CALC (at least my spreadsheets). Writer still has problems with a .docx document I get each month. Does not show some of the graphics. The version of Word is 2010. I can enter a bug report if necessary and attach the Writer page and one from the PDF to show what it should look like. By any means, please do, that would help a lot. LibreOffice Bugzilla but it will not accept it under 4.2.3 or 4.3.1. I have attached the .docx and .pdf to this email. I do not know if attachments are allowed. Let me know if you need anything else or if I can test something. I do have the 4.2.4 (direct from LO site) and installed. That's weird. There should be an entry for beta/rc. May I suggest you wait for the bug hunting session? Otherwise I can file the bug myself. Best, Charles. Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 TDF version on openSUSE 13.1 CODE: -- Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 -- openSUSE version on openSUSE 13.1 CODE: -- Version: 4.1.5.3 Build ID: 410m0(Build:3) -- -- Let me know where to post the bug. Here: https://www.libreoffice.org/get-help/bug/ Thanks, Charles. Thanks Charles if you could file it I would really appreciate it. I need to modify the .docx version some times. If not I can wait. I tried to post the .pdf and .docx document to pastelink, but the .docx would not post there. Waiting to hear from them on problem. The PDF version is posted for 6 more days at: CODE pastelink.me/dl/b74b8a -- Note
[libreoffice-users] Question on MAXIF()
I have a (generated) sheet with 5000 entries where in column H is a book number between 1 and 7, and in column D there are years between 1852 and 2014. Both the booknumbers and the years are not sorted, and are expanded over time. I want to have the min and max year of each individual book. In fact I need something like MINIF, but that does not seem to exist. Something like MIN(D2:D5000 where H2:H5000 = 1) simular for MAX. How can I accomplish this? Any help welcome Rob. NVPH nr JaarNom. Waarde Serie AlbumBlad Album g 1 18525 1 1 . 2 185210 1 1 . 3 185215 3 1 1 . 4 18645 1 1 . 5 186410 1 1 . 6 186415 3 1 1 g 7 18675 1 1 g 8 186710 1 1 . 9 186715 1 1 . 10 186720 1 1 . 11 186725 1 1 . 12 186750 6 1 1 . 13 18690,5 2 1 . 14 18691 2 1 g 15 18691 2 1 -- 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] How to insert a field of a random integer in the range 5 to 20?
Hello, In LibreOffice Writer, how to insert a field of a random integer in the range 5 to 20? This random integer changes every time I open the document. Thanks and regards. -- View this message in context: http://nabble.documentfoundation.org/How-to-insert-a-field-of-a-random-integer-in-the-range-5-to-20-tp4106448.html Sent from the Users mailing list archive at Nabble.com. -- 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] forums, The AOO one
Hi :) Many of the distros have distro-specific forums covering LO along with many other topics. Many articles written about LO have a Comments section at the bottom which often gets comment that are a cry for help or claims that LO can't do this-or-that purely because the person posting has no idea yet, but similar questions here get quick answers. Pivot-tables used to be a popular issue. Many magazines and places have forums or comments threads suffering from a similar lack of knowledge about LO/AOO or OpenSource generally and seem to try to push people back into buying MS Office http://forums.computeractive.co.uk/showthread.php?t=232925 Compared to MS Office 2003 or even Works it was complicated = that's probably because MS Office was pre-installed on their machine but LO requires a few double-clicks. http://forums.pcworld.com/index.php?/topic/147741-alternatve-to-libre-office/ Some languages have a strong enough team that they run forums. Well at least 1! http://www.libreoffice-forum.de/ (at a guess Italy and perhaps Brasil and others run their own too) There is at least 1 unofficial forum; http://libreofficeforum.org/ Originally set-up to show the need but the owner had invested too much into it by the time people started looking at it and it never became official. Perhaps going to follow a similar path to ubuntuforums. It's a shame about the Apache forums being over-run with spam! I didn't notice much at https://forum.openoffice.org/en/forum/ It looked like Hagar co were more active than spammers. Is the OOo one a different link? Perhaps timing or just that i didn't look in the right places in my brief skim-read. Regards from Tom :) On 25 April 2014 12:18, Charles-H. Schulz charles.sch...@documentfoundation.org wrote: Hi On 25 avril 2014 13:06:20 CEST, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum https://forum.openoffice.org/en/forum/ and noticed their header claims User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org They were very intentional about that. Does LO even have a separate forum? THe OOoForum has been plagued with spammers since the forum itself has not been maintained so spammers can access it at will. It seems that the spammers have hit it hard enough that it is always slow. When I connect I feel that I can be sure that I will see hundreds (or more) new spam messages since my last visit and not much else. I visited one of the forum topics today and the first 4000 posts on that topic were spam. There are so many that it is not feasible to control it without some level of automation. I gave up trying to keep up with the spam and disabling accounts because I just do not have sufficient time. The official AOO Forum, however, is well maintained and usable. Having a forum for LibreOffice is an old project and we had several attempts for it. The issue is you need manpower and volunteers to manage and maintain them, clean and block spam etc. If we have these volunteers we will open a forum. As it stands today we have 4 support options: - mailing lists - Nabble (mailing lists via a forum interface) - Ask LibreOffice (Next generation collaborative support site ) - external forums (libreofficeforum.org) So far it may be observed we have pretty much everything covered ;-) . Best, Charles. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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] Re: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On 04/25/2014 08:40 AM, Charles-H. Schulz wrote: Hello Tom, Le 2014-04-25 15:35, Tom Williams a écrit : On 04/24/2014 06:09 AM, Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) Thanks for mentioning this. :)I think bug hunts are great, but I need to ask this question: how does the current backlog of bugs factor in with these bug hunts? I understand the bug hunts are great for finding new bugs, but I've filed several bug reports, some of which have been stagnant for over six months. Well you're right, it is about finding new bugs (or previously fixed bugs that may reappear) in the development versions. Actually, old or open bugs get fixed at every new release, while others get (unfortunately) introduced. That's the factor you were asking about I guess? Not really. I was asking how current backlog bug reports factor in with these bug hunts. As bugs are fixed in each new release, those bug reports are eventually resolved and maybe even closed. They might be reopened if a regression occurs, but that's something different. I do understand the need to find out if new features and functionality either have problems, themselves, or possibly caused regressions but a regression is a break of something that previously worked. A bug report that's still in New status, like my sample bug, hasn't been fixed and my question is: during these bug hunts, is there any effort put into seeing if any of the backlog bug reports have also been fixed or is the intent mostly to focus on the new stuff, making sure new features and functions work properly and to see if any regressions have been introduced. Here is an example: https://bugs.freedesktop.org/show_bug.cgi?id=57116 It's not really stagnant. As I read on the bug reports comments, you filed that bug against the 3.6.2 version. This version is obsolete; but someone actually tested the problematic behaviour with a 4.2.0 and the bug was no longer observed: So even it is not informed here, it is solved for the releases in production. So it was fixed somehow. Please keep in mind that bug fixes are only brought to actively supported versions (the ones you can download from the website), not obsolete ones like the 3.6.x branch. Yep, release 3.6.2 is certainly obsolete but that's the version of the software in which I first experienced the problem. I certainly hope bug reports filed against *now* obsolete releases aren't being ignored. As for the status of my sample bug report being changed to invalid, I'm addressing that now since I experienced the same problem with Writer 4.2.3 on Windows XP. :) I'm excited about LibreOffice 4.3's release because the software keeps getting better and better. However, it's also a bit frustrating when reported issues exist for a long period of time. I hope I have answered your question;of course there are always unresolved issues that are still in the actively supported versions. Devs try hard to squash these bugs, and are very successful at doing that, but there are always some leftovers. Yes, you have and I appreciate your response. :) Peace... Tom Cheers, Charles. Thanks! Peace... Tom On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized
Re: [libreoffice-users] How to insert a field of a random integer in the range 5 to 20?
At 13:37 25/04/2014 -0700, Alf Noname wrote: In LibreOffice Writer, how to insert a field of a random integer in the range 5 to 20? This random integer changes every time I open the document. o In a spreadsheet document, enter =INT(RAND()*16)+5 in a cell. o Save the document. o In your text (Writer) document, go to Insert | Object | OLE Object... . o Select Create from file. o Tick Link to file. o Click Search... and browse to and open your spreadsheet file. o Position and resize the inserted item as necessary. o Each time you open the text document, accept the offer to Update all links?. Provided the spreadsheet file is closed, the formula will be recalculated each time. An alternative is considering whether to construct your entire text document in the form of a spreadsheet. 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
[libreoffice-users] Envelope printing misplaced
I'm unable to properly print a #10 envelope using Apple Mavericks on a Canon iP2700 printer. Both Sender and Addressee are printed about 25 mm too low. This printer's paper feed automatically centres the envelope so no way to physically adjust it. All settings appear to be correct, with correct sizes and margin spacings indicated, but they print incorrectly. It is possible to adjust these text blocks lower, but not higher in LO. Still learning LO so any suggestions appreciated. -- View this message in context: http://nabble.documentfoundation.org/Envelope-printing-misplaced-tp4106358.html Sent from the Users mailing list archive at Nabble.com. -- 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] Your message to LibreOffice awaits moderator approval
Your mail to 'LibreOffice' with the subject error Is being held until the list moderator can review it for approval. The reason it is being held: The message headers matched a filter rule Either the message will get posted to the list, or you will receive notification of the moderator's decision. If you would like to cancel this posting, please visit the following URL: http://lists.freedesktop.org/mailman/confirm/libreoffice/03cdea7506c4806577c640eef57306eb75073b05 -- 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] Question on MAXIF()
At 01:50 26/04/2014 +0200, Rob Jasper wrote:
I have a (generated) sheet with 5000 entries where in column H is a
book number between 1 and 7, and in column D there are years between
1852 and 2014.
Both the booknumbers and the years are not sorted, and are expanded
over time. I want to have the min and max year of each individual book.
In fact I need something like MINIF, but that does not seem to
exist. Something like MIN(D2:D5000 where H2:H5000 = 1) similar for
MAX. How can I accomplish this?
Here's one idea:
o In row 2 of a spare column, say column M, enter =$D2*($H2=COLUMN()-12) .
o Fill this formula down column M.
o Select M2 to M5000 and fill this across the following six columns -
to column S.
o For the minimum year for book 1, enter
=MIN(IF(M2:M5000=0;;M2:M5000)) - but don't press Enter or click
the green tick mark to complete the formula. Instead, press
Ctrl+Shift+Enter. This creates an array formula, which will be shown
in the Input Line surrounded by braces:
{=MIN(IF(M2:M16=0;;M2:M16))} - but note that you cannot achieve
the required effect by typing the braces yourself.
o For the maximum year for book 1, use =MAX(M2:M5000) .
o You can fill these minimum and maximum formulae (wherever they are)
to the right across a further six columns to harvest the values for
the other six book numbers.
How does it work?
o COLUMN() returns the column number of the cell in which its formula
appears. For column M this is 13, so if we subtract 12 this provides
the book number values 1 to 6 in columns M to S.
o The logical expression $H2=COLUMN()-12 evaluates whether the book
number is the one in question.
o When this is multiplied by the year in D2, the logical value is
interpreted as a number - 0 for FALSE and 1 for TRUE. So the result -
in columns M to S - is the year if the row applies to the current
book number and zero otherwise.
o The IF() function creates a notional array of the years in the
current column, but with zeroes replaced by (a sentinel value,
larger than any likely year). The MIN() function then harvests the
minimum year for the current book number, unfettered by those original zeroes.
o The MAX function harvests the maximum year for the current book number.
You can hide the extra columns if you wish, of course, or put them
away on a separate sheet - or anyway exclude them from a print range,
as you are unlikely to want the intermediate values printed.
I'm attaching (perhaps only for the questioner to receive?) a sample
spreadsheet. The years and book numbers are random, so you can press
F9 repeatedly to see how it operates on different data.
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
