Re: [libreoffice-users] Possible to write reports with relationship data?

2013-05-15 Thread Tom Davies
Hi :) Have you tried doing Reports in Writer?  Writer should be able to use the database as it's data-source and then you put the fields in the appropriate places with whatever formatting you like that Writer has. Regards from Tom :)  From: David Karr

Re: [libreoffice-users] Re: re. doc to pdf

2013-05-15 Thread Tom Davies
Hi :) Just because 3 different ways have been described doesn't mean you have to argue the merits of all 3.  Just use whichever one you like first time and then maybe try others ion the future sometime to see the difference.  The first answer was the best because it was the first and given

[libreoffice-users] deploy java macro with document

2013-05-15 Thread Vieri
Hi, I'd like to deploy a compiled Java macro with an ODT document. According to http://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Writing_Macros: If you want to deploy the macro to a document you need to place it in a Scripts/java directory within the document zip file. What

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 05:42, David Karr a écrit : Hi David, If I have a main entity, and I have two one-to-many relationships to other tables (FK links from the other tables to the main table), is there any way to generate a report with the main table data, and the data for the other relationships

[libreoffice-users] Re: Base data-loss and other problems

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 00:53, Dan Lewis a écrit : And what would HSQLDB 2.x be with Base connecting to the database files that have been extracted from an embedded ODB file? One guru on this mailing list seems to have reported that it works well. Look up DACM as user name on the OpenOffice.org

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Tom Davies
Hi :) I'm not certain but something like this? 1.  Make a copy of the file 2.  Rename the file-ending from .odt to .zip 3.  double-click on the file (note that some users, usually on GnuLinux can simply right click on the file and choose Open With ... to choose Archive Manager, or

[libreoffice-users] Re: Italics and bold in BASE.

2013-05-15 Thread Alexander Thurgood
Le 14/05/13 12:40, Ian Whitfield a écrit : Hi Ian, Open in normal mode and whatever you enter in the field will have the Italics and/or Bold that you selected above. I suspect that what the original poster is looking for is the possibilty to type text strings into memo/longvarchar type

[libreoffice-users] Re: Italics and bold in BASE.

2013-05-15 Thread Alexander Thurgood
Le 14/05/13 00:17, acanela a écrit : Hi acanela, Hello, I´m a Libreoffice user and I´d like to use italics and bold in Base. Is it possible? It would be so important to me. No, this is not possible. See my response in the other thread where your question was re-posted. Only forms can

Re: [libreoffice-users] Re: Base data-loss and other problems

2013-05-15 Thread Dan Lewis
On 05/15/2013 05:30 AM, Alexander Thurgood wrote: Le 15/05/13 00:53, Dan Lewis a écrit : And what would HSQLDB 2.x be with Base connecting to the database files that have been extracted from an embedded ODB file? One guru on this mailing list seems to have reported that it works well.

Re: [libreoffice-users] Re: colour printing bug in Writer?

2013-05-15 Thread Helen
Yes, I have Epson 1400 printer, and I have to do that each time as well. It's a bug. On Mon, May 13, 2013 at 1:09 AM, Marc Paré m...@marcpare.com wrote: Le 11/05/13 04:17 PM, Steve Edmonds a écrit : On 2013-05-12 07:18, Marc Paré wrote: Le 05/05/13 07:04 PM, Steve Edmonds a écrit : Do

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Vieri
Thanks to both Brian and Tom. I didn't know the odt files were compressed files. So now I have to re-think my webdav solution because I was hoping to deploy just one copy of my java macro via HTTP. This would allow me to publish my java macro updates on a web server and also publish many odt

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Vieri
hmm, spoke too soon. If I follow your steps I get the following error when trying to open my modified .odt file (with Scripts/java/etc. in the zip's root dir): General Error. General input/output error. I tried other subdirs but the result was the same. I noticed that the Basic scripts where at

Re: [libreoffice-users] Re: Base data-loss and other problems

2013-05-15 Thread Tom Davies
Hi :) I think several people said it worked quite well as an external back-end.  The only problems with the internal version is that it got heavily tweaked and is now quite an ancient version.  Obviously both the internal and external versions rely on using Java and that may be an additional

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Tom Davies
Hi :) Hmmm, i sometimes get that error message when i try to save to the network file-shares here.  If i save to the local machine and then copy onto the network it seems fine.  I've had the same problem with a couple other apps and other machines so i assumed it was related to network issues

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Tom Davies
Hi :) Hmmm, i sometimes get that error message when i try to save to the network file-shares here.  If i save to the local machine and then copy onto the network it seems fine.  I've had the same problem with a couple other apps and other machines so i assumed it was related to network issues

