[libreoffice-users] Pasting Draw tables into Writer

2012-01-28 Thread Petru Dimitriu
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

Re: [libreoffice-users] LO Base - calculating dates

2012-01-28 Thread Mark Stanton
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

Re: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-28 Thread Don Myers
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

[libreoffice-users] Re: LWP documents

2012-01-28 Thread Tom
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

Re: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-28 Thread Tom Davies
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

Re: [libreoffice-users] capitalization

2012-01-28 Thread Tom Davies
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

Re: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-28 Thread MiguelAngel
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:

Re: [libreoffice-users] capitalization

2012-01-28 Thread webmaster for Kracked Press Productions
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

[libreoffice-users] Re: [libreoffice-documentation] please help

2012-01-28 Thread Tom Davies
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

[libreoffice-users] was: LWP documents

2012-01-28 Thread webmaster for Kracked Press Productions
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

[libreoffice-users] RE: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-28 Thread sonic
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

[libreoffice-users] Re: Re: Problem printing an .xls file

2012-01-28 Thread Maurice Batey
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

[libreoffice-users] Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Robert Peirce
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

[libreoffice-users] Re: create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-01-28 Thread Alexander Thurgood
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

[libreoffice-users] Re: Problem printing an .xls file

2012-01-28 Thread Maurice Batey
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

Re: [libreoffice-users] was: LWP documents

2012-01-28 Thread soumalya ray
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

Re: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Guy Voets
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

Re: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Tom Davies
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/

Re: [libreoffice-users] Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Tom Davies
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

[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-28 Thread Andreas Säger
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

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-28 Thread Andreas Säger
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

[libreoffice-users] Re: LO Base - calculating dates

2012-01-28 Thread Andreas Säger
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

[libreoffice-users] Re: Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Ken Springer
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

Re: [libreoffice-users] Re: Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Tom Davies
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

[libreoffice-users] Re: Problem downloading 3.4.5 for Mac Intel

2012-01-28 Thread Ken Springer
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

[libreoffice-users] Downloading 3.4.5

2012-01-28 Thread Robert Peirce
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

[libreoffice-users] Re: Downloading 3.4.5

2012-01-28 Thread Robert Peirce
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

[libreoffice-users] Re: LO Base - calculating dates

2012-01-28 Thread Andreas Säger
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

[libreoffice-users] Opening thunderbird adressbook

2012-01-28 Thread Joep L. Blom
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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-28 Thread Steve Smith
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

Re: [libreoffice-users] Re: Downloading 3.4.5

2012-01-28 Thread Tom Davies
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

Re: [libreoffice-users] Re: Downloading 3.4.5

2012-01-28 Thread webmaster for Kracked Press Productions
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

[libreoffice-users] Help with linking to data on a website

2012-01-28 Thread Craig_in_Suwanee
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

[libreoffice-users] UNION Query throwing error

2012-01-28 Thread blesko
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 =

[libreoffice-users] Re: Suggestions for LibreOffice

2012-01-28 Thread dave_in_NJ
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

[libreoffice-users] Re: UNION Query throwing error

2012-01-28 Thread blesko
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 =

Re: [libreoffice-users] Re: Suggestions for LibreOffice

2012-01-28 Thread Jay Lozier
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

Re: [libreoffice-users] LO Base - calculating dates

2012-01-28 Thread Andrew Douglas Pitonyak
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

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-28 Thread soumalya ray
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