date:20130515

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 davidmichaelk...@gmail.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 4:42
Subject: [libreoffice-users] Possible to write reports with relationship data?
 

All the report tutorials I've seen seem somewhat primitive, in terms of
what kinds of structures can be printed.

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 also included (indented and formatted properly)?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 quite quickly.  

In most User Support places that would be the end of the ticket but here we 
carry on and give other options and discuss side-issues.  The original poster 
still hasn't told us that we solved the problem so we keep finding other ways 
until he's happy.  Sometimes even after that we carry on discussing the issues. 
 I don't see that as a bad thing.  

I have just thought of another way and i'm somewhat surprised that no-one else 
seems to have pointed it out.  There must be at least 1 headless way.  
Something like

libreoffice --convert-to pdf /path-name/file-name

but i doubt that is exactly right!  
Regards from 
Tom :)  







 From: John Meyer john.l.me...@gmail.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 3:48
Subject: Re: [libreoffice-users] Re: re. doc to pdf
 

Usually I think of the opening scene in Tom Jones, where the two doctors 
keep arguing over the patient about what's ailing him until he dies.


On 5/14/2013 10:34 AM, anne-ology wrote:
         and a 'pair of ducks' swim o'er the pond  ;-)
              [well, my mind tends to wander  ;-) ]



 On Tue, May 14, 2013 at 11:29 AM, Tom Davies tomdavie...@yahoo.co.ukwrote:

 Hi :)
 A paradox is ...
 There is always an exception to every rule.
 Regards from
 Tom :)


    --
   *From:* anne-ology lagin...@gmail.com
 *To:* Tom Davies tomdavie...@yahoo.co.uk
 *Cc:* Daulat Raikar daulat.rai...@gmail.com; 
 users@global.libreoffice.org users@global.libreoffice.org
 *Sent:* Tuesday, 14 May 2013, 17:18
 *Subject:* [libreoffice-users] Re: re. doc to pdf

        You're right; both of these methods work -
              when the message stated 'convert', I wasn't thinking 'print'  [
 oops  ;-) ]

        Yes 'printing to file' is a great way to change any document to an
 editable one -
              [I'm sure there are exceptions to this - I've used the word
 'any' so those knowing the exceptions will come forth anon]



 On Tue, May 14, 2013 at 10:42 AM, Tom Davies tomdavie...@yahoo.co.uk
 wrote:
 Hi :)
 Another way, but i think this is only on GnuLinux (such as Ubuntu,
 Mageia, Mint, OpenSUSE, Redhat, Chrome etc)

 File - Print - Print to file

 this way embeds all the fonts and stuff into the Pdf image.  It's a bit
 more awkward because you have to play around with the different tabs in
 the
 printer dialogue-box.  Anne's method is the one i usually go for

 File - Export as Pdf

 This way gives you tons more options such as how much compression and
 what
 type, whether to add PDF/A1 to help people with screen-readers be able to
 read the document more easily.  It even gives an option of adding the
 .odt
 into the Pdf so that LibreOffice users can edit the file more easily.
 Non-LibreOffice users just don't see the editable file hidden inside.

 Regards from
 Tom :)




   *From:* anne-ology lagin...@gmail.com
 *To:* Daulat Raikar daulat.rai...@gmail.com
 *Cc:* users@global.libreoffice.org
 *Sent:* Tuesday, 14 May 2013, 16:34
 *Subject:* re. doc to pdf
         Yes;
           to do so:
             when you open the document, go to the files at the top --
             go down list to convert to ...  --
             one of the options is PDF files;
               clicking on this will cause a block to appear asking where
 you desire to save this document -
                 choose the location, and click ok.

         BTW - you can subscribe to this list by sending an e-mail to
 users+subscr...@global.libreoffice.org



 Hello

 Is it possible for a document to be converted to PDF format?

 Daulat Raikar




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 does that mean exactly?

I tried the following:
I saved the ODT file within a subdir and placed my Java macro (and descriptor 
file) within subdir/Scripts/java/MYJAVAMACRO.
If I load the document and go to Tools-Macros-Run macros, I can't see my Java 
macro under the document tree.

What am I doing wrong?

