[libreoffice-users] Pasting Draw tables into Writer
Hello! I've got a little bit of a problem. I have the habit of creating graphs, charts and other stuff in Draw, grouping their elements together, and pasting them into Writer documents. I guess this is how things are meant to be done. But I've come into a peculiarity. Today I created a table in Draw, together with some coloured cells and formated text inside them. When I pasted it into Writer, everything went ok, except for the formatting of the text inside the cells, which turned ”normal” - I was using Liberation Serif Bold and the text turned into a plain sans-serif font (I guess it's Liberation Sans). Is this a bug or not? Am I doing right what I'm doing? Thank you in advance. Petru -- For unsubscribe instructions e-mail to: users+h...@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] LO Base - calculating dates
I think (without actually having tried it) that just adding numbers to a date field will do what you want, so your date field+365 should give you the year in advance date Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Hi Sonic, I would think you could register the new database in the spreadsheet by going to tooloptionsLibreOffice BaseDatabases. I've never tried that though. I know it works for odb files. Don On 01/27/2012 10:39 PM, sonic wrote: HI, i'm facing a problem which doing mailmerge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to remove or del or update new data... may i know is there any solutions TQ i have try using file - wizard- address data souirce- other external data source - no SDBC driver found -- View this message in context: http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3695185.html Sent from the Users mailing list archive at Nabble.com. -- ** -- For unsubscribe instructions e-mail to: users+h...@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: LWP documents
Hi :) If you want to post the document at Nabble just follow the link from this email or navigate to the thread from the official website and reply to any of the posts in the thread. Click on the button labelled More and the top option in the list is Upload file which creates a link directly in the message box. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/LWP-documents-tp3695300p3695796.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Hi :) It 'should' be reasonably easy to update, delete or add new records to an address book using Base. Is it possible to use a different connector to your data? Regards from Tom :) --- On Sat, 28/1/12, sonic ghostbusters_so...@hotmail.com wrote: From: sonic ghostbusters_so...@hotmail.com Subject: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 3:39 HI, i'm facing a problem which doing mail-merge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to remove or del or update new data... May i know is there any solutions? TQ i have try using file - wizard - address data source - other external data source - no SDBC driver found -- For unsubscribe instructions e-mail to: users+h...@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] capitalization
Hi :) |It sounds like something in auto-correct to me. What sorts of words are getting capitalised? Days of the week, place names, first word in a sentence, stuff like that? Hmm, now that i have looked in Tools - AutoCorrect Options I can't see places names and days listed. Apols and regards from Tom :) --- On Fri, 27/1/12, lee l...@songoku.yagibdah.de wrote: From: lee l...@songoku.yagibdah.de Subject: [libreoffice-users] capitalization To: users@global.libreoffice.org Date: Friday, 27 January, 2012, 23:39 Hi, why does LO change words I type to begin with a capital letter instead of the small letter I typed, and how do I prevent that? It´s a bug that needs to be fixed ... -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
El 28/01/12 14:50, Tom Davies escribió: Hi :) It 'should' be reasonably easy to update, delete or add new records to an address book using Base. Is it possible to use a different connector to your data? Regards from Tom :) --- On Sat, 28/1/12, sonicghostbusters_so...@hotmail.com wrote: From: sonicghostbusters_so...@hotmail.com Subject: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 3:39 HI, i'm facing a problem which doing mail-merge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to remove or del or update new data... May i know is there any solutions? TQ i have try using file - wizard - address data source - other external data source - no SDBC driver found Once you have registered in Base as spredsheet, you can do the modifications directly in the spreadsheet without using base. Only the registration in base is needed. Maybe this extension (FastMailMerge)is what you need: http://extensions.services.openoffice.org/en/project/FMM Miguel Ángel * Inglés - detectado * Inglés * Español * Inglés * Español javascript:void(0); -- For unsubscribe instructions e-mail to: users+h...@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] capitalization
Auto-correct is something I do not like for the capitalizing. It tends to require capitals for the first word in each physical line, even when it is not wanted or needed. Look at your Auto Correction options carefully. Choose the ones you really want to help you while you are typing the words and such. You still can do the corrections after you write the draft of the paragraph and not have the auto-correction options interfere with your flow of thought. On 01/28/2012 09:04 AM, Tom Davies wrote: Hi :) |It sounds like something in auto-correct to me. What sorts of words are getting capitalised? Days of the week, place names, first word in a sentence, stuff like that? Hmm, now that i have looked in Tools - AutoCorrect Options I can't see places names and days listed. Apols and regards from Tom :) --- On Fri, 27/1/12, leel...@songoku.yagibdah.de wrote: From: leel...@songoku.yagibdah.de Subject: [libreoffice-users] capitalization To: users@global.libreoffice.org Date: Friday, 27 January, 2012, 23:39 Hi, why does LO change words I type to begin with a capital letter instead of the small letter I typed, and how do I prevent that? It´s a bug that needs to be fixed ... -- For unsubscribe instructions e-mail to: users+h...@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: [libreoffice-documentation] please help
Hi :) The best place to ask questions is the Users List so i have forwarded your email to them. It seems that you have not subscribed to any of the lists yet so your emails get stuck in a queue waiting for a moderator to approve them before they can be sent to the list. It also means you are unlikely to receive answers directly so i have used Reply to all to try to CC this message to you. There might be more recently updated documentation at http://wiki.documentfoundation.org/Documentation/Publications The guides for the 3.4.x branch might contain more than the ones at the official site (at the moment). I think the official site is waiting for more of the 3.4.x chapters to be completed before upgrading. Sorry i don't know the actual answer! I hope this message helps sort out a few other things though! Good luck and regards from Tom :) --- On Fri, 27/1/12, UDAY Y MARATHE uymara...@rcfltd.com wrote: From: UDAY Y MARATHE uymara...@rcfltd.com Subject: [libreoffice-documentation] please help To: documentat...@global.libreoffice.org Date: Friday, 27 January, 2012, 10:02 res. sir/madam, i would like to know how to use setValue function(i.e. to set cell value using macro).which is not included in help pdf file(LibreOffice 3Calc Guide). please help. regards, marathe -- For unsubscribe instructions e-mail to: users+h...@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] was: LWP documents
The issue back then was everyone had their own proprietary file format, since there was no common one that could be used by any company, except txt and other formats that did not keep the file's formatting properly. No company would allow you to use their proprietary formats. The there was a movement to create a common file format that everyone could use. In the end, that set of document formats developed into the Open Document Formats. Now any company can use this non-proprietaryset of document formats to create, read, or edit documents created by other companies' packages. Yes, it was total chaos. I remember having to manually edit some document files in a text editor to remove the formatting codes so it could be read by a different word processor, since the facility did not have that package. That worked for some formats, but not others. Now there is one standard ODF, although Microsoft would say it is their formats. Yes MSO formats have dominated the field of what formats are used, but MS did not share its proprietary formats with the competitors. OOo and LO had to reverse-engineer its ability to read MSO formats. MS did try to get its XML based formats [docx and such] made into an International standard, but would not give up control of its development, which is a requirement to make it fully an open standard - no one company can control an open standard, since it would have its development controlled by an international committee of companies and groups of people/users who want to make it better. MS wanted to publish a version of their standard in a way that there would be still proprietary parts to the open standard that required MS products to use them properly. Also they wanted to decide what would be done to that standard without any other company/group having a say. This is a sore subject for some of us, with all of MS's legal [and illegal] behind the scenes politics [and bribery] to make their open formats be THE international standard after the vote decided on ODF as the [one an only] ISO standard for office document formats. Chaos was the past. Greed is what is going on now. The true use of a free open format by most [hopefully all] of the office packages should be our future. LO uses ODF as their default. As changes are proposed and developed, LO should modify its filters/programming to use those modifications of ODF properly in their created/edited documents. LO/TDF is not in control of that format, but can offer up proposals to make it work better in the real world of office use. MS wants every user to use their open formats, but you must use their office package to use it fully and properly. MS does not want to hand over the ability of its competitors to read/write/edit files created with their packages, so that users no longer need to use its office package. That was the way of most of the word processors and office packages in the past. Most of them, excluding MS, have decided that it would be better to go with the international movement and be able to properly read/write/edit a single fully open set of document formats, instead of forcing users to buy their package to read/write/edit files that were created with their packages. It is better to use an ISO set of document formats. Now these office packages will be used if and only if they are determined to be the best/easiest package for the users to get their word done. LO and other FOSS packages include the idea of best to include free in its definition. For many of us, with limited budgets and other issues, choose free over paid packages. Why pay for software when you can legally get software that does the same thing for free? FOSS package creators do not have the must make as much profit attitude as companies like MS does. That attitude is what drove the file format chaos of the early days of desktop computing. Now that that industry has grown out if its childhood years, we need to survive its teenage years. The concept of true openness of the Internet hopefully will make its adulthood a much better place, with less chaos and with a more grown up attitude like what people should teach their children to make them a better adult. On 01/28/2012 02:43 AM, soumalya ray wrote: i was just wondering-there are so many file formats in this world.if this is the case now,what was the picture 5-10 years back!!its a total chaos. -- For unsubscribe instructions e-mail to: users+h...@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 mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Dear Tom, yes my problem is after i using spreadsheet creating a data table ,however than registered in data source, now i wan make an easy ways if i wan to edit the data which in table but already registered in data source, but i got no ways to edit the data table in the data source , how to do it without opening librercalc and reedit the table on the spreadsheet and redo the registered in data source. is possible to use other connect for my data as long as the ways doing it is easy =) hope u can help TQ Date: Sat, 28 Jan 2012 05:51:44 -0800 From: ml-node+s969070n3695811...@n3.nabble.com To: ghostbusters_so...@hotmail.com Subject: Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ Hi :) It 'should' be reasonably easy to update, delete or add new records to an address book using Base. Is it possible to use a different connector to your data? Regards from Tom :) --- On Sat, 28/1/12, sonic [hidden email] wrote: From: sonic [hidden email] Subject: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ To: [hidden email] Date: Saturday, 28 January, 2012, 3:39 HI, i'm facing a problem which doing mail-merge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to remove or del or update new data... May i know is there any solutions? TQ i have try using file - wizard - address data source - other external data source - no SDBC driver found -- For unsubscribe instructions e-mail to: [hidden email] 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3695811.html To unsubscribe from create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/create-mailmerge-with-spreadsheet-librecalc-without-using-libre-base-pls-help-how-to-do-it-TQ-tp3695185p3696072.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Re: Problem printing an .xls file
On Fri, 27 Jan 2012 13:35:03 -0500, Don C. Myers wrote: Ubuntu 11.10 with LibreOffice 3.4.5 downloaded from LibreOffice. Someone in the Mandriva newsgroup thought you might be interested in his comments: Can't help except perhaps indirectly, sorry File prints in LO 3.4.4 here if I have margins set to 0 and text size is right (small enough), on two printers and computers wildly different and in Fedora Core 16 for Linux side (modern CUPS and Gutenprint). Possibly a Mandriva-side issue, but the single data point from Ubuntu could be even margin defaults in drivers from older driver sets (old printer for example). I remember having a Epson C84 inkjet printer, and the page as driven by a much older CUPS than 2.5.6 with Gutenprint only very limitedly linked in had page offset in mapping (even on test page) with page offset to left by almost an inch until I told the developer about the problem and he and I engaged in a month-long conversation in email and the then active linuxprinting.org (Sponsored by the then Mandrake, one of the things that drew me to that distro to buy was their sponsored linuxprinting.org and sponsorship of a bunch of Linux printing driver devs) posts that ended up with the printer driver working in CUPS-Gutenprint. I would tell him how much I had to adjust page manually in page offsetting, and he would default that into code. No internal offset (which during development and adjustment varied a lot as to which way and how much) and exaggeration of size of font and spaces and underline widths which would give a cutoff on right given that CUPS treats everything as if it had 300 dots per inch until much more recently with Gutenprint doing a lot of the background drivere work for more than 1000 printers, and HPijs doing driver work for many HP lasers. General rule, the more modern CUPS and Gutenprint are for printing, the better more drivers are. Printer driver developers are poor, so they tend to not afford to buy a lot of printers themselves-- the C84 was very popular in US, less so in Europe. Now that the printer driver devs are getting more feedback faster, drivers are better faster. He had an Epson C82 to use, donated to him, but the C84 had enough differences that a driver had to be extremely adjusted to work with a C84. He changed things slowly, told me when a new update was ready, and I downloaded the updated driver set often-- I wanted to not spend $200.00 US on a good printer to replace my C84. The Ubuntu user might possibly benefit from this somewhat long post, so I include it here for forwarding. Mandriva of PowerPack or 2010 varieties without CUPS and Gutenprint and driver sets updated to current, might also have such issues. As I said earlier, OpenOffice prints the file perfectly... -- /\/\aurice -- For unsubscribe instructions e-mail to: users+h...@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] Problem downloading 3.4.5 for Mac Intel
I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? -- For unsubscribe instructions e-mail to: users+h...@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 mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Le 28/01/12 04:39, sonic a écrit : Hi Sonic, may i know is there any solutions TQ i have try using file - wizard- address data souirce- other external data source - no SDBC driver found Have you tried with LibreOffice 3.5RC2 ? There were known issues on some OSes with previous 3.4.x versions. Alex -- For unsubscribe instructions e-mail to: users+h...@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: Problem printing an .xls file
On Fri, 27 Jan 2012 17:25:00 +, I wrote: The file referenced below prints correctly under OpenOffice Writer 3.2.1, but not with LO 3.4.5.+ Same problem reported om Mandriva and Mageia - in my case at least with a fully-updated Mandriva 2010.2 PowerPack. Seems what is happening is that although LO-Calc's Print Preview shows the file in Landscape, it is sending a Portrait image to the printer, which then barfs after reaching the H.C. column. Will raise bug report... -- /\/\aurice -- For unsubscribe instructions e-mail to: users+h...@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] was: LWP documents
very well said. On 28 January 2012 20:44, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: The issue back then was everyone had their own proprietary file format, since there was no common one that could be used by any company, except txt and other formats that did not keep the file's formatting properly. No company would allow you to use their proprietary formats. The there was a movement to create a common file format that everyone could use. In the end, that set of document formats developed into the Open Document Formats. Now any company can use this non-proprietaryset of document formats to create, read, or edit documents created by other companies' packages. Yes, it was total chaos. I remember having to manually edit some document files in a text editor to remove the formatting codes so it could be read by a different word processor, since the facility did not have that package. That worked for some formats, but not others. Now there is one standard ODF, although Microsoft would say it is their formats. Yes MSO formats have dominated the field of what formats are used, but MS did not share its proprietary formats with the competitors. OOo and LO had to reverse-engineer its ability to read MSO formats. MS did try to get its XML based formats [docx and such] made into an International standard, but would not give up control of its development, which is a requirement to make it fully an open standard - no one company can control an open standard, since it would have its development controlled by an international committee of companies and groups of people/users who want to make it better. MS wanted to publish a version of their standard in a way that there would be still proprietary parts to the open standard that required MS products to use them properly. Also they wanted to decide what would be done to that standard without any other company/group having a say. This is a sore subject for some of us, with all of MS's legal [and illegal] behind the scenes politics [and bribery] to make their open formats be THE international standard after the vote decided on ODF as the [one an only] ISO standard for office document formats. Chaos was the past. Greed is what is going on now. The true use of a free open format by most [hopefully all] of the office packages should be our future. LO uses ODF as their default. As changes are proposed and developed, LO should modify its filters/programming to use those modifications of ODF properly in their created/edited documents. LO/TDF is not in control of that format, but can offer up proposals to make it work better in the real world of office use. MS wants every user to use their open formats, but you must use their office package to use it fully and properly. MS does not want to hand over the ability of its competitors to read/write/edit files created with their packages, so that users no longer need to use its office package. That was the way of most of the word processors and office packages in the past. Most of them, excluding MS, have decided that it would be better to go with the international movement and be able to properly read/write/edit a single fully open set of document formats, instead of forcing users to buy their package to read/write/edit files that were created with their packages. It is better to use an ISO set of document formats. Now these office packages will be used if and only if they are determined to be the best/easiest package for the users to get their word done. LO and other FOSS packages include the idea of best to include free in its definition. For many of us, with limited budgets and other issues, choose free over paid packages. Why pay for software when you can legally get software that does the same thing for free? FOSS package creators do not have the must make as much profit attitude as companies like MS does. That attitude is what drove the file format chaos of the early days of desktop computing. Now that that industry has grown out if its childhood years, we need to survive its teenage years. The concept of true openness of the Internet hopefully will make its adulthood a much better place, with less chaos and with a more grown up attitude like what people should teach their children to make them a better adult. On 01/28/2012 02:43 AM, soumalya ray wrote: i was just wondering-there are so many file formats in this world.if this is the case now,what was the picture 5-10 years back!!its a total chaos. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@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
Re: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel
2012/1/28 Robert Peirce b...@peirce-family.com I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? -- For unsubscribe instructions e-mail to: users+h...@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 Hello, I use Firefox or Chrome to download LibO. Did you try using another browser than Safari? I just did a download of LibO 3.4.5 without any proble, less than a minute. I didn't see another download link, even when you go to one of the international pages, they bring you back to the same download place in another language. Yu could try a bittorrent, but I don't know if the result is better (takes longer too). I'd say, try again... good luck, -- Guy using LibO 3.5 and 3.4.5 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- For unsubscribe instructions e-mail to: users+h...@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] Problem downloading 3.4.5 for Mac Intel
Hi :) There are a lot of unofficial places. Maybe this one for Mac? http://www.macupdate.com/app/mac/35446/libreoffice Sourceforge is often a good place imo http://sourceforge.net/projects/libreoffice/ Softonic looked like fun http://libreoffice.en.softonic.com/ http://download.cnet.com/LibreOffice/3000-18483_4-75337651.html A google search found loads more but those were names i vaguely recognised (apart from the Mac one). Regards from Tom :) --- On Sat, 28/1/12, Robert Peirce b...@peirce-family.com wrote: From: Robert Peirce b...@peirce-family.com Subject: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 13:10 I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Problem downloading 3.4.5 for Mac Intel
Hi :) Another idea might be to try downloading the torrent file and then open that to download the main program. Torrrents work even if they get interrupted so they are great if your wireless connection drops-out occasionally (perhaps your router might need a reboot or something). The first file that you download is tiny and just keeps track of which parts you have downloaded so far and which still need to be downloaded. It also keeps track of how much you have uploaded back to other people to keep track of your kudos ;) Regards from Tom :) --- On Sat, 28/1/12, Robert Peirce b...@peirce-family.com wrote: From: Robert Peirce b...@peirce-family.com Subject: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 13:10 I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: LibreOffice Calc: Update External Link Question
Am 27.01.2012 22:29, Steve Smith wrote: Understand linking, I think. My question is updating the link. If the source spreadsheet is not opened when a link to external file is updated (Edit - Links... - Update), I receive a #REF! error. Again, I'm aware of 5 different ways to link spreadsheet contents in ODF spreadsheets. All of them work. We can not know what you are doing exactly. -- For unsubscribe instructions e-mail to: users+h...@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: what is the alternative of countifs function in libreoffice?
Am 28.01.2012 05:47, soumalya ray wrote: its really time consuming.is there any other way to achieve this? regards, 3 seconds. -- For unsubscribe instructions e-mail to: users+h...@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: LO Base - calculating dates
Base is not a database. Base is a tool to work with variuos types of databases. The type of database connected to your Base document is indicated in the status bar of the database main window. If you are talking about an embedded HSQLDB then all I can tell is, that there is no built-in way to calculate dates other than CURRENT_DATE. Better databases have a function DATEADD at least. Which type of database are you connected to? -- For unsubscribe instructions e-mail to: users+h...@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: Problem downloading 3.4.5 for Mac Intel
On 1/28/12 6:10 AM, Robert Peirce wrote: I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? FWIW, 3.4.5 downloaded fine for me with Safari 5.1.2. I would try a different browser before I went to an alternate site. Just my preference. -- Ken Mac OS X 10.6.8 Firefox 9.0.1 Thunderbird 9.0.1 LibreOffice 3.4.4 -- For unsubscribe instructions e-mail to: users+h...@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: Problem downloading 3.4.5 for Mac Intel
Hi :) +1 I guess most people have at least 2 different web-browsers these days so that is likely to be the easiest option. I still have a weird feeling that it's something to do with a wireless connection and rebooting the router is a good thing to do every once in a while anyway. Regards from Tom :) --- On Sat, 28/1/12, Ken Springer snowsh...@q.com wrote: From: Ken Springer snowsh...@q.com Subject: [libreoffice-users] Re: Problem downloading 3.4.5 for Mac Intel To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 21:37 On 1/28/12 6:10 AM, Robert Peirce wrote: I have tried to download this update several times but it always dies before completion. I am using the same approach as I would use for any other app, click on the download button and watch the download bar in Safari. Any ideas? Is there an alternate download site? FWIW, 3.4.5 downloaded fine for me with Safari 5.1.2. I would try a different browser before I went to an alternate site. Just my preference. -- Ken Mac OS X 10.6.8 Firefox 9.0.1 Thunderbird 9.0.1 LibreOffice 3.4.4 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Problem downloading 3.4.5 for Mac Intel
On 1/28/12 3:01 PM, Tom Davies wrote: Hi :) +1 I guess most people have at least 2 different web-browsers these days so that is likely to be the easiest option. I still have a weird feeling that it's something to do with a wireless connection and rebooting the router is a good thing to do every once in a while anyway. I'm not sure most people have more than one browser installed, especially most Mac users. I would be an exception, I have 3. The third is Opera, up to date. I use them as cross checks when something if Firefox doesn't work as expected. Could also be a flakey DSL phone line, too. -- Ken Mac OS X 10.6.8 Firefox 9.0.1 Thunderbird 9.0.1 LibreOffice 3.4.4 -- For unsubscribe instructions e-mail to: users+h...@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] Downloading 3.4.5
I tried Safari again and then I tried Firefox. Neither was going anywhere fast, so I selected the Download using BitTorrent option. It downloaded a file named LibO_3.4.5_MacOS_x86_install_en-US.dmg.torrent but it in't executable and I don't know what to do with it. The activity monitor doesn't indicate it is doing anything. Does it need to be started in some way? -- For unsubscribe instructions e-mail to: users+h...@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: Downloading 3.4.5
In article bob-d2b5dd.17572628012...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: I tried Safari again and then I tried Firefox. Neither was going anywhere fast, so I selected the Download using BitTorrent option. It downloaded a file named LibO_3.4.5_MacOS_x86_install_en-US.dmg.torrent but it in't executable and I don't know what to do with it. The activity monitor doesn't indicate it is doing anything. Does it need to be started in some way? I see I need the bittorrent app to make this work. I downloaded, installed and started it up. I dragged the above file in and it is now downloading. Thanks, everybody. -- For unsubscribe instructions e-mail to: users+h...@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: LO Base - calculating dates
Am 28.01.2012 23:54, Dan Lewis wrote:
This might not be the most elegant solution:
I created a table of dates (01/01/2012 to 12/31/2013) calling it Date.
Then I wrote a query using the following SQL:
SELECT Date FROM Date WHERE DATEDIFF('dd',:start_date,Date)
=180 OR DATEDIFF('dd',:start_date,Date) = 365
IF and only IF we are talking about the infamous HSQLDB 1.8 which is
embedded in the so called Base document, the following trick works
with years but not nesecarily with months and days:
SELECT CAST(YEAR(Date)+1||'-'||
CASEWHEN(MONTH(Date)10,'0','')||MONTH(Date) ||'-'||
CASEWHEN((DAY(Date))10,'0','')||(DAY(Date)) AS DATE)ASCalc Date
FROM Table
--
For unsubscribe instructions e-mail to: users+h...@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] Opening thunderbird adressbook
Hi, I tried to connect to my thunderbird address book. When I try to use : File - Wizards - Address Data source and I tag the button Thunderbird I get: The connection to the external database could not be established. NO SDBC driver found for the given URL. And when I click on the button more I get under information: A connection for the following URL was requested sdbc:address:evolution:local. This is complete lunacy as I didn't ask for evolution and I don't know where it would get the URL from. OK, I don't give up. I do: File - New - database and click on the button 'connect to an existing database. When I expand that button I can choose: Thunderbird Address Book. Well, that looks promising. Alas, when I click on the button it brings me to a directory where I store documents and want to open an ODF Database. Well, that's completely wrong as Thunderbird adressbooks has as extension .mab. Well now I'm baffled. My settings: OS Xubuntu 10.04; LO 3.4.5 directly installed from the LO website as Ubuntu 10.04 still has 3.3.2. Hopefully somebody has succeeded in accessing the Thunderbird address book or is this solved in 3.5? Thanks in advance, Joep -- For unsubscribe instructions e-mail to: users+h...@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 Calc: Update External Link Question
Thanks for the reply Andreas. Please view the following link: http://youtu.be/UWTVKzp6kV8 I believe that will explain my question. I have learned something during my experimentations. If the files are in ods format, the update works correctly. It is when the files are in xls format that the links don't update. So I have two work arounds. . .1) Keep the files in xls format and open the source before I update the link, or 2) convert the files to ods format. On Jan 28, 2012, at 2:46 PM, Andreas Säger wrote: Am 27.01.2012 22:29, Steve Smith wrote: Understand linking, I think. My question is updating the link. If the source spreadsheet is not opened when a link to external file is updated (Edit - Links... - Update), I receive a #REF! error. Again, I'm aware of 5 different ways to link spreadsheet contents in ODF spreadsheets. All of them work. We can not know what you are doing exactly. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Downloading 3.4.5
Hi :) Brilliant :) Figuring torrents out is a bit tricky first time but it seems to be a better way to download stuff. The first few paragraphs on this wiki are pretty good despite the tag warning about it being too technical http://en.wikipedia.org/wiki/BitTorrent_(protocol) Note that when you download this way you also upload the file at the same time. You might want to poke around in the settings of the torrent-client and throttle that back a bit. It's usually polite to let it upload the file twice but it's not vital. Hefty downloads are easier because you can take long breaks between downloading chunks. It could be months and many reboots before continuing if you want. Also it is not quite so important to check the integrity of the completed download because torrenting has various checks built-in. Now you have the torrent-client you can just double-click on the *.torrent files you download to start them up. Regards from Tom :) --- On Sat, 28/1/12, Robert Peirce b...@peirce-family.com wrote: From: Robert Peirce b...@peirce-family.com Subject: [libreoffice-users] Re: Downloading 3.4.5 To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 23:09 In article bob-d2b5dd.17572628012...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: I tried Safari again and then I tried Firefox. Neither was going anywhere fast, so I selected the Download using BitTorrent option. It downloaded a file named LibO_3.4.5_MacOS_x86_install_en-US.dmg.torrent but it in't executable and I don't know what to do with it. The activity monitor doesn't indicate it is doing anything. Does it need to be started in some way? I see I need the bittorrent app to make this work. I downloaded, installed and started it up. I dragged the above file in and it is now downloading. Thanks, everybody. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: Downloading 3.4.5
I finally got my first torrent to work via KDE's KGet, instead of GNOME's version of it. My problem with uploading a torrent file is my upload speed is only about 120 KB/s, instead of the 1 MB/s I am told I should get with my account. My download speeds are over 10 MB/s easily though. So when I need to deal with email or other package that needs to upload packets, I cannot be using Torrent, FTP, or any other package that needs any uploading to do its work, including packet verification processes or commands telling servers that the packets arrived properly. So when I have to deal with a torrent download, I MUST set my uploading speed to the bare minimal amount to allow the process to be done. So for me to share a large file from my computer is not an option. Yes, the downloading via torrents work great for a stop and start process, such as a dialup user using his/her connection at night to download the file and then shut it down till the next night of downloads. On 01/28/2012 07:52 PM, Tom Davies wrote: Hi :) Brilliant :) Figuring torrents out is a bit tricky first time but it seems to be a better way to download stuff. The first few paragraphs on this wiki are pretty good despite the tag warning about it being too technical http://en.wikipedia.org/wiki/BitTorrent_(protocol) Note that when you download this way you also upload the file at the same time. You might want to poke around in the settings of the torrent-client and throttle that back a bit. It's usually polite to let it upload the file twice but it's not vital. Hefty downloads are easier because you can take long breaks between downloading chunks. It could be months and many reboots before continuing if you want. Also it is not quite so important to check the integrity of the completed download because torrenting has various checks built-in. Now you have the torrent-client you can just double-click on the *.torrent files you download to start them up. Regards from Tom :) --- On Sat, 28/1/12, Robert Peirceb...@peirce-family.com wrote: From: Robert Peirceb...@peirce-family.com Subject: [libreoffice-users] Re: Downloading 3.4.5 To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 23:09 In articlebob-d2b5dd.17572628012...@news.gmane.org, Robert Peirceb...@peirce-family.com wrote: I tried Safari again and then I tried Firefox. Neither was going anywhere fast, so I selected the Download using BitTorrent option. It downloaded a file named LibO_3.4.5_MacOS_x86_install_en-US.dmg.torrent but it in't executable and I don't know what to do with it. The activity monitor doesn't indicate it is doing anything. Does it need to be started in some way? I see I need the bittorrent app to make this work. I downloaded, installed and started it up. I dragged the above file in and it is now downloading. Thanks, everybody. -- For unsubscribe instructions e-mail to: users+h...@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] Help with linking to data on a website
I'm attempting to create a spreadsheet in LibreCalc for Fantasy Football that includes every active QB, RB, WR, TE, and K from Yahoo. I only picked Yahoo because I've gotten further along with their data than any other website. So far, I've figured out how to get a list of names and teams for the above positions. What I've done so far is create a spreadsheet with each position on a separate worksheet. I was able to grab the names and teams for each position by doing the following (example for RBs): Insert Link to External Data URL of external data source http://sports.yahoo.com/nfl/players?type=positionc=NFLpos=RB Available Tables/Ranges HTML_10. That gets me a list of the names and teams for each position and also includes a hyperlink to the player's individual page. Here's my issue: From each player's individual page I also want to pull their Date of Birth (Running Backs over 30 are a red flag) and the year they entered the league (Wide Receivers tend to break out in Year 3). I haven't yet figured out how to dynamically pull the additional data based on the initial web hyperlink. The additional data that I need is all contained in the player's individual pages (HTML_2 from the player's page). The secondary links must be dynamic and based on the initial list of players, since it's likely that players will come and go. Can this be done at all? Will it require the use of macros? Would I be better served to just do this whole thing using LibreBase? That would bring up a whole host of new questions, considering I have very little experience creating a database. One more minor question: Can I just delete any unwanted lines before or after the data that is pulled in? For instance, when I pull in the position page there are 2 lines at the top that I would just assume delete. If I delete them will that mess things up when I refresh the dynamic data? There's obviously more hurdles to overcome further down the road with this list, but this is where I am right now. My reason for attempting this is because I have spent a ton of time trying to track down this data and manually populate my master spreadsheet. If I could figure out a way to Push a button and get all of this together automatically then that would save a bunch of time (even if I spend a ton of time figuring out how to do it initially). Plus, I'm just a geek and I want to say that I did it. Eventually, I'd like to pull the dynamic draft rankings data into my master spreadsheet so that I'll have several different websites' draft data updated automatically. If anybody is interested in helping out with this project I'd be more than willing to share my work (assuming you aren't in my Fantasy league). -- View this message in context: http://nabble.documentfoundation.org/Help-with-linking-to-data-on-a-website-tp3696924p3696924.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] UNION Query throwing error
Hello! Wonder if my error jumps out at any of you - attempting to get a 3 column result - would you take a look? `( SELECT appointment.date AS Date, physician.lastname AS Description, appointment.time AS Comment FROM pat_appt, appointment, physician, patient WHERE pat_appt.appt_id = appointment.id AND patient.id = pat_appt.pat_id ) UNION ( SELECT prescription.next_fill_date AS Date, medicines.generic AS Description, pharmacy.name AS Comment FROM pat_med, prescription, pharmacy, medicines, patient WHERE pat_med.presc_id = prescription.id AND patient.id = pat_med.pat_id AND medicines.id = prescription.medication AND pharmacy.id = prescription.pharm_id ) UNION ( SELECT bill.due AS Date, bill.descrip AS Description, bill.amount AS Comment FROM pat_bill, bill, patient WHERE pat_bill.bill_id = bill.id AND patient.id = pat_bill.pat_id ) UNION ( SELECT immunizations.due AS Date, immunizations.description AS Description, immunizations.date AS Comment FROM pat_immun, immunizations, patient WHERE pat_immun.imun_id = immunizations.id AND patient.id = pat_immun.pat_id ) ORDER BY 1 ASC, 4 ASC, 7 ASC, 10 ASC` The error is SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE I'm attaching the relationships. http://nabble.documentfoundation.org/file/n3695780/08.png Any suggestions? Beth -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3695780.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Suggestions for LibreOffice
Hi, I have been looking for the suggestion bin, hope you do not mind me adding to this thread. there are two things I would like to see. being a total user, I have no idea how easy it is to do either. first, I would like to have separate icons so I can just open calc or writer and not have to open a home page, then select the application. second, and this has bugged me from the earliest incarnations of all windoz programs. open a super fast page. just display the software and not an hourglass. none of the menu items need to work instantly, maybe file open ? notepad and such open in a second. I can start to jot my notes down as the width and depth of the menus are loading. Another wish list item. I have my hard disk partitioned so I have all my wordprocessing files in one folder and all my spreadsheet files in another. I have to navigate back and forth. if I am in the spreadsheet, I have to save-as, then navigate to the calc folder. there may be advantages for doing this another way, but this is my wish list. Thanks for offering this software. you folks are wonderful for making this available. Dave -- View this message in context: http://nabble.documentfoundation.org/Suggestions-for-LibreOffice-tp3671431p3696120.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: UNION Query throwing error
This was my solution: `( SELECT appointment.date AS Date, appointment.notes AS Description, physician.lastname AS Comment, TO_CHAR(appointment.time, 'HH24:MI:SS') AS Notes, 'Appt' AS Type FROM pat_appt, appointment, physician, patient WHERE pat_appt.appt_id = appointment.id AND patient.id = pat_appt.pat_id ) UNION ( SELECT prescription.next_fill_date AS Date, medicines.generic AS Description, pharmacy.name AS Comment, pharmacy.phone AS Note, 'Med Refill' AS Type FROM pat_med, prescription, pharmacy, medicines, patient WHERE pat_med.presc_id = prescription.id AND patient.id = pat_med.pat_id AND medicines.id = prescription.medication AND pharmacy.id = prescription.pharm_id ) UNION ( SELECT bill.due AS Date, bill.descrip AS Description, bill.amount AS Comment, bill.date_recd AS Notes, 'Bill' AS Type FROM pat_bill, bill, patient WHERE pat_bill.bill_id = bill.id AND patient.id = pat_bill.pat_id ) UNION ( SELECT immunizations.due AS Date, immunizations.description AS Description, immunizations.date AS Comment, immunizations.date AS Notes, 'Immun Due' AS Type FROM pat_immun, immunizations, patient WHERE pat_immun.imun_id = immunizations.id AND patient.id = pat_immun.pat_id )` The trick was going to Edit-Run SQL Directly. Hope someone can benefit from this, Beth -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696185.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Suggestions for LibreOffice
On 01/28/2012 12:04 PM, dave_in_NJ wrote: Hi, I have been looking for the suggestion bin, hope you do not mind me adding to this thread. there are two things I would like to see. being a total user, I have no idea how easy it is to do either. first, I would like to have separate icons so I can just open calc or writer and not have to open a home page, then select the application. second, and this has bugged me from the earliest incarnations of all windoz programs. open a super fast page. just display the software and not an hourglass. none of the menu items need to work instantly, maybe file open ? notepad and such open in a second. I can start to jot my notes down as the width and depth of the menus are loading. Another wish list item. I have my hard disk partitioned so I have all my wordprocessing files in one folder and all my spreadsheet files in another. I have to navigate back and forth. if I am in the spreadsheet, I have to save-as, then navigate to the calc folder. there may be advantages for doing this another way, but this is my wish list. The problem is, as designed, LO is unified suite not separate programs. Technically MSO is a collection of separate programs that have been integrated. Thus, LO using on location for saving data while MSO, being separate programs, can save to different locations. I do not know how difficult it would be to have multiple save locations based on file types in LO Thanks for offering this software. you folks are wonderful for making this available. Dave For your suggestions, I suggests filing a bug report and mark it as enhancement, https://www.libreoffice.org/get-help/bug/. -- View this message in context: http://nabble.documentfoundation.org/Suggestions-for-LibreOffice-tp3671431p3696120.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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] LO Base - calculating dates
On 01/28/2012 05:42 AM, Mark Stanton wrote: I think (without actually having tried it) that just adding numbers to a date field will do what you want, soyour date field+365 should give you the year in advance date A side note of caution. Not every year has 365 days, so tricks are usually used to do things such as add one month or add one year. I expect there to be date arithmetic functions available to do this in SQL, but, if they are not easily obtained, you use tricks to manually extract things such as the day / month / year, add the portions of interest, and convert back. You can still get in trouble when moving from a leap year to a non-leap year if you try to simply add one year and keep all other things the same (because the number of days in one of the months may change). That said, for quick and dirty calculations, I do things very similar to what you recommend. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@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: what is the alternative of countifs function in libreoffice?
yeah and then 10 min to check whether i made any mistake or not! :D :D regards, On 29 January 2012 02:17, Andreas Säger ville...@t-online.de wrote: Am 28.01.2012 05:47, soumalya ray wrote: its really time consuming.is there any other way to achieve this? regards, 3 seconds. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@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 archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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
