[libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-27 Thread pierre masci
Hello, with Home i can move to the start of the current row. How can i do the same thing with a column? Even if i need to use several Shortcuts to achieve it, it wouldn't be a problem: i could always record the series of shortcut as a new Macro, and make a custom keyboard shortcut for this macro.

Re: [libreoffice-users] Image - screen saver conflict?

2013-02-27 Thread Kolbjørn Stuestøl
Den 26.02.2013 21:24, skreiv anne-ology: screen-savers ;-) and I thought these had been replaced by that 'hibernation' option ;-) Suggestion to try - try placing the machine in 'hibernation' when you leave it for a moment - see if this odd phenomenon

[libreoffice-users] Libre office version 3.4.4 Calc Using excel 2007 formula SUMIFS??

2013-02-27 Thread dangilf
Hi, I've got a calc spreadsheet, and I'm trying to sum data based on three different criteria (data to sum in column J, criteria in columns A, H K. I'm trying to work out the syntax for using the sumproduct function to be able to do this, but I keep getting results of 0. Anyone have any

[libreoffice-users] Re: Why is Impress screwed up with EVERY release?

2013-02-27 Thread Stephan P.
Hi Thomas, Not aware of a bug report yet for that wrt. 4.0 - would you be willing to file a bug report with an example document at https://www.libreoffice.org/get-help/bug/ please? It could be specific to some kind of documents. ok, filed as

Re: [libreoffice-users] LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tom Davies
Hi :) Can you try reinstalling 3.6.5?  Perhaps download the installer from the LiberOffice website afresh.  When you try to install it there should be an option to Repair and that might let you add the Quickstarter component.  Then in LibreOffice itself go to Tools - Options - Memory errr,

Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

2013-02-27 Thread Ian Whitfield
Hi All I have two Machines here both running the new PClinuxOS 2013.02 and LO 1.4.0 Previously I was on PCLOS 2012.07 and LO 1.3.6 and had a MySQL Database running fine. I now can get neither machine to set-up a Database!! The one fails to start httpd with the error - /

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tinkerer
Tom The LO Options for a Mac are in LO Preferences. The Options differ too as there is no option to switch Quickstarter on or off under the Memory option. It may exist elsewhere, but I have never seen it. BTW. I am running Mac 10.8.2 on an iMac and I have never experienced that problem. I am

Re: [libreoffice-users] Libre office version 3.4.4 Calc Using excel 2007 formula SUMIFS??

