[libreoffice-users] Re: North America QA Online Chat
On Thu, Aug 1, 2013 at 9:54 PM, Joe Lee l...@soe.ucsc.edu wrote: 01 Aug 2013 06:46:16 PM PDT, Joel Madero wrote: Look forward to talking tomorrow :) Looking forward to it. Talk to you guys tomorrow! -Joe Great , I updated the Pad with the information -- Mas -- 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: North America QA Online Chat
01 Aug 2013 06:46:16 PM PDT, Joel Madero wrote: Look forward to talking tomorrow :) Looking forward to it. Talk to you guys tomorrow! -Joe -- 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] Fixing Printing Paper Defaults
Original Message From: Budgie aje...@errichel.co.uk To: users@global.libreoffice.org Date: Thu, 01 Aug 2013 22:54:28 +0100 Hi, my first post here. I am presently running LibreOffice 3.5:build-413, Build ID: 350m1(Build:413) on OS: Linux 3.4.47-2.38-desktop x86_64, System: openSUSE 12.2 (x86_64) and KDE: 4.8.5 (4.8.5) release 2openSUSE 12.2 desktop. I know there is a more recent LO version but not on openSUSE 12.2 repo site. I have just had to start using LO as my usual word processor Lotus WordPro (on OS/2 Warp 4.5) is not available as machine is under repair. My main use of LO will be for business correspondence and I need some help with templates. In WordPro my template has company details in the header but I am able to supress this on the second and subsequent sheets. Is it possible to do this in LO and if not how do I achieve the same objective of having different header (blank) on sheets 2 onwards. Also how do I keep numbering in footer correct? Budge Welcome Budge, What you need to do is have two separate Page Styles, one for the first page and one for the remaining pages. See: https://help.libreoffice.org/Writer/Creating_and_Applying_Page_Styles For more detailed information see chapters 6 7 of the Writer User Guide: https://www.libreoffice.org/get-help/documentation/ or: http://www.odfauthors.org/libreoffice/english/writer-guide/published-lo-3.6 Once you have created the styles with the first page header, etc. save the document layout as a template. Chapter 10 of the Writer User Guide covers templates. Hope this helps. Dave -- 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: trying to integrate oracle forms with libreoffice
libreofffice works well with ole, you can test it with the script in this page: http://www.openoffice.org/udk/common/man/tutorial/office_automation.html the problem is that the libreoffice's api is not the same as the one of m. office so you must adapt the ole calls to do the work with libreoffice. this is not a lot of work if you have already worked a bit with libreoffice macros, some months ago I adapted an app which did the calls with jscript in this way and was quite easy the problem happens when the calls are inside a closed source component (probably your situation) or you have an obscure mediator component (my situation) regards -- View this message in context: http://nabble.documentfoundation.org/trying-to-integrate-oracle-forms-with-libreoffice-tp4068433p4068516.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: Printing specific pages in 4.1 writer
Hi Kracked_P_P No, not necessary. I was just asked to post the screens as per our discussion, of both the Windows and Linux version of LO, for future reference and use by others. Regards Andrew Brown On 01/08/2013 03:54 PM, Kracked_P_P---webmaster wrote: On 07/31/2013 06:11 PM, Screwbottle wrote: Hi I was asked to post the screenshots in this reply to Kracked_P_P, on Nabble so here I go http://nabble.documentfoundation.org/file/n4068330/Screenshot1.jpg http://nabble.documentfoundation.org/file/n4068330/Screenshot2.jpg -- View this message in context: http://nabble.documentfoundation.org/Printing-specific-pages-in-4-1-writer-tp4067933p4068330.html Sent from the Users mailing list archive at Nabble.com. I do not use Nabble, but would they want my screenshot of the checkbox? -- 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: Document recovery prompt
April Preston: This is really annoying. Last tonight I downloaded LibreOffice 4 hoping the overwrite would end the problem, but no luck. Can I get help to remedy this? Put this into Explorer's address bar: C:\Users\%USERNAME%\AppData\Roaming\LibreOffice\4\user\backup If there are any files in that folder, remove them. -- 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 - Matching Up Text Fields
On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date and the amount into a single description column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well... daily. G On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker b.m.bar...@btinternet.comwrote: At 21:35 31/07/2013 -0400, Don Parris wrote: Again, I just need to figure out how to extract that bit from the bank's description. Any thoughts on that? As I mentioned, that depends on the precise possibilities in the bank data. If the relevant data is always in the same columns of the relevant records, you can probably extract it using MID(); otherwise you may need to do a more complicated search through the text. Brian Barker -- On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date and the amount into a single description column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well... daily. G On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker b.m.bar...@btinternet.comwrote: yes, left() or mid() is quicker if the contents are fixed. In Don's worse case scenario, where the bank's records have descriptions that are random, unpredictable in length and sequence, and change daily, but at least have predictable strings (eg store name) somewhere in them, try =IF(ISERR(FIND(LOWER(VLOOKUP(D$3,List1,2)),Data.$D4))=1,,D$3) The key elements in the formula are *find *(to tag the transaction) and *vlookup *(to return the entity), with if(), iserr() and lower() acting in support. where a) the formula is repeated for each string in a table alongside the transaction, with each column trying it's luck and the last column identifying the ID (by summing the row of possible ID's where non-responses =0) b) iserr()=1 is used to identify if the transaction contains the key entity (if the field lacks the text, the cell blanks out, if it has the text, it returns the ID of the entity) c) if() is used to tag the transaction with the entity's code d) lower() is used because find() is case sensitive, and ties to the instruction to lower-casify the descriptions in sheet 2 (data) (equally use upper(), though it makes for wider description fields) e) find() is used to see if the description contains the text or not (the actual position of the text is irrelevant) f) vlookup() refers to List1, which is the table of entities and their code g) d$3 is the entity ID at the head of the column, where multiple columns apply their own string to the description _Working example__ _https://docs.google.com/file/d/0B6LXy9sguZVkcXRBbGUxQVVvT1k/edit?usp=sharing gives a working example for 1000 transactions and 31 strings 1. Enter the text string in sheet 1 (summary) - the example allocates the entity ID and allows for 31 entities, where the first 7 are colour coded 2. Drop the bank data in sheet 2 (data)*. Remember to **|format|change case = lower case the descriptions* - the example allows for 1000 transactions 3. See the processing in sheet 3 (analysis) - the 1000 transactions are auto-tagged for 31 texts, the 1st 7 are also colourised 4. Back to sheet 1 (summary), where the entitles are totalled for debits and credits in the month you choose and their frequency counted. The summary page sub-totals the transactions using dsum =IF($H4=0,,DSUM(Result,F$3,$C3:$C4)) There are some embellishments, such as |validation (to show or hide non-key entities and to limit the summary to a month or not) The sheets are protected against changes but there is no password. To edit, just undo the protection. I hope this helps -- 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] When is LibO4.1. for deb going to get desktop integration?
sun shine píše v Út 16. 07. 2013 v 16:53 +0100: Hi When is the LibO4.1 release package for Debian systems going to get the desktop integration directory and files? Similarly, if it isn't going to get those, can someone please update the installation notes for users who want to try out 4.1 but - like me - are looking for the desktop integration which isn't there and how one is supposed to work around that. The debian-menus package has been moved from the DEB/desktop-integration subdirectory to the top level directory. You could install it more easily together with the other packages now. The README file will be updated in the 1st bugfix release 4.1.1, see https://bugs.freedesktop.org/show_bug.cgi?id=67061 Best Regards, Petr -- 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] writer-basic: insert an image from a database binary field
Hello, I'm writing a macro in Basic to create a textdocument that is built up of pieces of text and images that I read from a database. I only find how to insert an image from a file but don't find how to do it if I have my image in a variable. Any help, direction to examples or suggestions will be greatly appreciated. Greetings, Alain -- 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] desktop-integration
Heinrich Stoellinger píše v So 20. 07. 2013 v 17:26 +0200: Hello, I downloaded LO 4.1.0-RC3 yesterday. Looking at the files after tar -xvf ... I find that there still is no desktop-integration directory in the main installation tree of files. Is it meant to be like that? The desktop-integration directory has been removed in LO-4.1. It was there from historical reasons: 1. There was different desktop integration for different RPM-based Linux distributions. They were not longer needed because Linux distros switched to the Freedesktop standard, so the freedestop-menus package should work on all RPM-based distros. 2. The desktop integration packages for different Lo version conflicted. This was solved by versioning the package names, filenames, menu entries. So, you could install the desktop integration for LO 4.1 in parallel with the desktop integration for LO 4.0 We removed the subdirectory to make it easier to install the package. Unfortunately, we forgot to update the installation instructions in the README file. It will be fixed in the 1st bugfix release, 4.1.1, see https://bugs.freedesktop.org/show_bug.cgi?id=67061 Well, the is still one problem with files and directories ownership in the .deb packages. It might cause problems with the desktop integration. See https://bugs.freedesktop.org/show_bug.cgi?id=67388 Best Regards, Petr -- 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] desktop-integration
Hi :) WOW!! :D Top marks to the devs that were involved with this and many thanks to Petr for letting us know too. I think it would be good to publicise this a bit more widely. Surprisingly few people ever seem to read Readmes. it's a good place to start obviously. Perhaps someone could pass it on to the Marketing List to nominate it as an entry in the next announcement? I don't think there is a formal process for that yet but it might help the person that puts the announcements together. There's always a list of things that could go in but it's tricky to pick on the 1 or 2 'killer' features. Regards from Tom :) From: Petr Mladek pmla...@suse.cz To: hc.stoellin...@aon.at Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 2 August 2013, 11:37 Subject: Re: [libreoffice-users] desktop-integration Heinrich Stoellinger píše v So 20. 07. 2013 v 17:26 +0200: Hello, I downloaded LO 4.1.0-RC3 yesterday. Looking at the files after tar -xvf ... I find that there still is no desktop-integration directory in the main installation tree of files. Is it meant to be like that? The desktop-integration directory has been removed in LO-4.1. It was there from historical reasons: 1. There was different desktop integration for different RPM-based Linux distributions. They were not longer needed because Linux distros switched to the Freedesktop standard, so the freedestop-menus package should work on all RPM-based distros. 2. The desktop integration packages for different Lo version conflicted. This was solved by versioning the package names, filenames, menu entries. So, you could install the desktop integration for LO 4.1 in parallel with the desktop integration for LO 4.0 We removed the subdirectory to make it easier to install the package. Unfortunately, we forgot to update the installation instructions in the README file. It will be fixed in the 1st bugfix release, 4.1.1, see https://bugs.freedesktop.org/show_bug.cgi?id=67061 Well, the is still one problem with files and directories ownership in the .deb packages. It might cause problems with the desktop integration. See https://bugs.freedesktop.org/show_bug.cgi?id=67388 Best Regards, Petr -- 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] Printing specific pages in 4.1 writer
Hi :) We just got an Oki MB471 Dead easy to set-up to print and does all the duplexing and everything just fine. Oki had a ppd driver on their website. There is no driver for faxing and i haven't tried scanning yet either. I thought the whole thing was going to be a total nightmare in GnuLinux because our Oki C810 still doesn't work. There was a ppd for the C610 but that doesn't work for the 810. The main problem for me is that there seems to be hundreds of drivers that are listed through OpenPrinting and places specifically for the C810 but none of the ones i have tried so far work at all. So, i was quite surprised that it took about 10mins per machine to sort the MB471 in GnuLinux but about an hour to go through the Windows installer. Hewlett Packard just seem to be easy whichever system you are using. They seem to last longer and even appear in 2nd hand listings which hardly any other printers do. Ages ago i asked this list for advice about the best printer to choose and got some good advice which my boss ignored. Regards from Tom :) From: Andrew Brown andre...@icon.co.za To: Kracked_P_P---webmaster webmas...@krackedpress.com Cc: users@global.libreoffice.org Sent: Wednesday, 31 July 2013, 22:46 Subject: Re: [libreoffice-users] Printing specific pages in 4.1 writer Hi Kracked_P_P You have me all quizzy now about it too. I own a Brother MFC-J6510DW large format multifunction printer, quite a process to set it up in Ubuntu (like you from 10.04 to present 13.04) and this box was ticked by default in LO's settings. I will experiment with it unticked and see if it affects my printer. Regards Andrew Brown On 31/07/2013 09:33 PM, Kracked_P_P---webmaster wrote: When I had the issue with the duplexing on one printer, it seemed that everyone who was helping must have been on Windows, since they did not know what I was talking about with the extra dialog check box. Why it is listed in the Linux [Ubuntu 10.04LTS and 12.04LTS for me back then] and not in the Windows installs, I was never given a good answer. I was told that it was just needed for Linux and not for Windows. Then the fact that for some printers the check box needed to be checked, while other did not, tended to make the issue a little worse to figure out. On 07/31/2013 06:21 AM, Andrew Brown wrote: Hi Kracked_P_P OK, you are correct in that there is an extra dialogue box for the Linux version of LO, in my case LO 4.0.4.2 running under Ubuntu 130.04 Raring Ringtail. See the screenshots below now from Linux. If others want to see this then I will make an entry on Nabble. The print settings seem the same except for the extra tick box to do PDF as Standard Print Job Format Regards Andrew Brown On 31/07/2013 09:56 AM, Andrew Brown wrote: HI Kracked_P_P As to my statement, here is a screenshot of the Windows version of LO 4.0.4.3. indicating the option to check Use LiberOffice dialogues under General. I'll look under my Linux (dual boot) to see what you are referring to. You should see these screenshot, but it will be stripped when forwarded onto the global mail. Nothing under the Print section Regards On 30/07/2013 04:26 PM, Kracked_P_P---webmaster wrote: Last time I checked, Windows version did not have the --- Use LibreOffice dialogs in the Print dialogs section. I do not think the Print dialogs would be, or should be, listed under open/save dialogs section. That would not make sense. Are you saying the print dialogs check box is actually listed in that section of the General dialog box? Well, I have not installed 4.1 yet, but the Print dialogs option was shown on the DEB 64-bit version [Ubuntu 12.04 and 13.04 installed] and not on the Windows version [Win7 professional and home premium installed] When I was having all my issues with my printer[s] not duplexing correctly, it seemed that most of the people who tried to help were Windows users. None of the even suggested the print dialog check/uncheck option. After a few weeks, I just started experimenting and found that checking the print dialogs option would make the Epson Artisan 810 printer duplex correctly. The HP Laserjet 2300dn duplexing worked either way. Now that I have a Cannon MG6220 to replace the Epson, I have not unchecked that box to see if the duplexing still worked. On 07/30/2013 03:05 AM, Andrew Brown wrote: Hi Kracked_P_P One correction, your last statement, the option to check Use LiberOffice dialogues is available for Windows users under the same Tools / Options / LibreOffice / General. In this part of the General settings it's under the heading Open/Save dialogues. Regards Andrew Brown On 30/07/2013 02:11 AM, Kracked_P_P---webmaster wrote: On 07/29/2013 03:36 PM, sun shine wrote: Hello list On a Debian like system (Mint 14), my newly installed 32-bit LibO-4.1. is
Re: [libreoffice-users] Fwd: Tavutus [= Hyphenation]
At 16:25 02/08/2013 +0100, Brian Barker wrote: From: Timo Kivelä timo.kiv...@kolumbus.fi (not subscribed) Hei Latasin OpenOffice version 4. Writer ei osaa t[a]vuttaa. Aaargh! This message was originally sent to the Apache OpenOffice Users list. I forwarded the translation to this LibreOffice Users list by mistake. Many apologies. 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] Fwd: Tavutus [= Hyphenation]
From: Timo Kivelä timo.kiv...@kolumbus.fi (not subscribed) Hei Latasin OpenOffice version 4. Writer ei osaa t[a]vuttaa. Käytettävissä olevat kielimoduulit ikkuna on tyhjä, Muokkaa nappula on himmeänä, joten se ei toimi. Miten saan tavutuksen käyttöön? Kiitän vastauksesta jo etukäteen Timo Kivelä Or, in English: Hello I downloaded the Open Office version 4. Writer does not know how to hyphenate. Available language modules window is empty, the Edit button is greyed out so it does not work. How do I get hyphenation? Thank you very much in advance Timo Kivelä -- 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] Fwd: Tavutus [= Hyphenation]
Hi :) Personally i am glad to hear the the 2 communities do still work together from time to time and that some people help in both projects. It feels much better that way rather than feeling like it's us against them when we are all really aiming for much the same thing and that is Freedom OF Choice. Both project offer slightly different things so it makes more sense to work together. Together we stand. Divided we .. err well in this case we still do well but it's better with 2 of us than just 1. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Cc: Timo Kivelä timo.kiv...@kolumbus.fi Sent: Friday, 2 August 2013, 16:33 Subject: Re: [libreoffice-users] Fwd: Tavutus [= Hyphenation] At 16:25 02/08/2013 +0100, Brian Barker wrote: From: Timo Kivelä timo.kiv...@kolumbus.fi (not subscribed) Hei Latasin OpenOffice version 4. Writer ei osaa t[a]vuttaa. Aaargh! This message was originally sent to the Apache OpenOffice Users list. I forwarded the translation to this LibreOffice Users list by mistake. Many apologies. 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] Re: [libreoffice-marketing] Time for Linux Journal's Readers' Choice Awards nominations
2013/8/1 Tom Davies tomdavie...@yahoo.co.uk: From: Jean Weber To: LibreO - Marketing Global market...@global.libreoffice.org Sent: Thursday, 1 August 2013, 19:50 Subject: [libreoffice-marketing] Time for Linux Journal's Readers' Choice Awards nominations http://www.linuxjournal.com/content/readers-choice-awards-2013-nomination Item 29 is Best Office Suite, but you may also wish to nominate your preferred programs in other categories as well. Thanks. I just nominated Apache OpenOffice in that category. I have had much less problems with it than with LibreOffice. It even fixed a spreadsheet of mine that LibreOffice corrupted… Voting occurs later in August. Yes, but what year? I quote: ”Remember, voting will open on August 2, 2011. Please be sure to visit www.linuxjournal.com/rc2011 after that time to cast your vote in the 2011 Readers' Choice Awards!” Okay, maybe they live in a special time zone. Here in Sweden it has been 2013 for quite a while now. I guess we are a little bit ahead… :P Johnny Rosenberg --Jean -- 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: [libreoffice-marketing] Time for Linux Journal's Readers' Choice Awards nominations
Hi :) Often feels like they haven't quite reached 1998 yet in this country Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: Users@Global.LibreOffice.Org Users@global.libreoffice.org Sent: Friday, 2 August 2013, 18:44 Subject: Re: [libreoffice-users] Re: [libreoffice-marketing] Time for Linux Journal's Readers' Choice Awards nominations 2013/8/1 Tom Davies tomdavie...@yahoo.co.uk: From: Jean Weber To: LibreO - Marketing Global market...@global.libreoffice.org Sent: Thursday, 1 August 2013, 19:50 Subject: [libreoffice-marketing] Time for Linux Journal's Readers' Choice Awards nominations http://www.linuxjournal.com/content/readers-choice-awards-2013-nomination Item 29 is Best Office Suite, but you may also wish to nominate your preferred programs in other categories as well. Thanks. I just nominated Apache OpenOffice in that category. I have had much less problems with it than with LibreOffice. It even fixed a spreadsheet of mine that LibreOffice corrupted… Voting occurs later in August. Yes, but what year? I quote: ”Remember, voting will open on August 2, 2011. Please be sure to visit www.linuxjournal.com/rc2011 after that time to cast your vote in the 2011 Readers' Choice Awards!” Okay, maybe they live in a special time zone. Here in Sweden it has been 2013 for quite a while now. I guess we are a little bit ahead… :P Johnny Rosenberg --Jean -- 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 -- 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 - Matching Up Text Fields
Hi Errol, Many thanks for the example. I will play with this over the weekend to see how it works. I will drop a note (probably next week) to let you know how it goes. I've been blogging about my project here and there, so maybe this will be another step I can blog about. My post about connecting LOBase to PostgreSQL is still the top-ranked story on my site, so hopefully I can add some more LO action. :-) On Fri, Aug 2, 2013 at 6:23 AM, Errol Goetsch er...@xe4.org wrote: On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date and the amount into a single description column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well... daily. G On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker b.m.bar...@btinternet.com **wrote: At 21:35 31/07/2013 -0400, Don Parris wrote: Again, I just need to figure out how to extract that bit from the bank's description. Any thoughts on that? As I mentioned, that depends on the precise possibilities in the bank data. If the relevant data is always in the same columns of the relevant records, you can probably extract it using MID(); otherwise you may need to do a more complicated search through the text. Brian Barker -- On 2013/08/01 11:31 AM, Don Parris wrote: Unfortunately, one bank throws everything except for the date and the amount into a single description column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well... daily. G On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker b.m.bar...@btinternet.com **wrote: yes, left() or mid() is quicker if the contents are fixed. In Don's worse case scenario, where the bank's records have descriptions that are random, unpredictable in length and sequence, and change daily, but at least have predictable strings (eg store name) somewhere in them, try =IF(ISERR(FIND(LOWER(VLOOKUP(**D$3,List1,2)),Data.$D4))=1,,**D$3) The key elements in the formula are *find *(to tag the transaction) and *vlookup *(to return the entity), with if(), iserr() and lower() acting in support. where a) the formula is repeated for each string in a table alongside the transaction, with each column trying it's luck and the last column identifying the ID (by summing the row of possible ID's where non-responses =0) b) iserr()=1 is used to identify if the transaction contains the key entity (if the field lacks the text, the cell blanks out, if it has the text, it returns the ID of the entity) c) if() is used to tag the transaction with the entity's code d) lower() is used because find() is case sensitive, and ties to the instruction to lower-casify the descriptions in sheet 2 (data) (equally use upper(), though it makes for wider description fields) e) find() is used to see if the description contains the text or not (the actual position of the text is irrelevant) f) vlookup() refers to List1, which is the table of entities and their code g) d$3 is the entity ID at the head of the column, where multiple columns apply their own string to the description _Working example__ _https://docs.google.com/file/**d/**0B6LXy9sguZVkcXRBbGUxQVVvT1k/** edit?usp=sharinghttps://docs.google.com/file/d/0B6LXy9sguZVkcXRBbGUxQVVvT1k/edit?usp=sharinggives a working example for 1000 transactions and 31 strings 1. Enter the text string in sheet 1 (summary) - the example allocates the entity ID and allows for 31 entities, where the first 7 are colour coded 2. Drop the bank data in sheet 2 (data)*. Remember to **|format|change case = lower case the descriptions* - the example allows for 1000 transactions 3. See the processing in sheet 3 (analysis) - the 1000 transactions are auto-tagged for 31 texts, the 1st 7 are also colourised 4. Back to sheet 1 (summary), where the entitles are totalled for debits and credits in the month you choose and their frequency counted. The summary page sub-totals the transactions using dsum =IF($H4=0,,DSUM(Result,F$3,$**C3:$C4)) There are some embellishments, such as |validation (to show or hide non-key entities and to limit the summary to a month or not) The sheets are protected against changes but there is no password. To edit, just undo the protection. I hope this helps -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly
Re: [libreoffice-users] eastern font in new version
All quiet on the eastern font, then... :-) 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] eastern font in new version
On 08/02/2013 09:03 AM, Mark Stanton wrote: All quiet on the eastern font, then... :-) Mark Does anybody know if the old Atari game, Eastern Front has been ported to Linux, or even to Windows? --doug -- Blessed are the peacemakers..for they shall be shot at from both sides. --A.M.Greeley -- 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
