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

2012-01-29 Thread Tom Davies
Hi :) That sort of checking gets considerably faster as you begin to find the powers and limitations of the new thing.  Also as you find faster and easier ways of checking.  It is one reason why people are very resistant to change. Regards from Tom :) --- On Sun, 29/1/12, soumalya ray

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

2012-01-29 Thread Ing. Jiří Hladůvka
Dne 28.1.2012 18:04, dave_in_NJ napsal(a): 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] Suggestions for LibreOffice

2012-01-29 Thread Johnny Rosenberg
2012/1/19 Help_Please mykelt...@gmail.com: Suggestion One:    Include Check for updates  to perform online checking for updates to LibreOffice. Your distro should take care of that for you automatically. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to:

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

2012-01-29 Thread Tom Davies
Hi :) This thread is a good one to 'hijack' for your purpose :)  The link for posting wish-list items or Feature requests (whatever you want to call them) is https://www.libreoffice.org/get-help/bug/ without a dot at the end.  When you post a bug-report one of the drop-downs has Feature request

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

2012-01-29 Thread Tom Davies
Hi :) I think Base has to be the way forwards.  It is a bit of a steep learning curve but this sort of project is perfect for it.  Spreadsheets would be really messy and hopelessly complicated and would never really allow you to play around with the data so freely.  This guide might help

[libreoffice-users] Re: UNION Query throwing error

2012-01-29 Thread blesko
Oh Oh! I hit Edit- Run SQL Directly and I'm getting much more informative error messages - stand-by :-) -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3695882.html Sent from the Users mailing list archive at Nabble.com. -- For

[libreoffice-users] Re: displaying the result of pageNum + 1

2012-01-29 Thread william drescher
On 1/27/2012 9:47 PM, Dan Lewis wrote: On Fri, 2012-01-27 at 10:31 -0500, william drescher wrote: In the footer of a faxed document I want to display: This fax continues on page x where x is to be the current page number + 1 Can I do this, how ? Thanks in advance, bill In the footer,

[libreoffice-users] Re: UNION Query throwing error

2012-01-29 Thread blesko
One more requirement - in report builder properties, chose in general Query, but Analize SQL:NO. -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696191.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

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

2012-01-29 Thread Andreas Säger
Am 29.01.2012 08:27, soumalya ray wrote: yeah and then 10 min to check whether i made any mistake or not! :D :D regards, Since I know the usual navigation keys and fill methods with all the availlable keyboard shortcuts, I am always sure to do the right thing in *any* spreadsheet. Simply

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

2012-01-29 Thread Pedro
Hi soumalya ray soumalya ray wrote yeah and then 10 min to check whether i made any mistake or not! :D :D This kind of answers will only cause people to stop helping you. One solution was given to you 2 days ago, and yet you don't want to waste 10 minutes. That shows how committed you are

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

2012-01-29 Thread Andreas Säger
Am 29.01.2012 01:44, Steve Smith wrote: 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

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

2012-01-29 Thread Andreas Säger
And by the way: Your video explains nothing since it does not tell anything about the type of link which refuses to update nor does it indicate that it is an Excel file. Just in case you are using a formula link like this: ='file://path/file.xls'#Sheet1.$A$1 (again, there are 4 other methods in

[libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Daniel Wibbing
Hi everyone! I am new to this mailing list. I hope I am using it in the right way: The situation: I have a document (my dissertation) with a lot of pictures, which I inserted as links. The document is in a folder Dissertation The pictures are in the folder Bilder/... in the folder Dissertation

[libreoffice-users] Re: Opening thunderbird adressbook

2012-01-29 Thread Alex Thurgood
Le 29/01/2012 01:24, Joep L. Blom a écrit : Hi, OS Xubuntu 10.04; LO 3.4.5 directly installed from the LO website as Ubuntu 10.04 still has 3.3.2. Known issue with the 3.4.x series, especially on Ubuntu. Hopefully somebody has succeeded in accessing the Thunderbird address book or is

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

2012-01-29 Thread Alex Thurgood
Le 28/01/2012 22:37, Ken Springer a écrit : I would try a different browser before I went to an alternate site. Just my preference. I would agree. I've not had any problems when downloading with Chrome or Firefox on Mac OSX. Alex -- For unsubscribe instructions e-mail to:

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

2012-01-29 Thread Alex Thurgood
Le 28/01/2012 23:54, Dan Lewis a écrit : Hi Dan, Does someone know how to create a table using SQL or perhaps even a macro that would create the date table with enough entries for the number of years that this database might need? At a guess, I'd say this problem has probably come up on one

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

2012-01-29 Thread Andreas Säger
Am 28.01.2012 23:54, Dan Lewis wrote: Does someone know how to create a table using SQL or perhaps even a macro that would create the date table with enough entries for the number of years that this database might need? --Dan Use a spreadsheet where the DATE function in combination of MOD,

[libreoffice-users] Re: Password protected files in LibreOffice 3.4.5

2012-01-29 Thread Arto
Cor Nouws oolst at nouenoff.nl writes: But you are (should be) able to open files saved with password in 3.4.4 (and before) in 3.4.5 and 3.5.0. Also are (you should) be able to open files saved with encryption in 3.5.0 in 3.4.5. Only thing is that you cannot open files saved with password

[libreoffice-users] emacs mode?

2012-01-29 Thread lee
Hi, is there an emacs mode available for at least writer? I keep pressing the keys I use in emacs in writer without thinking, so it would be nice to have an emacs mode ... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Does LO work with Cinnamon - GNOME2 shell in 3?

2012-01-29 Thread webmaster for Kracked Press Productions
Anyone out there have used Linux Mint 12 with LO? This is actually a developer's question, but needs to be asked of the Users as well. Does anyone know if LO works with the Cinnamon, which is a shell [I think that is the correct term] that is placed over GNOME 3.x so it looks and works

Re: [libreoffice-users] emacs mode?

2012-01-29 Thread Mirosław Zalewski
On 29/01/2012 at 15:27, lee l...@songoku.yagibdah.de wrote: Hi, is there an emacs mode available for at least writer? I keep pressing the keys I use in emacs in writer without thinking, so it would be nice to have an emacs mode ... No, there is not. There is no vi mode neither. You may

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Fernand Vanrie
Daniel Wibbing, I donot know if early versions suported relative links, as the link is stored a a url ? with a simple macro you can restore easly the URL's to your original path Greetz Fernand Hi everyone! I am new to this mailing list. I hope I am using it in the right way: The

Re: [libreoffice-users] Does LO work with Cinnamon - GNOME2 shell in 3?

2012-01-29 Thread Jay Lozier
On 01/29/2012 12:35 PM, webmaster for Kracked Press Productions wrote: Anyone out there have used Linux Mint 12 with LO? Yes with Gnome 3, Clem added some features to Gnome 3 so that the DE has features from 2.X in addition to the normal Gnome 3 for Linux Mint 12. I believe Cinnamon and Mate

Re: [libreoffice-users] Does LO work with Cinnamon - GNOME2 shell in 3?

2012-01-29 Thread webmaster for Kracked Press Productions
The way I read it, Cinnamon was the default for Mint 12. I could be wrong though. Right now, from what I have seen in the screen clips for Mint 12, I do not see any panels or other way to bring up the menu system so you can run/install packages. The only thing that is shown is the Home

Re: [libreoffice-users] Re: UNION Query throwing error

2012-01-29 Thread Jay Lozier
Hi, On 01/28/2012 12:51 PM, blesko wrote: One more requirement - in report builder properties, chose in general Query, but Analize SQL:NO. -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696191.html Sent from the Users mailing

Re: [libreoffice-users] Does LO work with Cinnamon - GNOME2 shell in 3?

2012-01-29 Thread Jay Lozier
On 01/29/2012 02:18 PM, webmaster for Kracked Press Productions wrote: The way I read it, Cinnamon was the default for Mint 12. I could be wrong though. Cinnamon will be the default for Mint 13, it is available for 12. The default for 12 is Clem's modified Gnome 3 Right now, from what I have

Re: [libreoffice-users] capitalization

2012-01-29 Thread lee
Tom Davies tomdavie...@yahoo.co.uk writes: 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 Thanks,

Re: [libreoffice-users] emacs mode?

2012-01-29 Thread lee
Mirosław Zalewski mini...@poczta.onet.pl writes: On 29/01/2012 at 15:27, lee l...@songoku.yagibdah.de wrote: Hi, is there an emacs mode available for at least writer? I keep pressing the keys I use in emacs in writer without thinking, so it would be nice to have an emacs mode ... No,

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Calvin Kim
On 01/29/2012 09:11 AM, Daniel Wibbing wrote: Hi everyone! I am new to this mailing list. I hope I am using it in the right way: The situation: I have a document (my dissertation) with a lot of pictures, which I inserted as links. The document is in a folder Dissertation The pictures are in

[libreoffice-users] Re: Opening thunderbird adressbook

2012-01-29 Thread NoOp
On 01/29/2012 06:41 AM, Alex Thurgood wrote: Le 29/01/2012 01:24, Joep L. Blom a écrit : Hi, OS Xubuntu 10.04; LO 3.4.5 directly installed from the LO website as Ubuntu 10.04 still has 3.3.2. Known issue with the 3.4.x series, especially on Ubuntu. Hopefully somebody has

Re: [libreoffice-users] emacs mode?

2012-01-29 Thread Mirosław Zalewski
On 29/01/2012 at 19:38, lee l...@songoku.yagibdah.de wrote: Hm, that doesn´t seem to come even close ... Like how do I set C-x-f to open a file or C-x-C-s to save one or C-x-s to save many --- for just to name a few examples? I don't use emacs, so I don't know how complex keyboard shortcuts

Re: [libreoffice-users] capitalization

2012-01-29 Thread webmaster for Kracked Press Productions
On 01/29/2012 09:25 AM, lee wrote: Tom Daviestomdavie...@yahoo.co.uk writes: 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

Re: [libreoffice-users] Add pdf as page in document

2012-01-29 Thread upscope
jorge wrote: Hi: There are some programs to manage .pdf format documents,... like PDF-Shuffler, PDF Chain and others that you can find for it. If you you use Ubuntu, Open Suse or similar flavors of GNU/Linux you can find those programs in the Install Program repositories. Regards,

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Daniel Wibbing
Hi Brian, you are a genius! :) Using this little dot in front of the path name really works! ./Bilder/Kapitel 2/Hall_effect_A.png Like this I am now able to delete the beginnings of the absolute path names, set the dot in front of the relative part and the picture will be shown. Great!