Eventually I'd like to store my odt + java macros within a webdav directory so 
that the dir structure would be something like this:
https://server.com/webdav/docs/doc1.odt
https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/parcel-descriptor.xml
https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/MYJAVAMACRO.jar

Clients would open the ODT files like this:

soffice -o https://server.com/webdav/docs/doc1.odt

I can't seem to load the Java macro in my webdav setup but I'd first like to 
see if I can load it in my local setup.

Thanks,

Vieri


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 also included (indented and formatted properly)?
 

Perhaps I'm misunderstanding here, but surely using a Query or a View
which pulls in the data from your 1-to-N tables, grouped as you want
them, as the basis for your report, would suffice ?


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 Base forum. He has
longstanding experience with using Base/HSQLDB in split mode. There is
even a link to a downloadble file that helps you set this up, i.e.
provides what OOo and LO fail to actually do at the moment. Looks
promising, am going to play around with it soon.


Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 WinZip/WinRar or 
whatever you use to compress files)  

Now you can see files and folders inside the document.  I'm guessing you can 
just create the folder you want, drop the macro in and then change the 
file-ending again back to Odt this time.  

Errr, the reason for making a copy is that i'm not convinced this is going to 
work so you'll need to be able to go back to the original if it really messes 
things up.
Regards from 
Tom :)  







 From: Vieri rentor...@yahoo.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 10:25
Subject: [libreoffice-users] deploy java macro with document
 

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 does that mean exactly?

I tried the following:
I saved the ODT file within a subdir and placed my Java macro (and descriptor 
file) within subdir/Scripts/java/MYJAVAMACRO.
If I load the document and go to Tools-Macros-Run macros, I can't see my 
Java macro under the document tree.

What am I doing wrong?

Eventually I'd like to store my odt + java macros within a webdav directory so 
that the dir structure would be something like this:
https://server.com/webdav/docs/doc1.odt
https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/parcel-descriptor.xml
https://server.com/webdav/docs/Scripts/java/MYJAVAMACRO/MYJAVAMACRO.jar

Clients would open the ODT files like this:

soffice -o https://server.com/webdav/docs/doc1.odt

I can't seem to load the Java macro in my webdav setup but I'd first like to 
see if I can load it in my local setup.

Thanks,

Vieri


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 field and then
selectively enable the bold or italic attributes, as apparently one can
do in Access (or in other DB GUI frontend software).

Unfortunately, whilst this is possible in Base if you change the
properties of your text field to Multiline with formatting, nothing
you write in that field will be bound to the underlying data table :

- additionally, this doesn't even currently work on OSX (bug), i.e. the
attributes show no visible change, even if they are chosen from the
right mouse button click context menu when selecting a typed-in word;

- any text that is already present in the underlying table to which the
text field control was previously bound will become invisible ;

- as the text data which is newly entered or modified is not bound to
the field of the corresponding data table, it can never be written to
the table, which means that closing the form and then re-opening it
results in the loss of any data you might just have entered - at least,
this is certainly the case on OSX (having just tried it).


All in all, a pretty useless feature, except perhaps if you just want
your form to contain some bold or underlined formatted text, e.g. as a
warning, general information, or other reminder, to the user of the form.

The whole notion of formatted fields is hopelessly underdeveloped in
Base. Oh, and did I forget to mention that it doesn't work on OSX ;-) so
its not even cross-platform compatible, meaning that you can't swap with
your colleagues and friends on other OSes and expect to see the same
thing - magnifique, non ?


Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 have a multiline with formatting text control.

The text entered into such a control is not bound to any underlying
field of a database table, and so can not be stored in the database.
Basically, such a control is only any good for informational purposes
for the user of the form.

If you are using LibreOffice on OSX, even the change of attributes
functionality doesn't work (bug).

Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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.

Look up DACM as user name on the OpenOffice.org Base forum. He has
longstanding experience with using Base/HSQLDB in split mode. There is
even a link to a downloadble file that helps you set this up, i.e.
provides what OOo and LO fail to actually do at the moment. Looks
promising, am going to play around with it soon.


Alex
What I learned last night is that HSQLDB is available as a binary on 
Linux repositories. It appears to be one of the installed packages in 
Ubuntu 12.04 (libhsqldb-java).


--Dan

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 you see controls for Landscape? What does it do if you choose it

