[libreoffice-users] Re: Calc: cut/paste removes and renames protected field references - is this a bug?

2011-10-14 Thread Andreas Säger
Am 14.10.2011 03:32, Tom Davies wrote: Hi :) Can you name a cell? In Excel you could define a name for a cell by just typing it in on the formula bar just before the f(x)Sigma bit. Normally the drop-down there contains the cell's address, such as A!, but you can just type something else into

Re: [libreoffice-users] to bug or not to bug that is the question

2011-10-14 Thread Stephan Zietsman
gael.lori...@laposte.net wrote: I couldn't find a changelog of LO3.4.3 on libreoffice.org (results returned by seeks using the site:libreoffice.org keyword are irrelevant) A little off topic, but when searching for LibreOffice documentation, you might want to include inurl:libreoffice instead

Re:[libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread gael.lori...@laposte.net
Hi, You are right, Ctrl+ArrowKey is enough, my mistake. I don't know your OS, but in Win XP it jumps to the first/last cell with data, unless I misunderstood your question... Ctrl+ArrowKey works this way for me too, except when I am editing a formula and want to add a cell's reference, in

Re: [libreoffice-users] Re: list box in database

2011-10-14 Thread Mike
Ok Andreas, I am going to study for a while with this one, i will let you know what i come up with. Michael Sent from my iPhone On 13 oct. 2011, at 15:48, Andreas Säger saege...@t-online.de wrote: Am 13.10.2011 13:06, Michael Guillet wrote: Hello, I was finally able to connect my LO

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread Stephan Zietsman
gael.lori...@laposte.net wrote: You are right, Ctrl+ArrowKey is enough, my mistake. [...] Ctrl+ArrowKey works this way for me too, except when I am editing a formula and want to add a cell's reference, in which case it brings the cursor directly to the first/last coloumn/line of the

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread gael.lori...@laposte.net
Hi, Have you tried Ctrl+Shift+ArrowKey? The problem is not about being able to select a range of cells it is merely to move down to a certain cell which reference has to be inserted into a formula. I have not tried, but I assume that if Crtl+Down does not behave properly then Ctrl+Shift+Down

[libreoffice-users] Re: Saving SXD = Blank Doc

2011-10-14 Thread Alexander Thurgood
Le 14/10/11 03:18, NoOp a écrit : The T/ESC (technical/engineering steering committee) make public the minutes of its meetings (posted on the wiki). If users want to know what's going on, it is in the minutes of these meetings that they will find out what's happening to the code. Link

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread Tom Davies
Hi :) It is only supposed to jump to the end of the worksheet if there is nothing else entered between the cursor and the end.  If there was a big gap and then a few figures the cursor should jump to the first value in the list and the next tap would take the cursor to the end of that list. 

Re:[libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread Tom Davies
Hi :) The LO build for Windows is a little different from the GnuLinux, Bsd Mac build.  Also in some OSes it's easy to re-configure global settings for many more key combinations.    Finding the limits of the problem can help with sorting it out. Regards from Tom :) --- On Fri, 14/10/11,

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread Tom Davies
Hi :) I agree about taking them at their word and trying to help with fixing it but over the last year we have seen differences between their promises towards OpenSource and their actions.  TDF is not the only OpenSource or semi-OpenSource project or organisation that has been forced to walk

[libreoffice-users] LibreOffice ceriticates

2011-10-14 Thread Nguyen Vu Hung (kiei)
Hello all, Just a quick question, is there anything like Microsoft Office Specialist Certification for LibO? Regadrs, Nguyen Vu Hung -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Re: [libreoffice-users] Re: replace text with text formatted by style

2011-10-14 Thread e-letter
On 13/10/2011, Andreas Säger saege...@t-online.de wrote: Use the Find All button to select all occurrences. Can see that in the 'find' dialogue window Double-click the character style. Cannot see this option; where is it please? -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread Mark Stanton
I think you will find that most of the industry, and nearly all of the open source community will be very unlikely to believe what Oracle says on this subject. It would be wise to consider that they may have a point. Mark Stanton One small step for mankind... -- For unsubscribe

[libreoffice-users] localc -convert-to uses Flat Xml for ods files

2011-10-14 Thread Joe Moudrik
Hello! I've run into problems converting from MS Excel .xls files to Open Document .ods files. I want to use the localc -convert-to in command line, so that the resulting document looks exactly the same when I open the .xls file by hand, and click on Save As. I thought, that this should do the

[libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread Ferry Toth
All this is true, but you might want to consider if you really want to use the built-in HSQLDB database for serious stuff. It is all java, which will never be really fast. Even with the java issues solved. With an external database you can avoid using the jdbc driver and instead use the SDBC

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread gael.lori...@laposte.net
I am sorry the bug already exists (#39212). I did check that the bug didn't exist before sending my first e-mail but unfortunately, at the time I used Alt in my search query keywords even though the key Alt has nothing to do with the Ctrl+ArrowKey feature (at the time I was mistaken and thought

Re: [libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread planas
Hi On Fri, 2011-10-14 at 13:41 +0200, Ferry Toth wrote: All this is true, but you might want to consider if you really want to use the built-in HSQLDB database for serious stuff. It is all java, which will never be really fast. Even with the java issues solved. With an external database

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread John Talbut
On 14/10/11 12:18, Mark Stanton wrote: I think you will find that most of the industry, and nearly all of the open source community will be very unlikely to believe what Oracle says on this subject. It would be wise to consider that they may have a point. All the more reason for us to do as

Re: [libreoffice-users] LibreOffice ceriticates

2011-10-14 Thread Tom Davies
Hi :) Nothing right now but there are hints that something might be announced in the Paris Conference.  Hmmm, when i say nothing there is a program being rolled-out in Venezuela apparently.  It might be worth asking again on the marketing list especially if you can wait until after the

[libreoffice-users] Re: replace text with text formatted by style

2011-10-14 Thread Andreas Säger
Am 14.10.2011 12:39, e-letter wrote: On 13/10/2011, Andreas Sägersaege...@t-online.de wrote: Use the Find All button to select all occurrences. Can see that in the 'find' dialogue window Double-click the character style. Cannot see this option; where is it please? And I don't even

[libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread Andreas Säger
Am 14.10.2011 13:41, Ferry Toth wrote: All this is true, but you might want to consider if you really want to use the built-in HSQLDB database for serious stuff. It is all java, which will never be really fast. Even with the java issues solved. This has nothing to do with HSQLDB which is a

[libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread Andreas Säger
According to Base developer Ocke Janssen, it is a Java problem and he filed an issue: http://comments.gmane.org/gmane.comp.openoffice.dba.user/7893 Ocke Janssen wrote in: http://openoffice.org/bugzilla/show_bug.cgi?id=117203 I did some performance tests and the problem seems to be in

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread Tom Davies
Hi :) Part of the reason why TDF broke away from Oracle was Oracle's refusal to consider patches, trouble-shooting or any other work done by the community.  Sun's reluctance (before Oracle) drove some people to set-up projects such as Go-oo which then reintegrated into TDF once there was a firm

[libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread Alexander Thurgood
Le 14/10/11 14:24, Andreas Säger a écrit : Hi Andreas, There is no SDBC driver for relational databases other than MySQL and Adabas. Lionel Mamane has recently added/developed/reworked code to get the SDBC postgresql connector extension working again, at least on Linux. Alex -- For

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread Tom Davies
Hi :) Wow, nicely found! :)  Thanks for adding the link to the thread so other people can use it in the future too. It's all good and works out in the end. Regards from Tom :) --- On Fri, 14/10/11, gael.lori...@laposte.net gael.lori...@laposte.net wrote: From: gael.lori...@laposte.net

Re: [libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread Heinrich Stoellinger
Hello, Has anything happened lately (within the past two to three weeks) with the native MySQL connector? I tried it and still cannot activate it. Talking MySQL: My fingers itch to try out MariaDB. It supposedly is a drop-in replacement to MySQL. Maybe the connector should be tested for that

[libreoffice-users] Re: Calc: cut/paste removes and renames protected field references - is this a bug?

2011-10-14 Thread Brian J.
Tom wrote: =INDIRECT(sheet1.a1) You sir, are a genius. Thank you, that did exactly what I needed. -- View this message in context: http://nabble.documentfoundation.org/Calc-cut-paste-removes-and-renames-protected-field-references-is-this-a-bug-tp3417657p3422096.html Sent from the Users

Re: [libreoffice-users] Re: Calc: cut/paste removes and renames protected field references - is this a bug?

2011-10-14 Thread Tanstaafl
On 2011-10-14 12:01 PM, Brian J. br...@opensourcery.com wrote: Tom wrote: =INDIRECT(sheet1.a1) You sir, are a genius. Thank you, that did exactly what I needed. That wasn't Tom, it was Steve Edmonds... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] Re: Calc: cut/paste removes and renames protected field references - is this a bug?

2011-10-14 Thread Cor Nouws
Hi Brain, Brian J. wrote (14-10-11 18:01) Tom wrote: [..] You sir, are a genius. Thank you, that did exactly what I needed. The part you quoted, was from From: Steve Edmonds steve.edmo...@ptglobal.com I am not sure if Tom deserves it to be mentioned a genius - he seems not to able to

[libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

2011-10-14 Thread Vinod Nadiadwala
Hi, I am having Libreoffice 3.4 installed on windows, i would like to know about following Calc menu's CALC : : 1) Insert - Formatting Mark 2) Format - Control 3) Format - Form I have checked Calc documentation and calc online help but didn't found much information about the same, i am

RE: [libreoffice-users] Re: Calc: cut/paste removes and renamesprotected field references - is this a bug?

2011-10-14 Thread V Stuart Foote
Cor, Ouch! Too harsh, take it down a notch... Stuart From: Cor Nouws [mailto:oo...@nouenoff.nl] Sent: Fri 10/14/2011 11:09 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Calc: cut/paste removes and renamesprotected field

[libreoffice-users] Calc crash when I try format cells

2011-10-14 Thread Otacílio
Dears When I try format cells calc is crashing. I have removed the .libreoffice dir but the bug persists. Someone can gime a hit about a solution? :( -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Where is Find? (Writer 3.4.3)

2011-10-14 Thread Libre User
I just updated to LO 3.4.3 in a Windows 7 laptop. [ctrl]+F used to bring up Find but now it doesn't. Checked keyboard shortcuts and it shows [ctrl]+F is 'find' for LO but is blank for Writer. Also menu selections editFind or editFind and Replace show keyboard shortcuts but don't work

Re: [libreoffice-users] Where is Find? (Writer 3.4.3)

2011-10-14 Thread Cor Nouws
Hi Jerry, Libre User wrote (14-10-11 22:20) I just updated to LO 3.4.3 in a Windows 7 laptop. [ctrl]+F used to bring up Find but now it doesn't. Checked keyboard shortcuts and it shows [ctrl]+F is 'find' for LO but is blank for Writer. Sorry to hear that it does not work or is not obvious.

RE: [libreoffice-users] Where is Find? (Writer 3.4.3)

2011-10-14 Thread V Stuart Foote
Jerry, Looks to be functional, but is state full in Windows 7, so it could be undocked somewhere in your UI that you can see as Cor suggests. Use the View -- Toolbars -- Find menu to toggle the Find box On. Then grab any toolbar and drag it to undock -- open the tool menu (down triangle)

Re: [libreoffice-users] Where is Find? (Writer 3.4.3)

2011-10-14 Thread Libre User
Thank you. Did not notice the new find toolbar at the bottom of the screen. Was looking for the old dialog box to open. I think I like the new toolbar better. Jerry At 01:28 PM 10/14/2011, you wrote: Hi Jerry, Libre User wrote (14-10-11 22:20) I just updated to LO 3.4.3 in a Windows 7

Re: [libreoffice-users] Re: Saving SXD = Blank Doc

2011-10-14 Thread Tom Davies
Hi :) My main worry would be about existing documents that might be opened and re-saved using the same format.  Also it would be nice to be able to convert large quantities of files without having to open each one individually or taking any action on a document-by-document basis.  Regards

[libreoffice-users] Fw: [MariaDB Announce] MariaDB 5.3.2-beta now available

2011-10-14 Thread Tom Davies
Hi :) MariaDb is a drop-in (or swap-in) replacement for MySql and seem to be developing quite a lot.  Possibly a little heavy for many desktop users but if you need some serious back-end power for Base then it might be exactly what you need. Regards from Tom :) --- On Fri, 14/10/11, MariaDB

Re: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

2011-10-14 Thread Hladůvka Jiří
Try to enter some text into the cell and while typing chose the option from menu. While you do not edit some text the options stay disabled (greyed) Dne 14.10.2011 18:49, Vinod Nadiadwala napsal(a): Hi, I am having Libreoffice 3.4 installed on windows, i would like to know about following

RE: [libreoffice-users] Where is Find? (Writer 3.4.3)

2011-10-14 Thread Libre User
Stuart, Thank you. I moved the find toolbar up to the top of the screen where it's much more useful for me. I also like the up/down arrows because I usually know which direction I want to search but with the old search box, it was usually set for the wrong direction. Jerry At 01:46 PM

[libreoffice-users] Re: Saving SXD = Blank Doc

2011-10-14 Thread NoOp
On 10/14/2011 01:03 AM, Alexander Thurgood wrote: Le 14/10/11 03:18, NoOp a écrit : The T/ESC (technical/engineering steering committee) make public the minutes of its meetings (posted on the wiki). If users want to know what's going on, it is in the minutes of these meetings that they will

Re: [libreoffice-users] Re: Base slowness and Java update

2011-10-14 Thread planas
On Fri, 2011-10-14 at 15:52 +0200, Heinrich Stoellinger wrote: Hello, Has anything happened lately (within the past two to three weeks) with the native MySQL connector? I tried it and still cannot activate it. Talking MySQL: My fingers itch to try out MariaDB. It supposedly is a drop-in

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread planas
On Fri, 2011-10-14 at 14:17 +0100, John Talbut wrote: On 14/10/11 12:18, Mark Stanton wrote: I think you will find that most of the industry, and nearly all of the open source community will be very unlikely to believe what Oracle says on this subject. It would be wise to consider that

Re: [libreoffice-users] Calc crash when I try format cells

2011-10-14 Thread Tom Davies
Hi Ouch.  Perhaps a fresh install?  Have you checked your installer download with md5sum? Which platform?  Windows, GnuLinux, Mac or something else?  Also do you know which version number of LibreOffice? Regards from Tom :) --- On Fri, 14/10/11, Otacílio otacilio.n...@ee.ufcg.edu.br wrote:

[libreoffice-users] Re: Calc: cut/paste removes and renamesprotected field references - is this a bug?

2011-10-14 Thread Tom
Hi :) Congrats on fixing the problem :) Thanks for the flowers but it was Steve Edmonds that gave the answer that helped you there so i'll pass the flowers on to him :) In Nabble it is possible to check a star by a good answer so i marked Steve's post like that. One of the dangers of snipping