Re: [libreoffice-users] emacs mode?

2012-01-29 Thread anthropornis
I am curious, which, if any, word processing programs (not text editors) actually have an Emacs mode? Compared to the broader base of non-techie word processor users, making a word processor behave like Emacs would be extraordinarily niche oriented. Why don't you just actually write documents

Re: [libreoffice-users] emacs mode?

2012-01-29 Thread webmaster for Kracked Press Productions
On 01/29/2012 03:16 PM, Mirosław Zalewski wrote: On 29/01/2012 at 19:38, leel...@songoku.yagibdah.de wrote: Hm, that doesn´t seem to come even close ... Like how do I set C-x-f to open a file or C-x-C-s to save one or C-x-s to save many --- for just to name a few examples? I don't use emacs,

Re: [libreoffice-users] capitalization

2012-01-29 Thread Brad Rogers
On Sun, 29 Jan 2012 15:25:34 -0500 webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: Hello webmaster, The ignore double spaces is an option that needs to be looked. To be honest, I do not know what it does when it is checked. I use double Stops the occurrence of

[libreoffice-users] Re: Does LO work with Cinnamon - GNOME2 shell in 3?

2012-01-29 Thread Andreas Säger
Am 29.01.2012 18:35, webmaster for Kracked Press Productions wrote: Anyone out there have used Linux Mint 12 with LO? This is actually a developer's question, but needs to be asked of the Users as well. Does anyone know if LO works with the Cinnamon, which is a shell [I think that is the

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Dan Lewis
Daniel: Perhaps a little studying on how relative paths work is in order. When you see a relative path that begins with ./xxx, this means to begin looking for xxx in the same folder you are presently in. (xxx can be a folder or file.) When you see a relative path that begins with ../xxx, this