It is some dicky issue with the Brother driver and LO on Linux. I have
seen some discussion and it is just as easy to print to PDF and print
that.

Actually, I also have a Brother printer and the same fix is to choose
the correct device drive with through LibreOffice.

Print-Properties-Device and choose PostScript Level 3. This fixes
the problem.

Cheers,

Marc

Thanks. It does too. But I can't set this permanently. The settings in
spadmin won't stick.
Steve

Yes, Tim and I are not sure if this is a problem with LibreOffice or with
our systems. The device sticks until you exit out of LibreOffice. If you
open LibreOffice again, you have to change the device again. I wonder if
anyone else has this problem where the device defaults to the wrong one and
you have to manually change it each time you open a fresh version of
LibreOffice.

Cheers,

Marc

--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org

--
To unsubscribe e-mail to:
users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette http://wiki.documentfoundation.org/Netiquette
List archive:
http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

--
Helen Etters
using Linux, suse11.4

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 docs and templates that 
use this macro. So I guess I'll need to do a basic macro within the document 
which in turn downloads an updated copy of the Java macro and places it in, 
say, the user's LO appdata dir. The trick would be to reload/restart LO so it 
can correctly load the newly downloaded macro.

Anyway, thanks for the odt/zip info.

Vieri

--- On Wed, 5/15/13, Brian Barker b.m.bar...@btinternet.com wrote:

  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 does that mean exactly?
 
 I'm guessing, but I'm pretty sure I know the answer.
 
 Open Document Format files are zip archives; so the
 document zip file is the .odt document file itself.
 o Rename the ,odt file to change its extension to .zip.
 o Double-click to unzip the archive.
 o Create a new folder named Scripts in the same folder as
 the unzipped material and another named java within it.
 o Copy your macro into .../java.
 o Select all the files and rezip them into an archive.
 o Rename the archive to change the extension back to .odt.
 o Double-click to test.
 
 Depending on your operating system and file associations,
 you may be able to unzip and zip without renaming the
 files.  Once you have embedded your macro, you will not
 need to do anything special when distributing your document
 file to others.
 
 I trust this helps.
 
 Brian Barker - privately
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 the top-most level, under 
Basic-MacroName, etc.
So I tried also putting java at the top-level (without Scripts) but the 
same error message came up.

Vieri

--- On Wed, 5/15/13, Vieri rentor...@yahoo.com wrote:

 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 docs and templates that
 use this macro. So I guess I'll need to do a basic macro
 within the document which in turn downloads an updated copy
 of the Java macro and places it in, say, the user's LO
 appdata dir. The trick would be to reload/restart LO so it
 can correctly load the newly downloaded macro.
 
 Anyway, thanks for the odt/zip info.
 
 Vieri
 
 --- On Wed, 5/15/13, Brian Barker b.m.bar...@btinternet.com
 wrote:
 
   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 does that mean exactly?
  
  I'm guessing, but I'm pretty sure I know the answer.
  
  Open Document Format files are zip archives; so the
  document zip file is the .odt document file itself.
  o Rename the ,odt file to change its extension to
 .zip.
  o Double-click to unzip the archive.
  o Create a new folder named Scripts in the same folder
 as
  the unzipped material and another named java within
 it.
  o Copy your macro into .../java.
  o Select all the files and rezip them into an archive.
  o Rename the archive to change the extension back to
 .odt.
  o Double-click to test.
  
  Depending on your operating system and file
 associations,
  you may be able to unzip and zip without renaming the
  files.  Once you have embedded your macro, you will
 not
  need to do anything special when distributing your
 document
  file to others.
  
  I trust this helps.
  
  Brian Barker - privately
  
  
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 problem.  
Regards from 
Tom :)






 From: Dan Lewis elderdanle...@gmail.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 11:30
Subject: Re: [libreoffice-users] Re: Base data-loss and other problems
 

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.
 Look up DACM as user name on the OpenOffice.org Base forum. He has
 longstanding experience with using Base/HSQLDB in split mode. There is
 even a link to a downloadble file that helps you set this up, i.e.
 provides what OOo and LO fail to actually do at the moment. Looks
 promising, am going to play around with it soon.


 Alex