[libreoffice-users] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Steven Friedrich
I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? To save a little time, let me explain my question. I have a Base Form that uses a ListBox based on a SQL query. When a record is updated, I want

Re: [libreoffice-users] Opening recent Writer documents takes me to start of doc in LibO v.4.0.3.3

2013-05-15 Thread Sigrid Carrera
Hi, Have you entered your name in the tools Options settings? LO needs to have at lease your name to be able to bring you to the last used position. Sigrid -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Tom Davies
Hi :) I think the devs list might usually be the best place for this sort of thing but you just happen to catch this list at a particularly good time and it's been this way for years already.  From my limited understanding of database programs isn't it better to use Queries for the SQL?  Then

[libreoffice-users] Re: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 14:24, Steven Friedrich a écrit : Hi Steven, I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? Ask here :

[libreoffice-users] Re: colour printing bug in Writer?

2013-05-15 Thread Marc Paré
Can anyone on this thread see if this bug has been submitted? If not, could you submit it? It would really help out if you submitted it and we can all then confirm the bug and add our own information to it. I am a little swamped with work right now. The BSA (Bug Submission Assistant) is here:

Re: [libreoffice-users] .doc to pdf

2013-05-15 Thread Johnny Rosenberg
2013/5/14 Kieran Peckett crazyske...@gmail.com: Choose File Export to export to a PDF. There is even a button for it in the tool bar… -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] .doc to pdf

2013-05-15 Thread Kieran Peckett
Yes, but that doesn't give you the dialogue box to set the settings. On 15 May 2013 16:13, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2013/5/14 Kieran Peckett crazyske...@gmail.com: Choose File Export to export to a PDF. There is even a button for it in the tool bar… -- To

Re: [libreoffice-users] .doc to pdf

2013-05-15 Thread Johnny Rosenberg
2013/5/15 Kieran Peckett crazyske...@gmail.com: Yes, but that doesn't give you the dialogue box to set the settings. I know. My point was rather that all you have to do to find the answer to the original question in this thread, is to open LibreOffice, and there it is, the PDF export button… On

Re: [libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread David Karr
Let me give some example background to see if this can work. Let's say we have an animals database, for someone maintaining an animal shelter. Each animal has a list of medical care events and also a list of adoptions (some animals return to the shelter). The medicalCareEvents and adoptions

Re: [libreoffice-users] Possible to write reports with relationship data?

2013-05-15 Thread David Karr
No, I haven't gotten into that yet. I assume I can do some sort of looping construct in writer that will allow me to step through rows in both the main table and the relationships tables? Can I use Java or Javascript to do that iteration? On Wed, May 15, 2013 at 1:13 AM, Tom Davies

[libreoffice-users] Re: Fwd: ”Artifacts” in OpenOffice and LibreOffice

2013-05-15 Thread Johnny Rosenberg
2013/5/15 Johnny Rosenberg gurus.knu...@gmail.com: 2013/5/15 Ric Moore wayward4...@gmail.com: On 05/12/2013 03:47 PM, Johnny Rosenberg wrote: I am not sure it's even possible to replace my graphics card; it's a laptop. I have been planning to replace it with a desktop computer since 2010,

[libreoffice-users] LibreOffice Portable Writer changes my custom style?

2013-05-15 Thread 胡小柯
hi, I have create a style for paragraph: English font is Times New Roman, font size is 12 pt. And it appears that the current style is my custom style, but when I type some English words, it change to font cajcd-fntaa, font size 13.6 pt. What wrong? I'm using LibreOffice Portable 4.0.3.3 on

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : Hi David, No, I haven't gotten into that yet. I assume I can do some sort of looping construct in writer that will allow me to step through rows in both the main table and the relationships tables? Can I use Java or Javascript to do that iteration?

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : Me again. No, I haven't gotten into that yet. I assume I can do some sort of looping construct in writer that will allow me to step through rows in both the main table and the relationships tables? Can I use Java or Javascript to do that iteration?

[libreoffice-users] Re: Possible to write reports with relationship data?

2013-05-15 Thread Alexander Thurgood
Le 15/05/13 18:09, David Karr a écrit : This too, might help you along : http://forum.openoffice.org/en/forum/viewtopic.php?f=13t=10865p=51051hilit=two+queries+in+one+writer+document#p51051 As I mentioned in a previous response, I'm really not sure about whether you can insert two different

[libreoffice-users] How to unprotect readonly parts of a document?

2013-05-15 Thread Alan Stern
I'm having trouble with LibreOffice 3.6. A file I was given contains regions that are readonly, and I can't figure out how to unprotect them in order to edit them. The usual advice in the archives is to use the Format - Sections menu option. That doesn't work here; the Sections line in the

Re: [libreoffice-users] How to unprotect readonly parts of a document?

2013-05-15 Thread anne-ology
Probably the simplest method is to right-click on the document - prior to opening it - when a block appears, choose 'properties' -- click to dis-allow 'read-only' -- the document should then be able to be edited. On Wed, May 15, 2013 at 2:52 PM, Alan

[libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Carl Paulsen
Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do

Re: [libreoffice-users] How to unprotect readonly parts of a document?

2013-05-15 Thread Alan Stern
On Wed, 15 May 2013, Alan Stern wrote: I'm having trouble with LibreOffice 3.6. A file I was given contains regions that are readonly, and I can't figure out how to unprotect them in order to edit them. The usual advice in the archives is to use the Format - Sections menu option. That

Re: [libreoffice-users] How to unprotect readonly parts of a document?

2013-05-15 Thread Alan Stern
On Wed, 15 May 2013, anne-ology wrote: Probably the simplest method is to right-click on the document - prior to opening it - when a block appears, choose 'properties' -- click to dis-allow 'read-only' -- the document should then be able to be

Re: [libreoffice-users] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Girvin R. Herr
Steven Friedrich wrote: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? To save a little time, let me explain my question. I have a Base Form that uses a ListBox based on a SQL query. When

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Carl Paulsen
Another way to state this is I'd like a Columns to Text function, but where I can specify semi-colon as the separator and it won't place two separators together consecutively. Thanks again, Carl On 5/15/13 4:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Dave Liesse
All I've ever been aware of is nested IF statements, which get to be a royal pain. If there is a CASE equivalent (it's also present in just about any programming language), I'll be just as happy as you! Dave On 5/15/2013 13:16, Carl Paulsen wrote: Anyone know if there is an equivalent to

Re: [libreoffice-users] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Joel Madero
Indeed I would agree that this probably doesn't belong on dev channel - there we discuss code not how to's or feature requests. I actually would have just recommended the user list :) If that fails, the OOo forum is good, also our Ask site have some great contributors that know quite a bit. If

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Dan Lewis
On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is,