Re: [libreoffice-users] capitalization

2012-01-29 Thread Jay Lozier
On 01/29/2012 03:50 PM, Brad Rogers wrote: On Sun, 29 Jan 2012 15:25:34 -0500 webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: Hello webmaster, The ignore double spaces is an option that needs to be looked. To be honest, I do not know what it does when it is

Re: [libreoffice-users] capitalization

2012-01-29 Thread Robert Funnell
On Sun, 29 Jan 2012, Jay Lozier wrote: On 01/29/2012 03:50 PM, Brad Rogers wrote: On Sun, 29 Jan 2012 15:25:34 -0500 webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: Hello webmaster, The ignore double spaces is an option that needs to be looked. To be honest, I do

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Brian Barker
At 21:32 29/01/2012 +0100, Daniel Wibbing wrote: you are a genius! :) Possibly not - but I'm pleased if I've solved your problem, of course. Using this little dot in front of the path name really works! ./Bilder/Kapitel 2/Hall_effect_A.png Like this I am now able to delete the beginnings

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Tom Davies
Hi :) This guide might help http://wiki.documentfoundation.org/BugReport One of the drop-downs has an option for feature request or something.  Good luck and regards from Tom :) --- On Sun, 29/1/12, Daniel Wibbing daniel.wibb...@gmx.net wrote: From: Daniel Wibbing daniel.wibb...@gmx.net

Re: [libreoffice-users] relative paths to linked graphics do not work

2012-01-29 Thread Tom Davies
Hi :) Good point.  A . is the current directory/folder .. is the folder that contains the folder you are currently in (=the parent folder) and / is the root of the entire file-system.  In Windows-only nomenclature it would be C: Regards from Tom :) --- On Sun, 29/1/12, Brian Barker

Re: [libreoffice-users] capitalization

2012-01-29 Thread doug
On 01/29/2012 03:25 PM, webmaster for Kracked Press Productions wrote: On 01/29/2012 09:25 AM, lee wrote: Tom Daviestomdavie...@yahoo.co.uk writes: Hi :) |It sounds like something in auto-correct to me. What sorts of words | are getting capitalised? Days of the week, place names, first

Re: [libreoffice-users] Re: Opening thunderbird adressbook

2012-01-29 Thread Joep L. Blom
On 29-01-12 21:01, NoOp wrote: On 01/29/2012 06:41 AM, Alex Thurgood wrote: Le 29/01/2012 01:24, Joep L. Blom a écrit : Hi, OS Xubuntu 10.04; LO 3.4.5 directly installed from the LO website as Ubuntu 10.04 still has 3.3.2. Known issue with the 3.4.x series, especially on Ubuntu.

Re: [libreoffice-users] capitalization

2012-01-29 Thread webmaster for Kracked Press Productions
On 01/29/2012 05:47 PM, doug wrote: On 01/29/2012 03:25 PM, webmaster for Kracked Press Productions wrote: On 01/29/2012 09:25 AM, lee wrote: Tom Daviestomdavie...@yahoo.co.uk writes: Hi :) |It sounds like something in auto-correct to me. What sorts of words | are getting capitalised?

[libreoffice-users] Re: Opening thunderbird adressbook

2012-01-29 Thread Alex Thurgood
Le 29/01/2012 21:01, NoOp a écrit : Hi, The wizard still doesn't work on LibreOffice 3.5.0rc2 Build ID: e371a95-bf68a13-5a1aa2b-d3c1ae9-b938258 .deb from LO. It's nothing to do with the distrib - but this is running on Ubuntu 10.10. Hmmm, stange, because my own build does work, at least so