What I learned last night is that HSQLDB is available as a binary on 
Linux repositories. It appears to be one of the installed packages in 
Ubuntu 12.04 (libhsqldb-java).

--Dan

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 at my end.  
Regards from
Tom :)






 From: Vieri rentor...@yahoo.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 12:44
Subject: Re: [libreoffice-users] deploy java macro with document
 

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 the top-most level, under 
Basic-MacroName, etc.
So I tried also putting java at the top-level (without Scripts) but the 
same error message came up.

Vieri

--- On Wed, 5/15/13, Vieri rentor...@yahoo.com wrote:

 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 docs and templates that
 use this macro. So I guess I'll need to do a basic macro
 within the document which in turn downloads an updated copy
 of the Java macro and places it in, say, the user's LO
 appdata dir. The trick would be to reload/restart LO so it
 can correctly load the newly downloaded macro.
 
 Anyway, thanks for the odt/zip info.
 
 Vieri
 
 --- On Wed, 5/15/13, Brian Barker b.m.bar...@btinternet.com
 wrote:
 
   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 does that mean exactly?
  
  I'm guessing, but I'm pretty sure I know the answer.
  
  Open Document Format files are zip archives; so the
  document zip file is the .odt document file itself.
  o Rename the ,odt file to change its extension to
 .zip.
  o Double-click to unzip the archive.
  o Create a new folder named Scripts in the same folder
 as
  the unzipped material and another named java within
 it.
  o Copy your macro into .../java.
  o Select all the files and rezip them into an archive.
  o Rename the archive to change the extension back to
 .odt.
  o Double-click to test.
  
  Depending on your operating system and file
 associations,
  you may be able to unzip and zip without renaming the
  files.  Once you have embedded your macro, you will
 not
  need to do anything special when distributing your
 document
  file to others.
  
  I trust this helps.
  
  Brian Barker - privately
  
  
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 at my end.  
Regards from
Tom :)





 From: Vieri rentor...@yahoo.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 12:24
Subject: Re: [libreoffice-users] deploy java macro with document
 

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 docs and 
templates that use this macro. So I guess I'll need to do a basic macro within 
the document which in turn downloads an updated copy of the Java macro and 
places it in, say, the user's LO appdata dir. The trick would be to 
reload/restart LO so it can correctly load the newly downloaded macro.

Anyway, thanks for the odt/zip info.

Vieri

--- On Wed, 5/15/13, Brian Barker b.m.bar...@btinternet.com wrote:

  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 does that mean exactly?
 
 I'm guessing, but I'm pretty sure I know the answer.
 
 Open Document Format files are zip archives; so the
 document zip file is the .odt document file itself.
 o Rename the ,odt file to change its extension to .zip.
 o Double-click to unzip the archive.
 o Create a new folder named Scripts in the same folder as
 the unzipped material and another named java within it.
 o Copy your macro into .../java.
 o Select all the files and rezip them into an archive.
 o Rename the archive to change the extension back to .odt.
 o Double-click to test.
 
 Depending on your operating system and file associations,
 you may be able to unzip and zip without renaming the
 files.  Once you have embedded your macro, you will not
 need to do anything special when distributing your document
 file to others.
 
 I trust this helps.
 
 Brian Barker - privately
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 the ListBox to requery.

 

In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

 

How do I get a Form to requery in LibreOffice?


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 the Form gets it's data from the Query.  Presumably 
that way would refresh the data almost instantly?  It looks like you might 
already be doing it that way.  

Are you using an external back-end for the Tables of data?  If so which one?  
MySql/MariaDb, Postgresql, something else?  

Also is your form in Writer or in Base?  Would it work better in Writer?  
Regards from 
Tom :)  







 From: Steven Friedrich steven.e.friedr...@gmail.com
To: users@global.libreoffice.org 
Sent: Wednesday, 15 May 2013, 13:24
Subject: [libreoffice-users] I'm looking for a place where I can ask questions 
about programming Base applications, using LibreBasic and the API.
 

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 the ListBox to requery.



In Microsoft Access, I just said Requery and I didn't even need to specify
the control.



How do I get a Form to requery in LibreOffice?


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 :

http://forum.openoffice.org/en/forum/viewforum.php?f=13sid=85991db5df93b3c27fc367c8a30026e4


