Re: [libreoffice-users] Re: booklet printing problem

2013-03-31 Thread John Talbut
On 31/03/13 11:33, Jeff Shrowder wrote:
 On 03/29/2013 09:24 PM, Marc Paré wrote:
 Le 29/03/13 05:11 AM, Jeff Shrowder a écrit :

 Marc,

 Thank you for your persistence. Unfortunately, having tried your
 suggestion above, I don't think we are any further advanced :-( Perhaps
 one minor difference is that the landscape printing is now flush with
 the left margin rather than centred on the portrait page.

 Let me know the name of the file that you would like examine and I can
 send it to you.


 Regards,

 Jeff


 Just one of your booklet files will suffice. Is this behaviour the
 same for all of
 your booklets? If so, then it is probably of no use to test-try any of
 them. I
 thought that the problem was with only one file in particular.

 Just send me any file, and I will check to see if there is a problem
 on my system.

 Could you also let us know specifically on which system you are
 working on?

 OS and version:
 LibreOffice version:
 Printer name and model:

 Perhaps someone else with the same model could chime in and test-try
 one of your
 files to see if they get the same results.

 Cheers,

 Marc

 
 Marc and all who have offered assistance in this saga, I am admitting
 defeat :-(
 
 At one stage late in my struggles I thought I saw a glimmer of hope - I
 printed an A4 landscape page of text. However, the inability to
 successfully print an A5 booklet on A4 landscape remained.
 
 Having expended way more time, anxiety, frustration, paper, toner and
 energy than any normal person would I have reluctantly removed
 LibreOffice 4.0.1.2 and installed ver 3.4.5, the stable version in the
 Scientific Linux repository. Whatever else it may or may not do it is
 printing booklets successfully.
 
 I remain committed to LibreOffice and regret that I could neither crack
 the problem or offer enough useful information for other willing helpers
 to find a solution.
 
 Cheers,
 
 Jeff
 
Jeff

I think you are trying to do something that I do regularly, print a
booklet consisting of A5 portrait pages on A4 landscape paper.  A quick
look through this thread does not seem to have given you the answer.

Your booklet needs to be formatted in writer on A5 portrait pages.
Then, these are my instruction to myself:

Paper size A4
Landscape
Duplex short edge
printer options, brochure

Works for me.

John

-- 
For unsubscribe instructions e-mail to: users+h...@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] Hidden field in bibliography

2013-02-21 Thread John Talbut

Hello,

I am finding my way around using the bibliography facility in writer and 
I am coming across one or two issues. Here is one.


In the bibliography index/table it is necessary to have a “Type” 
allocated to each entry in order that the correct format can be applied 
for the entry in the bibliography. For example a book entry would have 
different items in it from a Book excerpt or a Journal entry. There is a 
“Type” field in the bibliography database but entering anything in this 
field, either in the external database or via Tools  Bibliography 
Database has no effect on the entry format. Also, in the form opened by 
Tools  Bibliography Database there is no entry box after “Type”.


It seems that the only way to enter a Type is to go to a reference to 
the item in the document text, right click on it, click on Bibliography 
Entry, an Edit Bibliography Entry dialogue comes up, click on Edit and a 
Define Bibliography Entry dialogue come up in which the Type can be 
selected from a drop down list. Click OK and click modify. If you have 
changed anything it asks if you want to alter the existing record.


Can anyone explain this behaviour? In particular, where is this latter 
Type data stored? Why can’t the Type data in the database be used for 
this purpose?


John

--
For unsubscribe instructions e-mail to: users+h...@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: Does Libre Office have its own distinct set of fonts?

2013-02-21 Thread John Talbut

On 21/02/13 19:07, Paddy Landau wrote:

jowyta wrote

Webdings is a M$ font, see:
https://en.wikipedia.org/wiki/Webdings
and is not Unicode.


Yes, the font is not Unicode; the font is merely the way to display a
character. The character is Ò (Unicode D2), but the Webdings font displays
it as an aeroplane rather than as a capital O with an accent on top.

