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

2011-10-13 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 docum

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

2011-10-13 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 wrote: > Am 13.10.2011 13:06, Michael Guillet wrote: >> Hello, >> I was finally able to connect my LO database with my mysql

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

2011-10-13 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 wh

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

2011-10-13 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" ins

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

2011-10-13 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] Base slowness and Java update

2011-10-13 Thread John Talbut
Hi Tom On 14/10/11 02:56, you wrote: The OpenJDK website mentions Oracle a bit http://openjdk.java.net/faq/ About 2nd or 3rd main sub-heading is "Oracle's plans for OpenJDK". That page mentions Oracle quite a lot! However, they make a very clear commitment to open source and to welcoming out

[libreoffice-users] Re: Windows Explorer Extension

2011-10-13 Thread Boostland
No one else here having this issue ? -- View this message in context: http://nabble.documentfoundation.org/Windows-Explorer-Extension-tp3414735p3420569.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Probl

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

2011-10-13 Thread Boostland
On 14/10/2011 12:37 PM, Tom [via Document Foundation Mail Archive] wrote: > Hi :) > Would it be reasonably easy to generate a script to upgrade all the > sxd's to ODF using 3.4.2 as a headless horseman? > Regards from > Tom :) The document converter wizard in 3.4.3 converts all the existing SXD

Re: [libreoffice-users] replacement fonts?

2011-10-13 Thread Otacílio
Hello Tom! If someone send me replacement fonts I shall appreciate this, but I will appreciate more if this bug be fixed. []'s -Otacílio On 13/10/2011 22:40, Tom Davies wrote: Hi :) So do you need replacement fonts? There might be someone around in a day or so that might be able to help :)

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

2011-10-13 Thread Tom Davies
Hi :) OpenJDK is on Oracles list of OpenSource projects it runs http://oss.oracle.com/ The OpenJDK website mentions Oracle a bit http://openjdk.java.net/faq/ About 2nd or 3rd main sub-heading is "Oracle's plans for OpenJDK".  The Wikipedia page gives soem background http://en.wikipedia.org/wiki/

[libreoffice-users] replacement fonts?

2011-10-13 Thread Tom Davies
Hi :) So do you need replacement fonts?  There might be someone around in a day or so that might be able to help :) Regards from Tom :) --- On Thu, 13/10/11, Otacílio wrote: From: Otacílio Subject: Re: [libreoffice-users] LibreOffice Writer crashes when accessing the fonts pull down list To:

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

2011-10-13 Thread Tom Davies
Hi :) Would it be reasonably easy to generate a script to upgrade all the sxd's to ODF using 3.4.2 as a headless horseman? Regards from Tom :) --- On Thu, 13/10/11, Regina Henschel wrote: From: Regina Henschel Subject: Re: [libreoffice-users] Re: Saving SXD = Blank Doc To: users@global.libreof

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

2011-10-13 Thread Tom Davies
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 there to rename it.  Try calling it "fre

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

2011-10-13 Thread NoOp
On 10/13/2011 01:26 AM, Alexander Thurgood wrote: > Le 13/10/11 03:23, NoOp a écrit : > > Hi all, > > >> >> I like this part/comment: >> >>> Rainer Bielefeld 2011-10-09 23:52:53 PDT >> ... >>> >>> Yes, it's dataloss, but are there really many users who still need .sxd? >> >> Now that's the sp

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

2011-10-13 Thread Steve Edmonds
Hi. What about trying =INDIRECT("sheet1.a1") If my understanding of your requirement is correct, this seems to work. steve On 14/10/11 13:49, Brian J. wrote: > Andreas Säger-2 wrote: > >> You mean: How can I refer to one particular cell address? >> >> =OFFSET($SheetX.$A$1;2;3;4;5) >> >> >

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

2011-10-13 Thread Brian J.
Andreas Säger-2 wrote: > > You mean: How can I refer to one particular cell address? > > =OFFSET($SheetX.$A$1;2;3;4;5) > No, I mean how can I refer to a particular cell address no matter what a user does to that cell. Moving, cutting, pasting, overwriting, anything. I always want to point to

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

2011-10-13 Thread Andreas Säger
Am 13.10.2011 16:35, e-letter wrote: Readers, Is it possible to use the 'find' dialogue window to replace text that a style can be applied to? For example find text 'abc' and replace with 'abc' whereby a style (emphasised) is applied to the result. Use the "Find All" button to select all occu

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

2011-10-13 Thread Andreas Säger
Am 13.10.2011 17:47, Brian J. wrote: Andreas Säger-2 wrote: This is expected and wanted behaviour in all spreadsheet applications. That's odd. How can I truly protect the field references on a protected sheet from change? -- You mean: How can I refer to one particular cell address? =O

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

2011-10-13 Thread Regina Henschel
Hi Alexander, Alexander Thurgood schrieb: Le 13/10/11 17:02, Regina Henschel a écrit : Hi Regina, [..] I just had a thought that maybe this SXD export business is due to an incorrect mimetype setting similar to the one we encountered on bugzilla with the FlatXML ODG export filter and which

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