Although the forum says it is for OpenOffice, they will accept questions
about LibreOffice, especially with regard to Base where there are still
relatively few differences in functionality between the AOO and LO code
bases.



Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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:
https://www.libreoffice.org/get-help/bug/

Marc

Le 15/05/13 07:06 AM, Helen a écrit :

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 you see controls for Landscape? What does it do if you choose it

It is some dicky issue with the Brother driver and LO on Linux. I have
seen some discussion and it is just as easy to print to PDF and print
that.

Actually, I also have a Brother printer and the same fix is to choose
the correct device drive with through LibreOffice.

Print-Properties-Device and choose PostScript Level 3. This fixes
the problem.

Cheers,

Marc

Thanks. It does too. But I can't set this permanently. The settings in
spadmin won't stick.
Steve

Cheers,

Marc

--
Marc Paré
m...@marcpare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org

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 guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 the other hand, there are a lot
of other buttons as well, so maybe it's easy to miss it…


Johnny Rosenberg



 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 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 tables each have a FK to the animals
table.

What I'm envisioning is a report that lists the fields for the animal,
followed by an indented section showing a row for each medical care event,
and another indented section showing adoptions for each animal.

A query could potentially use a join to create individual rows composed of
data from multiple tables, but that is really only practical for 1-1
relationships, or possibly 1-verysmallinteger relationships.

If you still think this can work, could you explain how this would be done?


On Wed, May 15, 2013 at 2:27 AM, Alexander Thurgood alex.thurg...@gmail.com
 wrote:

 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 also included (indented and formatted properly)?
 

 Perhaps I'm misunderstanding here, but surely using a Query or a View
 which pulls in the data from your 1-to-N tables, grouped as you want
 them, as the basis for your report, would suffice ?


 Alex


 --
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 tomdavie...@yahoo.co.uk wrote:

 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 davidmichaelk...@gmail.com
 *To:* users@global.libreoffice.org
 *Sent:* Wednesday, 15 May 2013, 4:42
 *Subject:* [libreoffice-users] Possible to write reports with
 relationship data?

 All the report tutorials I've seen seem somewhat primitive, in terms of
 what kinds of structures can be printed.

 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 also included (indented and formatted properly)?

 --
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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, but so far I didn't, for some reason… Maybe I should
 finally do it.


 Ah! For an older laptop you might be best off not going for a desktop with
 hotrod graphic effects at all. Install XFCE, or Lubuntu,

 I hate both of them, so no, I won't do that mistake again. And my
 laptop is not THAT old… And it worked perfectly with Ubuntu 10.10 with
 desktop effects on (those I think I need, I didn't try all of them at
 once…). I even had a lot of swimming fish inside the cube without any
 problems… (that's not one of the effects I usually use though, I was
 just testing). But since Ubuntu 12.04 (I went directly from 10.10 to
 12.04 with a fresh install, only keeping my old home partition)I found
 a lot of problems with Compiz, that I didn't experience previously.

 which is what I did
 for an older (10 years old) Thinkpad. It works reasonably well. In the
 long run, a desktop that you can modify cheaply is best on a limited
 budget, from my perspective. The laptop is good enough to run Thunderbird
 and Firefox (but not at once!) which suits me as I am rarely on the road
 anymore. :) Ric

 I don't run Firefox nor Thunderbird, so I don't know much about that.
 Okay, I run Firefox maybe once a week or so, but still…


 Johnny Rosenberg

I experimented a little and now I don't have any ”artifacts” anymore.
Yet… There are other problems now, though, but nothing as serious as
before, I think… I'll try this for a while and see what more I find…

I edited the nVidia settings a bit. After opening the nVidia X Server
Settings i checked X Screen 0 → Antialiasing Settings → ☒ Enable FXAA.
So far no ”artifacts”, but sometimes when I do Ctrl+Alt, windows
disappears and when they reappear they are empty (white). A click on
Maximize/Reset takes care of that, though…

I'll try the older driver (173) another day to see what happens.


Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 Windows 7.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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?

For iterative insertions of grouped data into a Writer document, the
mailmerge tool is often (ab)used :-) as the tool does this automatically
(well, it does, when it is working, which is LO version dependent ;-)).