The Webdings font is installed on my machine.

Unfortunately, this doesn't answer the question; why is Libre Office using
the wrong character for the font?


I think it is a question of what you define as wrong.  LibreOffice 
uses Unicode and will correctly display Unicode characters in any font 
that includes the character.


The allocation of character codes to Webdings does not seem to be 
consistent and I have been unable to find an authoritative list.  I have 
Webdings installed (it comes with ttf-mscorefonts via Debian).  In my 
case the Ò character also displays as an inbox tray character using 
Webdings, the Webding aeroplane character code does not seem to display 
anything in other fonts.


So I think the answer to this question is that what LibreOffice displays 
depends on which Webdings font you have installed on your machine.  The 
font is not part of LibreOffice.


I think the answer to solving the discrepancy is to stick to Unicode 
fonts which should be consistent across all systems.


--
For unsubscribe instructions e-mail to: users+h...@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] Tell me it's not true

2012-02-28 Thread John Talbut
This is a very old bug with lots of people urgently wanting something 
done about it:


https://issues.apache.org/ooo/show_bug.cgi?id=42464


--
For unsubscribe instructions e-mail to: users+h...@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 slowness and Java update

2011-10-17 Thread John Talbut

On 14/10/11 12:39, Andreas Säger wrote:

According to Base developer Ocke Janssen, it is a Java problem and he
filed an issue:

http://comments.gmane.org/gmane.comp.openoffice.dba.user/7893


Ocke Janssen wrote in:

http://openoffice.org/bugzilla/show_bug.cgi?id=117203



I did some performance tests and the problem seems to be in
java.net.PlainSocketimpl.socketAccept It tooks double to 10 times
longer as
before in update 22.

Thanks for that information, Andreas.  The issue appears to have been 
filed as a Java bug in March:

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7024514

So if we want this fixed I think we need to support/encourage (vote for 
the issue)/assist the OpenJDK developers to fix it.


John

--
For unsubscribe instructions e-mail to: users+h...@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] Base slowness and Java update

2011-10-14 Thread John Talbut

On 14/10/11 12:18, Mark Stanton wrote:

I think you will find that most of the industry, and nearly all of
the open source community will be very unlikely to believe what
Oracle says on this subject.  It would be wise to consider that they
may have a point.


All the more reason for us to do as much of the troubleshooting as we
can!  My guess is that it is not anything big, maybe a regression since
this seems to have happened before, and if we can pinpoint it, it should
not be too difficult to fix it or get someone at OpenJDK to do so.

On 14/10/11 12:41, Ferry Toth wrote:

All this is true, but you might want to consider if you really want
to use the built-in HSQLDB database for serious stuff. It is all
java, which will never be really fast. Even with the java issues
solved.

Well, it depends what you call serious.  I am sure that people with 
really big databases will use separate applications anyway.  For my 
purposes, with around 2000 records, base was perfectly adequate in terms 
of speed until OpenJDK-6b23.


Whether or not base moves away from HSQLDB in the future, in the mean 
time I think we need to get this one fixed and get base running as well 
as we can.


John

--
For unsubscribe instructions e-mail to: users+h...@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] Base - using external database tables

2011-10-13 Thread John Talbut

Hi

OK, let me go back to square 1.

First of all I am not talking about a situation in which LibreOffice 
base needs to access data tables in separate files that use different 
database structures, e.g. one table is in MySQL and another is in 
PostgreSQL.  This may be something that others need and I seem to recall 
that M$ access could do this but I do not need to.


Next, terminology because database can mean a number of things. 
Please correct me if I am wrong here.  The data are contained in tables. 
These can be simple tables such as CSV tables or more complex tables 
constructed according to the rules of a particular database application. 
 These tables can be in separate files or they may be embedded along 
with other information.


Then there are such things as queries, forms, reports and configurations 
which could, I guess, be each in separate files but are normally saved 
embedded together or with, say a data table.  The results of running 
these, if saved, will be data tables or reports in separate files.