2011-10-13 Thread Alexander Thurgood
Le 13/10/11 17:02, Regina Henschel a écrit : Hi Regina, > As far as I understand it, only the binary formats will be disabled for > writing. That's the file format from StarOffice5.2 with file extensions > like sdw. > > The SX* formats are packages with content.xml and styles.xml, similar to > t

Re: [libreoffice-users] LibreOffice Writer crashes when accessing the fonts pull down list

2011-10-13 Thread Otacílio
On 13/10/2011 12:12, Regina Henschel wrote: Hi Otalcilio, Otacílio schrieb: Dears I migrated from openoffice to libreoffice 3.4.3 I'm getting a crash on all software from libreoffice when I access the fonts pull down list. There have been some bug reports for OOo about fonts, which lead to

[libreoffice-users] Base slowness and Java update

2011-10-13 Thread jowyta
Hello This topic has rather hijacked my question about base and external data tables so I am starting a separate thread. I am well aware of the problem, as summarised here: http://wiki.documentfoundation.org/Base The current workaround involves using an older version of openjdk-jre. (Not str

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

2011-10-13 Thread Brian J.
Andreas Säger-2 wrote: > > This is expected and wanted behaviour in all spreadsheet applications. > That's odd. How can I truly protect the field references on a protected sheet from change? -- View this message in context: http://nabble.documentfoundation.org/Calc-cut-paste-removes-and-rena

Re: [libreoffice-users] thinspace

2011-10-13 Thread T. R. Valentine
On 13 October 2011 09:53, e-letter wrote: > Is there a word processor equivalent to the \thinspace instruction in > LaTeX and ideally a keyboard shortcut to enter into documents? You didn't say what OS you are using, but there are a variety of spaces available using Unicode characters: U+2000 -

Re: [libreoffice-users] LibreOffice Writer crashes when accessing the fonts pull down list

2011-10-13 Thread Regina Henschel
Hi Otalcilio, Otacílio schrieb: Dears I migrated from openoffice to libreoffice 3.4.3 I'm getting a crash on all software from libreoffice when I access the fonts pull down list. There have been some bug reports for OOo about fonts, which lead to a crash. Please search the Bugzilla [1], to

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

2011-10-13 Thread Regina Henschel
Hi Alexander, Alexander Thurgood schrieb: Le 13/10/11 03:23, NoOp a écrit : Hi all, I like this part/comment: Rainer Bielefeld 2011-10-09 23:52:53 PDT ... Yes, it's dataloss, but are there really many users who still need .sxd? Now that's the spirit! Just so that you all know, th

[libreoffice-users] thinspace

2011-10-13 Thread e-letter
Readers, Is there a word processor equivalent to the \thinspace instruction in LaTeX and ideally a keyboard shortcut to enter into documents? Thanks. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-u

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

2011-10-13 Thread Tom Davies
Hi :) If you are talking about the pasted text having the same format as the text surrounding where you are placing it then i think that is posted as a bug-report already.  It was a very long time ago tho so it might be worth bumping the thread if you have soemthing useful to add (assuming you c

[libreoffice-users] Re: list box in database

2011-10-13 Thread Alexander Thurgood
Le 13/10/11 13:06, Michael Guillet a écrit : Hi Michael, > Hello, > I was finally able to connect my LO database with my mysql database, now I > just have to adjust the fields so they match. in my mysql database I have > fields with drop down lists using the field type SET. In LO its that > e

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

2011-10-13 Thread e-letter
Readers, Is it possible to use the 'find' dialogue window to replace text that a style can be applied to? For example find text 'abc' and replace with 'abc' whereby a style (emphasised) is applied to the result. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problem

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

2011-10-13 Thread Pedro
Doesn't it work if you simply press Ctrl+Arrow? I don't know your OS, but in Win XP it jumps to the first/last cell with data, unless I misunderstood your question... -- View this message in context: http://nabble.documentfoundation.org/to-bug-or-not-to-bug-that-is-the-question-tp3418532p3418702

[libreoffice-users] Re: list box in database

2011-10-13 Thread Andreas Säger
Am 13.10.2011 13:06, Michael Guillet wrote: Hello, I was finally able to connect my LO database with my mysql database, now I just have to adjust the fields so they match. in my mysql database I have fields with drop down lists using the field type SET. In LO its that equivalent to List Box in

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

2011-10-13 Thread Andreas Säger
Am 13.10.2011 05:50, Brian Jamison wrote: Steps to reproduce: On Sheet1 put data in fields A1, A2 On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2) Protect Sheet2 Cut the data in cell A1 Paste the data into A2 Cut the data in cell A2 Paste the data into A1 This is exp

[libreoffice-users] Re: Base - using external database tables

2011-10-13 Thread Andreas Säger
Am 13.10.2011 08:14, John Talbut wrote: Hi OK, let me go back to square 1. First of all I am not talking about a situation in which LibreOffice base needs to access data tables in separate files that use different database structures, e.g. one table is in MySQL and another is in PostgreSQL. Thi