If you base your mailmerge on a query (e.g. via a join) that fetches all
of your treatment entries for a given animal via the FK and orders them,
e.g. by date, then that should work.

What I haven't tried, is getting the results from two separate queries
into one single Writer documents, but in theory, this should work too. I
have been told, but again, not tried, that sections in documents can be
used to hold different queries, but I'm not sure whether the mailmerge
function would still work properly with this approach.


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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?
 



This might give you an idea of the current situation :

http://forum.openoffice.org/en/forum/viewtopic.php?f=42t=36644p=168121hilit=two+queries+in+one+writer+document#p168121


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 query results at different places in a
single Writer (or Calc) document. My previous attempts over the years
all failed.

Ultimately, you might get further by using pyuno to create and
manipulate a Writer document, and insert the bits of data you want into
it. Again, the documentation here on how to engage in such an exercise
is sparse.


Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 Format menu 
is grayed out.  Other advice is to save the file in .odt format and 
then open the result.  That doesn't work either.

Attached to this email is a very short document (in .odt format)
exhibiting the problem.  It's just one line of text saying:

Normal (9) Normal again.

The (9) region shows up in gray and can't be edited.  Can anybody 
help?

Thanks,

Alan Stern

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 Stern st...@rowland.harvard.eduwrote:

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 Format menu
 is grayed out.  Other advice is to save the file in .odt format and
 then open the result.  That doesn't work either.

 Attached to this email is a very short document (in .odt format)
 exhibiting the problem.  It's just one line of text saying:

 Normal (9) Normal again.

 The (9) region shows up in gray and can't be edited.  Can anybody
 help?

 Thanks,
 Alan Stern



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Case function equivalent in Calc

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 that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:


Phone Email Mail - Phone;Email;Mail
Phone  Mail - Phone;Mail
   Mail - Mail
  EmailMail - Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.

I hope that makes sense and displays correctly.

Carl
--

Carl Paulsen


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 doesn't work here; the Sections line in the Format menu 
 is grayed out.  Other advice is to save the file in .odt format and 
 then open the result.  That doesn't work either.
 
 Attached to this email is a very short document (in .odt format)
 exhibiting the problem.  It's just one line of text saying:
 
   Normal (9) Normal again.
 
 The (9) region shows up in gray and can't be edited.  Can anybody 
 help?

Evidently this mailing list doesn't like attachments.  I have stored
the demo document at:

http://www.rowland.harvard.edu/~stern/readonly-demo.odt

Alan Stern


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 edited.

I'm not sure what you mean.  The document can be edited just fine.  
Only some of the regions within it are readonly.

Alan Stern


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 a record
is updated, I want the ListBox to requery.

 


In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

 


How do I get a Form to requery in LibreOffice?

  

Steven,
I am not sure I understand your question, so I may be offbase here (no 
pun intended).


What you call requerying sounds like it may be the same as Refreshing in 
Base Forms.  Have you tried the Refresh icon(s)?
At the bottom of my forms, just about in the middle of the top toolbar, 
there are two refresh icons.  The left one looks like a rotating arrow 
and has a Refresh help popup.  The icon to the right of that icon 
looks like a radio button and a rectangle with two rotating arrows, 
one out of the radio button and one into the button.  This icon has a 
help popup of Refresh Control.


Whenever I change a table that a listbox is referring to, that change 
does not immediately get reflected in my form's listbox entries.  I must 
click on the listbox (not the pulldown list, just highlight the listbox 
control itself), then click on the Refresh Control icon.  Then the 
listbox should update.  Clicking on the Refresh icon will refresh 
(reload?) the entire database and restart you back to record #1 again, 
as if you reopened the form.  Refresh Control will just refresh the 
control that is selected.


Hope this helps.
Girvin Herr


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 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 that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:


Phone Email Mail - Phone;Email;Mail
Phone  Mail - Phone;Mail
   Mail - Mail
  EmailMail - Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.

I hope that makes sense and displays correctly.

Carl


--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 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 that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:


Phone Email Mail - Phone;Email;Mail
Phone  Mail - Phone;Mail
   Mail - Mail
  EmailMail - Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.

I hope that makes sense and displays correctly.