2013-02-27 Thread Regina Henschel
Hi Daniel, dangilf schrieb: Hi, I've got a calc spreadsheet, and I'm trying to sum data based on three different criteria (data to sum in column J, criteria in columns A, H K. I'm trying to work out the syntax for using the sumproduct function to be able to do this, but I keep getting results

Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-27 Thread Brian Barker
At 09:39 27/02/2013 +, Pierre Masci wrote: Hello, with Home i can move to the start of the current row. How can i do the same thing with a column? I don't know that you can. But Ctrl+up-arrow may help. If the cell immediately above is occupied, this moves to the top of the current

[libreoffice-users] Re: Different header footer content on first page not working

2013-02-27 Thread Paddy Landau
Paddy Landau wrote I love Writer's new feature for headers and footers: the ability to turn off Same content on first page… https://www.libreoffice.org/download/4-0-new-features-and-fixes … But for the fact that I can't get it to work! I have discovered that this is an old bug (reported

Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-27 Thread pierre masci
I solved my problem in another but simple way, finally. It would still be handy to have a shortcut to column start though... I made a Macro that moves the current row up (and another one to go down). And i have a handy shortcut to use it. Step by step, it does: - select current row: Shift+Space

Re: [libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tom Davies
Hi :) Thanks Tink.  Errr on other platforms the option only appears if you have chosen the right option during install.  Otherwise it doesn't appear at all, which is a bit weird.  Usually those sorts of things would be greyed-out rather than absent.  I like your idea of upgrading or

[libreoffice-users] Re: typo on the LibO homepage

2013-02-27 Thread Marc Paré
Le 2013-02-27 07:34, rost52 a écrit : I just found a typo on http://www.libreoffice.org/#2 We havemany roles for you,..., there is a space missing between have and many Maybe someone can forward this information the person(s) in charge. Thank! I'll forward this on. Cheers, Marc --

Re: [libreoffice-users] Does Libre Office have its own distinctsetoffonts?

2013-02-27 Thread webmaster-Kracked_P_P
That is why I have Web Of Trust install on all of my browsers. It is free and works very well. It will rate the sites, when googling, to help you keep out of the nasty sights. I only go to sites listed as green. http://www.fontspace.com/ http://www.dafont.com/

Re: [libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

2013-02-27 Thread Heinrich Stoellinger
Hello Ian, Regarding the JDBC-connector: download it from the MySQL homepage, un-tar it, then under LO go into Options - Extended (Erweitert in the German version). There you add a Java Runtime Environment and also specify the directory into which you put the .jar-file of the connector in the

Re: [libreoffice-users] Does Libre Office have its own distinctsetoffonts?

2013-02-27 Thread anne-ology
Thanks for these links. On Wed, Feb 27, 2013 at 9:54 AM, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: That is why I have Web Of Trust install on all of my browsers. It is free and works very well. It will rate the sites, when googling, to help you keep out of the nasty

Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-27 Thread Johnny Rosenberg
2013/2/27 pierre masci piema...@gmail.com: I solved my problem in another but simple way, finally. It would still be handy to have a shortcut to column start though... I made a Macro that moves the current row up (and another one to go down). And i have a handy shortcut to use it. Step by

Re: [libreoffice-users] Re: Image - screen saver conflict?

2013-02-27 Thread Tom Davies
Hi :) Yes, i vaguely remember someone saying it dated back to around 2.0.  Hopefully as the code becomes clearer and more streamlined then it might become easier to trouble-shoot or even find problems just disappear as cruft gets cleared.  Good luck and regards from Tom :)

Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-27 Thread Brian Barker
At 13:22 27/02/2013 +, Pierre Masci wrote: ... i thought that i needed to go to the first cell of the column, for the last step. In fact i didn't. It's always best to ask the real question - not the small bit that you think you need but might not! Brian Barker -- For unsubscribe

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Robert Peirce
In article 1361962498770-4040433.p...@n3.nabble.com, Tinkerer j_taylo...@btinternet.com wrote: BTW. I am running Mac 10.8.2 on an iMac and I have never experienced that problem. Me neither until yesterday. I have absolutely no idea what happened. I thought maybe it was a system update but

Re: [libreoffice-users] Why is Impress screwed up with EVERY release?

2013-02-27 Thread Tom Davies
Hi :) Ahh, superb!  Thanks for these.  I don't do slide-shows so i don't look around much but i think we have needed links like these for quite a while to give to people having troubles with Impress.  Thanks and regards from Tom :)  From: anne-ology

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Robert Peirce
In article bob-3216e6.12422727022...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: Me neither until yesterday. I have absolutely no idea what happened. I thought maybe it was a system update but I restored from an earlier backup without success. I discovered what

Re: [libreoffice-users] Managing Templates in Writer

2013-02-27 Thread Tom Davies
Hi :) Have you found the guides on https://wiki.documentfoundation.org/Documentation/Publications or just using the in-built help?  Both do lag a bit but the wiki-pages's Getting Started Guide is for the 4.0.0.  The chapters are all done but people are still proof-reading the full book. Did you

[libreoffice-users] Default Assignee on FreeDesktop.Org (Real Name)

2013-02-27 Thread Joel Madero
Hi All, In order to facilitate new users becoming accustomed to our bug system, I have updated the Real Name of the default assignee ( libreoffice-b...@lists.freedesktop.org) to Not Assigned. I hope that this makes it clearer to new developers and contributors that these bugs are not assigned and

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Robert Peirce
In article bob-c1a022.12550827022...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: In article bob-3216e6.12422727022...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: Me neither until yesterday. I have absolutely no idea what happened. I thought maybe it

Re: [libreoffice-users] Managing Templates in Writer

2013-02-27 Thread Dave Liesse
Didn't even know about this one. Have to admit that although I've had 35+ years in the software world (mostly in data base design, data modeling, and quality assurance), when it comes to LibreOffice I'm just a plain old user and don't know about everything that's out there! Yes, thanks, I

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tinkerer
Robert To ensure a compete removal of an Application I use Clean My Mac http://macpaw.com/cleanmymac or you could try Amnesia http://www.koingosw.com/products/amnesia.php Both these search and remove associated files when you do an uninstall. Tink. -- View this message in context:

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Robert Peirce
In article bob-9bd879.13352227022...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: Not quite. Eliminating the preferences file allowed me to fire up LibreOffice once but then something causes it to hang. There is something getting created on my computer that is causing this