Re: [libreoffice-users] I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

2013-05-15 Thread Dan Lewis
On 05/15/2013 08:24 AM, Steven Friedrich wrote: I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API. Is this the right place? To save a little time, let me explain my question. I have a Base Form that uses a ListBox

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Carl Paulsen
So in the absence of a Case function, here's what I've done so far as a calculated solution. Note that the data I want to concatenate is in cells U3, V3, W3, and X3. In Y3, I put the following: =U3 IF(NOT(isempty(U3)),;,) V3 IF(NOT(isempty(V3)),;,) W3 IF(NOT(isempty(W3)),;,) X3 The

[libreoffice-users] Re: [libreoffice-documentation] Documenta

2013-05-15 Thread Tim Lloyd
Hi Susan and welcome to LibreOffice. There was a thread about this back in January which may be of help. I haven't tried it: https://www.libreoffice.org/get-help/nabble-mailing-list-interface/ Also, I have copied this to the users list which is probably a better resource. The docs list is

Re: [libreoffice-users] How to unprotect readonly parts of a document?

2013-05-15 Thread anne-ology
When I click on this URL, a HTML document appears based from LO - with only 1 line. I can delete, add, ... to this line. Hopefully someone else will understand your question and will come to your aid - as for me, your question is beyond me. BTW

Re: [libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Carl Paulsen
At long last I got this to work. Syntax is ISBLANK and not ISEMPTY - aaa. My Filemaker days are getting in my way. Replace all isempty below with ISBLANK and it works perfectly now. Carl On 5/15/13 6:38 PM, Carl Paulsen wrote: So in the absence of a Case function, here's what

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Andrew Douglas Pitonyak
On 05/15/2013 05:25 AM, Vieri wrote: Hi, I'd like to deploy a compiled Java macro with an ODT document. Can you do that? You can do this with JavaScript, but Java, really? I had no idea. According to http://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Writing_Macros: If you

Re: [libreoffice-users] deploy java macro with document

2013-05-15 Thread Andrew Douglas Pitonyak
I ran out of time, but this might be of interest http://www.mail-archive.com/dev@api.openoffice.org/msg08867.html http://www.openoffice.org/api/docs/common/ref/com/sun/star/embed/Storage.html http://www.openoffice.org/api/docs/common/ref/com/sun/star/embed/StorageFactory.html Hope this helps.

Re: [libreoffice-users] LibreOffice Portable Writer changes my custom style?

2013-05-15 Thread Brian Barker
At 01:03 16/05/2013 +0800, Huxiao Ke wrote: I have create a style for paragraph: English font is Times New Roman, font size is 12 pt. And it appears that the current style is my custom style, but when I type some English words, it change to font cajcd-fntaa, font size 13.6 pt. What wrong?