Carl



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 it's a feature that you want I would recommend reporting a bug and
marking it as an enhancement request:
http://wiki.documentfoundation.org/BugReport

Maybe just rephrasing the question and making a new thread where you say
how do I might get some good responses from people who use Database
often.

Best Wishes,
Joel
QA Team Member

On Wed, May 15, 2013 at 1:12 PM, Girvin R. Herr
girvin.h...@sbcglobal.netwrote:

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 a
record
is updated, I want the ListBox to requery.

In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

How do I get a Form to requery in LibreOffice?

Steven,
I am not sure I understand your question, so I may be offbase here (no pun
intended).

What you call requerying sounds like it may be the same as Refreshing in
Base Forms. Have you tried the Refresh icon(s)?
At the bottom of my forms, just about in the middle of the top toolbar,
there are two refresh icons. The left one looks like a rotating arrow and
has a Refresh help popup. The icon to the right of that icon looks like
a radio button and a rectangle with two rotating arrows, one out of the
radio button and one into the button. This icon has a help popup of
Refresh Control.

Whenever I change a table that a listbox is referring to, that change does
not immediately get reflected in my form's listbox entries. I must click
on the listbox (not the pulldown list, just highlight the listbox control
itself), then click on the Refresh Control icon. Then the listbox should
update. Clicking on the Refresh icon will refresh (reload?) the entire
database and restart you back to record #1 again, as if you reopened the
form. Refresh Control will just refresh the control that is selected.

Hope this helps.
Girvin Herr

--
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

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, then do that, if 
the next thing is true, do that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:


Phone Email Mail - Phone;Email;Mail
Phone  Mail - Phone;Mail
   Mail - Mail
  EmailMail - Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.

I hope that makes sense and displays correctly.

Carl
 I just checked the available functions in Calc. The Case 
function does not appear among them. Case When is available in Base 
database queries though.


--Dan

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 based on a SQL query.  When a record
is updated, I want the ListBox to requery.

  


In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

  


How do I get a Form to requery in LibreOffice?
 It depends upon how you design the form and what information is 
contained in the listbox and the records.
 I have a form that contains a table. I also have a couple queries 
based upon the contents of that table. When I change the contents and 
refresh the table, the queries automatically refresh as well. For the 
queries, I use a table control rather than a control with a listbox.


--Dan


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

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 idea is that I put together U3, a semicolon if U3 isn't empty (and 
nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a 
semicolon if W3 isn't empty, and X3.  If any of the cells is empty, 
nothing will be added until the next cell that has data.


Unfortunately, I'm getting a #NAME? error.  I'm assuming some kind of 
syntax error.  Any words of wisdom?


Thanks a ton all.
Carl



On 5/15/13 5:13 PM, Dan Lewis wrote:

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, then do that, 
if the next thing is true, do that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two 
semi-colons consecutively.  Like:


Phone Email Mail - Phone;Email;Mail
Phone  Mail - Phone;Mail
   Mail - Mail
  EmailMail - Email;Mail

So semi-colons only occur if there's a value present and not at all 
if there's only one value present.

I hope that makes sense and displays correctly.

Carl
 I just checked the available functions in Calc. The Case 
function does not appear among them. Case When is available in Base 
database queries though.


--Dan




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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 related to documentation of LO.


Cheers


On 05/16/2013 06:42 AM, susan zarrett wrote:
Hi, I'm new to LibreOffice.  I can't figure out how to show a list of 
all documents and not just the 10 shown.  Please help.  Thanks, Susan 
Zarrett





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 - attachments are not allowed on this list  ;-)



On Wed, May 15, 2013 at 3:13 PM, Alan Stern st...@rowland.harvard.eduwrote:

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 doesn't work here; the Sections line in the Format menu
  is grayed out.  Other advice is to save the file in .odt format and
  then open the result.  That doesn't work either.
 
  Attached to this email is a very short document (in .odt format)
  exhibiting the problem.  It's just one line of text saying:
 
Normal (9) Normal again.
 
  The (9) region shows up in gray and can't be edited.  Can anybody
  help?

 Evidently this mailing list doesn't like attachments.  I have stored
 the demo document at:

 http://www.rowland.harvard.edu/~stern/readonly-demo.odt

 Alan Stern



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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