Finally there is the database application which may be in one or many files.

Now, to my situation.  First of all I am using Debian GNU/Linux testing 
distribution.  I use LibreOffice and for my database needs I use base. 
I use the built in HSQLDB database application and have my data tables 
embedded in the .odb file.


This has worked adequately (clunkily I would say, but I will keep other 
difficulties out of this discussion).  However, base has recently become 
unusably slow in response to something that has changed in openjdk (I 
have asked about this elsewhere).


This has prompted me to revisit the question of whether to separate out 
my data tables.  I am wondering whether it might be a workaround for the 
slowness problem.  Also there may be advantages in backing up data 
separately and having it less vulnerable to anything going wrong in 
LibreOffice.


My data consist of a list of names, addresses etc. in one table and then 
some other tables that have additional information that only applies to 
(overlapping) subsets of the people in the names etc. table.


Way back in the past I used M$ access to handle these data.  At that 
time my data tables were each in a separate file and everything worked 
very well.


When I moved over to OpenOffice.org I found that this was no longer 
possible.  In order to run queries using data from different tables (all 
using the same database structure) I found I needed to embed all the 
tables into the same .odb files.


So my question is, is this still the same in LibreOffice?

More specifically, is it possible only using base, i.e. without running 
a separate database application, to access, run queries across and 
manipulate the data in data tables contained in separate files?  I am 
assuming the these would probably be HSQLDB data tables.


If not, would it be possible if the data tables were embedded in the 
same file?


If either of these are possible then some pointers to how to separate 
out the data tables would be helpful.


Kind regards

John


--
For unsubscribe instructions e-mail to: users+h...@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 - using external database tables

2011-10-13 Thread John Talbut

Hi Alex

Thanks for your response.

On 13/10/11 09:19, Alexander Thurgood wrote:

Le 13/10/11 08:14, John Talbut a écrit :


This has worked adequately (clunkily I would say, but I will keep other
difficulties out of this discussion).  However, base has recently become
unusably slow in response to something that has changed in openjdk (I
have asked about this elsewhere).


This is your problem. It is not LibreOffice/OpenOffice.org, but the JDK
version which is causing the problem. Furthermore, it is not even the
first time that such a change has caused the very same issue of poor
performance. So if anyone is to blame, it is Oracle. The solution is to
go back to version JDK1.6u22, u21 or even u20. The way to do this has
already been posted in this list and will be in the mailing list archives.

I am aware of this.  I am not really interested in who is to blame, it 
needs sorting for current versions of JDK.  If you or anyone has any 
idea what the change is in JDK that has led to this problem please 
answer at http://lists.freedesktop.org/mailman/listinfo/libreoffice 
where I have asked this specific question.


I honestly don't think that separating out your tables will make any
difference, especially if you have a large number of fields or even only
a moderate number of records(tuples) in your table - performance will be
hit nonetheless with the most current version of the JDK (u24 I believe).

OK, that is useful to know, and there are other reasons for keeping the 
data separate from the .odb file.


John

--
For unsubscribe instructions e-mail to: users+h...@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] Base slowness and Java update

2011-10-13 Thread John Talbut

Hi Tom

On 14/10/11 02:56, you wrote:


The OpenJDK website mentions Oracle a bit
http://openjdk.java.net/faq/
About 2nd or 3rd main sub-heading is Oracle's plans for OpenJDK.

That page mentions Oracle quite a lot!  However, they make a very clear 
commitment to open source and to welcoming outside involvement:


If I don't work for Oracle, can I participate in OpenJDK?

Of course, we'd be happy to have you join! You can participate under the 
same conditions as other contributors. See http://openjdk.org/contribute 
for details.


So, let's take them at their word.

However, before we can ask them to sort out this slowness bug we need, 
it seems to me, to be able to tell them what the bug is.  Which is why I 
am trying to find out what it is about OpenJDK, which change, is causing 
the problem with base.


John

--
For unsubscribe instructions e-mail to: users+h...@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