Re: [libreoffice-users] Base - using external database tables

2011-10-13 Thread planas
On Thu, 2011-10-13 at 09:39 +0100, Mark Stanton wrote: > I think the simple answer to your question ("Is this the same in LO") > is "yes". But, as others have suggested, it is because you haven't > quite got the right way of looking at it. > > Using a database rather than a spreadsheet allows

Re: [libreoffice-users] Base - using external database tables

2011-10-13 Thread planas
John On Thu, 2011-10-13 at 07:14 +0100, John Talbut wrote: > Hi > > OK, let me go back to square 1. > > First of all I am not talking about a situation in which LibreOffice > base needs to access data tables in separate files that use different > database structures, e.g. one table is in MyS

[libreoffice-users] LibreOffice Writer crashes when accessing the fonts pull down list

2011-10-13 Thread Otacílio
Dears I migrated from openoffice to libreoffice 3.4.3 I'm getting a crash on all software from libreoffice when I access the fonts pull down list. My system is: [ota@squitch /usr/ports/editors/libreoffice]$ make showconfig ===> The following configuration options are available for libreoffi

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

2011-10-13 Thread gael.lori...@laposte.net
Hello, I don't know if this is the best place to ask this question but I could not find any better : there is a function in Calc that has been removed between LO3.3.3 ad LO3.4.3, but I don't know if that was made on purpose or not. If it as removed accidentaly, then maybe I could list it as a bu

Re: [libreoffice-users] Re: Base - using external database tables

2011-10-13 Thread Tom Davies
Hi :) Oracle seem to have been treating this community as a competitor since before the split away from OpenOffice.  Apparently there have been a lot of attempts at co-operating with them but Oracle tend to refuse to respond.  Both normal Java and openJDK are run by Oracle.  The LO devs have bee

[libreoffice-users] list box in database

2011-10-13 Thread Michael Guillet
Hello, I was finally able to connect my LO database with my mysql database, now I just have to adjust the fields so they match. in my mysql database I have fields with drop down lists using the field type SET. In LO its that equivalent to List Box in the Forms View? if yes how do I get the valu

[libreoffice-users] Re: Base - using external database tables

2011-10-13 Thread Alexander Thurgood
Le 13/10/11 10:54, John Talbut a écrit : Hi John, >> > I am aware of this. I am not really interested in who is to blame, it > needs sorting for current versions of JDK. If you or anyone has any > idea what the change is in JDK that has led to this problem please > answer at http://lists.freede

[libreoffice-users] Re: Base - using external databases

2011-10-13 Thread Andreas Säger
Hi, Linking tables from different database is impossible. I know one partial work-around for this limitation: You can create a form on a stand-alone document, say some Writer document with a "MainForm" bound to some table/query in data source "Source A". Then you can add a subform, say "SubForm

Re: [libreoffice-users] Re: Base - using external database tables

2011-10-13 Thread John Talbut
Hi Alex Thanks for your response. On 13/10/11 09:19, Alexander Thurgood wrote: Le 13/10/11 08:14, John Talbut a écrit : This has worked adequately (clunkily I would say, but I will keep other difficulties out of this discussion). However, base has recently become unusably slow in response to

Re: [libreoffice-users] Base - using external database tables

2011-10-13 Thread Mark Stanton
I think the simple answer to your question ("Is this the same in LO") is "yes". But, as others have suggested, it is because you haven't quite got the right way of looking at it. Using a database rather than a spreadsheet allows you to group things according to the content of the data rather t

[libreoffice-users] Re: Problem with Mail Merge

2011-10-13 Thread Alexander Thurgood
Le 11/10/11 19:07, Barbara Tobias a écrit : Hi Barbara, > After opening Tools/Mail Merge Wizard, we can select starting document > and select document type with no problem. Under "Insert address block" > we select the same Access table that we have been using for several > years, but step 2, se

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

2011-10-13 Thread Alexander Thurgood
Le 13/10/11 03:23, NoOp a écrit : Hi all, > > I like this part/comment: > >> Rainer Bielefeld 2011-10-09 23:52:53 PDT > ... >> >> Yes, it's dataloss, but are there really many users who still need .sxd? > > Now that's the spirit! > Just so that you all know, the engineering committe decide

[libreoffice-users] Re: Base - using external database tables

2011-10-13 Thread Alexander Thurgood
Le 13/10/11 08:14, John Talbut a écrit : Hi John, > Now, to my situation. First of all I am using Debian GNU/Linux testing > distribution. I use LibreOffice and for my database needs I use base. I > use the built in HSQLDB database application and have my data tables > embedded in the .odb file

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

2011-10-13 Thread Stephan Zietsman
Brian Jamison wrote: > Steps to reproduce: > On Sheet1 put data in fields A1, A2 > On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2) > Protect Sheet2 > Cut the data in cell A1 > Paste the data into A2 > Cut the data in cell A2 > Paste the data into A1 > > Both field referen