[libreoffice-users] Re: Headless mode examples for socket and pipe methods.

2012-02-29 Thread Andreas Säger

http://code.google.com/p/jodconverter/


--
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: Headless mode examples for socket and pipe methods.

2012-02-29 Thread Harry Simons

Looks, like you want me to read the code which I was trying to very much avoid.

It is still not clear from the soffice --help or from the various posts that I 
have combed so far if it is or is not possible to specify a connection string to 
a headless listening soffice server. I mean, does one have to write a client 
program (or use a client such as jodconverter) just to be able to specify a 
connection string to connect to headless soffice server?


I would greatly, /greatly/ appreciate if someone would be kind enough to tell me 
just this much with an example. This solution introduces a Java dependency 
(which I would like to avoid as much as possible unless there is really no other 
alternative).


The DocumentConverter.py flavor that comes with jodconverter is taking so many 
seconds that I'm doubting if its really using the listening soffice server or 
spawning a new one. Again, to verify this I'd have to do more testing and look 
into the source code.


So, please, asking one last time for a simple and direct answer if you can. A 
pipe example would also be appreciated.


In summary, I'd like to know
1) how to use just soffice (i.e., without any other external software like 
jodconverter, unoconv, etc) to efficiently convert a large number of ms office 
files to plain text.
2) I'd like to use the headless soffice so that it's not restarted for every 
input file type, and

3) I'd also like to know how to use both socket and the pipe method.

I wish the soffice --help option came with a simple 1 line examples of each. :-( 
But if not, then at least on this forum I can get my answers instead of reading 
the source code of these various tools.


On 02/29/2012 02:02 PM, Andreas Säger wrote:

http://code.google.com/p/jodconverter/




--
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: increase testing to improve quality

2012-02-29 Thread e-letter
On 29/02/2012, NoOp gl...@sbcglobal.net wrote:
 There is a web page which describes manual testing:
 http://wiki.documentfoundation.org/QA/Testing/Manual_Tests. Clearly,
 there are insufficient testers...

 Clearly:
 quote
 IMPORTANT: Obsoleted by Litmus

 Litmus is a useful tool for organizing manual tests. Please, help us to
 migrate all these test cases there and remove them from this wiki page.
 /quote

 So why even point 'users' to that page?


The initial purpose is to promote the existence of QA testing, both in
terms of the history (the wiki) and the future (litmus).



 Cool. Have you *actually* installed 3.5.1rc1 (as noted in the litmus test)?
 Description:  Test run for *3.5.1 RC* regression testing. Please use
 *3.5.1 RC* build to test the cases in this run.


No, there are no new features of personal interest.

 If you did (and you'd need to find it someplace other than:
 http://www.libreoffice.org/download/pre-releases/ and (currently) only
 on http://dev-builds.libreoffice.org/daily/
 you'd find that the install (at least on a debian linux system) smokes
 your existing 3.5.0 install (remember 3.5.0 is the released version).


I don't fully understand, but perhaps this is a serious bug?

 So, while I (we?) appreciate your efforts to get users on this user
 list as pre-release testers, I'd be overly cautious about asking users
 on this list to perform litmus tests... At least not without explaining
 in *detail* what is required, and how to avoid existing LO standard
 installations being blown away by a pre-release version.


That is valid and is of such high importance to be published on the
'qa' web page!

 IMO it's probably better for 'users' on this list to wait to
 test/participate when http://www.libreoffice.org/download/pre-releases/
 actually shows a pre-release version. *And* testers understand the
 implications of testing. This will avoid the LO blew up my thesis and
 wiped out all of my exisiting templates/files/settings. (Note: I'm not
 making light of those that do report such, but instead trying to avoid
 such reports here in the first place as they are *serious* issues  can
 happen if you don't understand what you are doing when you test.)


True, but surely users are sufficiently intelligent to understand not
to use alpha, beta, pre-release, release candidate, etc. on computers
containing important information such as a thesis???

Any competent tester should have a separate machine.

-- 
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] Re: Tell me it's not true

2012-02-29 Thread Alexander Thurgood
Le 29/02/12 07:43, Andreas Säger a écrit :

Hi all,

 Base is best when you ignore most of its tools and helpers relying
 entirely on your own skills and on the capabilities of the underlying
 database driver.
 
 

I wish it were otherwise, but sadly, well said.


Alex


-- 
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] Re: LibreO-Base report layout problem

2012-02-29 Thread Alexander Thurgood
Le 29/02/12 00:25, Pertti Rönnberg a écrit :

Hi Pertti,


 My intention is to
have the report's name and the column headings  page number on the
 first page (= sections 'Report Header'  'Page Header' visible)
and only column headings  page number(s) on the next pages (=
 section 'Page Header' visible)
 

I seem to recall reading somewhere, possibly in a bug report, or on
another mailing list (German ??) that this doesn't yet work as
intended...something about not being able to switch header/footer page
styles. Sorry, I can't be any more precise than that.

Alex


-- 
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: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 12:26 +0100, Alexander Thurgood wrote:
 Le 29/02/12 07:43, Andreas Säger a écrit :
 
 Hi all,
 
  Base is best when you ignore most of its tools and helpers relying
  entirely on your own skills and on the capabilities of the underlying
  database driver.
  
  
 
 I wish it were otherwise, but sadly, well said.

*laughing*...I'll be damned, I was tempted to say exactly that, pulled
it back at that last second - but yes that is about it.

Honestly - I stopped advising anyone to use Base for anything quite a
while back.

//drew
 
 
 Alex
 
 



-- 
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: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 12:45 +0100, Alexander Thurgood wrote:
 Le 29/02/12 12:40, drew jensen a écrit :
 
  *laughing*...I'll be damned, I was tempted to say exactly that, pulled
  it back at that last second - but yes that is about it.
  
  Honestly - I stopped advising anyone to use Base for anything quite a
  while back.
  
 
 :-)

Oh put our jaw back you know it's true...



 
 
 
 



-- 
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-29 Thread Mark Stanton
 Create a brand new database (relational, embedded HSQLDB).
 Drag the table icons from your dBase connection into the new database.

Doing this now.  It lets me select all tables, but when I drag then it 
only brings over one :-(

And HSQL seems to require index names to be unique at the database level 
not the table level, is that right?

Mark Stanton
One small step for mankind...



-- 
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-29 Thread Mark Stanton
 perhaps able to include some aspects of the
 spreadsheet paradigm to data manipulation.

That's an interesting thought.
What sorts of aspects do you have in mind?

Mark Stanton



-- 
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: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 13:36 +, e-letter wrote:
 On 29/02/2012, Andreas Säger ville...@t-online.de wrote:
 
  Almost nothing has changed since then, except for fixing things that
  should have been working right from the start 9 years ago.
  The Base developers wasted too much time with useless wizards covering
  no more than 30% of the program's capabilities and with a self
  contained database document that is a caricature of a database (unsafe,
  unsecure, low featured and slow).
  Base is best when you ignore most of its tools and helpers relying
  entirely on your own skills and on the capabilities of the underlying
  database driver.
 
 
 Interesting; suggests that base exists just to answer the question by
 m$ fans: where is the equivalent to acce$$?

well, think what you want...though I will say this - one of the root
causes of Base's woes can be tied IMO to the first sentence in the
original design specification, to paraphrase from it ...because users
are too stupid to.. 

Starting from the premise that users are stupid it is not surprising
that Base ended up the way it did. 

xoxo,

//drew



-- 
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] LO 3.5 Templates

2012-02-29 Thread Tom Davies
Hi :)
It might be worth renaming your User Profile
https://wiki.documentfoundation.org/Documentation/UserProfile
It would be great to save a copy somewhere safe and far away from where LO will 
look for it, perhaps in your My Documents folder.  

Hopefully the 3.4 will start up just fine after that but you will need to 
copy-back the templates and maybe a few other things from your old UserProfile 
to the new one that automatically gets generated.  

If that hasn't worked try fully uninstalling LibreOffice again, reboot 
(especially if using Windows) and then re-install the 3.4.5.  Again you will 
need to copy the templates and stuff back from the copy you made into the new 
one that got generated in the previous paragraph.  

Regards from
Tom :)



--- On Wed, 29/2/12, Keith Bates ke...@new-life.org.au wrote:

From: Keith Bates ke...@new-life.org.au
Subject: [libreoffice-users] LO 3.5 Templates
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 1:09

I made a big mistake this morning.

I upgraded to 3.5- I'm using Ubuntu 11.10. Installed from the libreoffice ppa

I discovered early that it won't print multiple copies.

I tried to revert to 3.4 by removing 3.4 and re-installing. It wouldn't start 
up.

Now I find that I can't use templates. There is not even a templates folder in 
the organize templates module.

The templates exist but just can't be used.

If I try to use a template I get an error message templates already exists. 
If I try to open them as documents and save them as templates I get another 
similar error about them already existing- no option to overwrite.

Has anyone come across any of this insanity?

-- God bless you
Keith Bates
Narrabri NSW

Jesus is the Way
the Truth and the Life


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


-- 
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] Re: Parameterised query

2012-02-29 Thread Mark Stanton
B*m! :-(

Fixed it.  Wrong SQL mode selected, it seems.  Sorry.

Mark Stanton
One small step for mankind...



-- 
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-29 Thread Mark Stanton
 Yes - It's one at a time.

Hmm, a shame but plausible.


  And HSQL seems to require index names to be unique at the database level 
  not the table level, is that right?
 
 Yes.

Isn't that a little... Non-standard?

Mark Stanton
One small step for mankind...



-- 
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-29 Thread drew jensen
On Wed, 2012-02-29 at 15:12 +, Mark Stanton wrote:
  Yes - It's one at a time.
 
 Hmm, a shame but plausible.
 
 
   And HSQL seems to require index names to be unique at the database level 
   not the table level, is that right?
  
  Yes.
 
 Isn't that a little... Non-standard?

Not really...Also, normally one would allow the tool to generate unique
index names - for example creating a FK relation will automatically
create required indexes, adding a PK to a table also.

And sorry if this is off track - but I just want to be sure that you are
referring to index names and not column names used for FK relationships.
Column names, even used in a FK are table specific not database (or
schema) specific.

So I can have 
Table1 (t1PK, data1, data2)

Table2 (t2PK, data1, data2, t1PK) 

Table2.t1PK will be indexed for a FK back to table1, the index created
will have unique name, but you need not create it, the create FK
statement will do so for you.

//drew


 
 Mark Stanton
 One small step for mankind...
 
 
 



-- 
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] Parameterised query

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 15:06 +, Mark Stanton wrote:
 Hi,
 
 Taking advice here and the French FAQ on the Wiki (now translated :-) 
 ), I see how to use parameters in a query.
 
 I have a query in my database that's linked to a MySQL database and 
 it just complains The data content could not be loaded.  No value 
 specified for parameter 1 with the query
 
 SELECT  Several fields
 FROMa table
 JOINfive other tables
 WHERE issues.Issue = ?Isssue_Num AND sent.sent = 1
 AND textvalues.Field = 'CBOSUBTYPE' 
 ORDER BYFirstName, Surname
 
 I have tried the :Parameter form, which doesn't work either.
 It works perfectly well if I give a value instead of ?Issue_Num.

hmm, well one problem is that the correct syntax is

:Issue_Num

NOT ?Issue_Num

Make that change and you should be good to go.

//drew

 
 Any suggestions why this doesn't work?
 This is LO 3.4.5, whose Base component is presumably almost exactly 
 the same as 3.5.
 
 Mark Stanton
 One small step for mankind...
 
 
 



-- 
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] Re: Tell me it's not true

2012-02-29 Thread Andreas Säger

Am 29.02.2012 16:06, Mark Stanton wrote:

perhaps able to include some aspects of the
spreadsheet paradigm to data manipulation.


That's an interesting thought.
What sorts of aspects do you have in mind?

Mark Stanton





A database component without databases would be as interesting as a 
spreadsheet without references.



--
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] Parameterised query

2012-02-29 Thread Fernand Vanrie

On 29/02/2012 16:06, Mark Stanton wrote:

Hi,

Taking advice here and the French FAQ on the Wiki (now translated :-)
), I see how to use parameters in a query.

I have a query in my database that's linked to a MySQL database and
it just complains The data content could not be loaded.  No value
specified for parameter 1 with the query

SELECTSeveral fields
FROMa table
JOINfive other tables
WHERE issues.Issue = ?Isssue_Num AND sent.sent = 1
 AND textvalues.Field = 'CBOSUBTYPE'
ORDER BYFirstName, Surname

I have tried the :Parameter form, which doesn't work either.
It works perfectly well if I give a value instead of ?Issue_Num.

Any suggestions why this doesn't work?

a typo in

?Isssue_Num (3s) ?
 greetz
Fernand


This is LO 3.4.5, whose Base component is presumably almost exactly
the same as 3.5.

Mark Stanton
One small step for mankind...






--
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] Specialized dictionary

2012-02-29 Thread webmaster for Kracked Press Productions

On 02/28/2012 12:38 PM, Libre User wrote:

I have a project to make display labels for a mineral museum.

Does anyone know of a source for a specialized dictionary of mineral 
and chemical names that can be used with LO?


Jerry 


Minerals?  Well, maybe in the larger ones, but English Chemistry - try 
this one.


http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/Chemistry_Dictionary__technical_chemistry_words--ChemDictOOo2011-01-07.oxt

--
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] How to use GTK open dialog box in LibreOffice

2012-02-29 Thread Mirosław Zalewski
On 29/02/2012 at 08:33, Arnaud Champollion arnaud.champoll...@laposte.net 
wrote:

  If you would like to force GTK everytime, try adding:
  
  export OOO_FORCE_DESKTOP=gnome
  
  into your ~/.bashrc
 
 Doesn't work, even after restarting the session.
 
  or ~/.profile
 
 Doesn't work either.

You are using Debian, right? Which version (you can check in file 
/etc/debian_version)? How did you install MATE? It hasn't made it into official 
Debian repository yet.

Do you know what login manager you are using? Could you post it's name? 
If you don't know, can you post output of command:
  dpkg -l
on the web somewhere? http://pastebin.com/ or similar page sounds good.

It may be few thousand lines long. You can use command:
  dpkg -l  installed-list.txt
to write it into installed-list.txt file in your working directory.

Output of:
  echo $SHELL
in command line/terminal may be useful, too.

Answering these questions may help me narrowing down the problem and come up 
with some solutions for you.

As for Warning that you are getting: gnome-keyring is GNOME app to securely 
store passwords in a session (i.e. between logging in and logging out). 
I *think* that you can ignore that -- it's not that LO will ask you for 
password anyway (unless you are writing/reading password-protected documents, 
but I am pretty sure that LO does not need gnome-keyring for that).
-- 
Best regards
Mirosław Zalewski

-- 
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: Tell me it's not true

2012-02-29 Thread Dan Lewis
On Wed, 2012-02-29 at 10:01 -0500, drew jensen wrote:
 On Wed, 2012-02-29 at 13:36 +, e-letter wrote:
  On 29/02/2012, Andreas Säger ville...@t-online.de wrote:
  
   Almost nothing has changed since then, except for fixing things that
   should have been working right from the start 9 years ago.
   The Base developers wasted too much time with useless wizards covering
   no more than 30% of the program's capabilities and with a self
   contained database document that is a caricature of a database (unsafe,
   unsecure, low featured and slow).
   Base is best when you ignore most of its tools and helpers relying
   entirely on your own skills and on the capabilities of the underlying
   database driver.
  
  
  Interesting; suggests that base exists just to answer the question by
  m$ fans: where is the equivalent to acce$$?
 
 well, think what you want...though I will say this - one of the root
 causes of Base's woes can be tied IMO to the first sentence in the
 original design specification, to paraphrase from it ...because users
 are too stupid to.. 
 
 Starting from the premise that users are stupid it is not surprising
 that Base ended up the way it did. 
 
 xoxo,
 
 //drew
 

 This thread for the most part is exactly what should not be part of
this mailing list. The attitudes are horrible with very little said in a
positive way. Yes, why have Base? Why have a Base Guide? The person who
wrote a suggested outline for the Base Guide is among this group. With
this attitude, how could the outline be what it should be? Does it
suffer the same attitude problem? Besides, what purpose would it serve
given the comments about Base?
 What would most people who are new to Base think after reading the
negative comments about Base? Statements about how hard it is to learn
(comparing learning at least some of it to the difficulty of learning a
new language). No one seems to be able to give references that would
help. (No one has so far.)
 Recently there was a long thread that began with a problem with a
large spreadsheet. One of the early comments was that the data should
have been in a database. Now, it appears that that comment should have
been: you should be using a database but don't use Base. Strange very
little help was give as to how Calc could be used. So, it sounds like to
me that the advice seems to be: limit your use of Calc and DON'T USE
Base.
 OK, I have had my say. I will likely delete any replies that come
from this thread because I have seen people justify their actions in the
past threads. This is suppose to be a list to help others, and their
comments are not likely to do that. Besides, any replies to me need to
consist of references for getting the most from Base. Other than help in
learning more about how to use it, I don't need.

--Dan


-- 
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] Parameterised query

2012-02-29 Thread Tom Davies
Hi :)
It is great to see the Base section of the Faq getting worked on first.  Base 
needs a lot of love from a lot of people.  
https://wiki.documentfoundation.org/Faq#Base

Good work Markers :)
Regards from
Tom :)


--- On Wed, 29/2/12, Mark Stanton m...@vowleyfarm.co.uk wrote:

From: Mark Stanton m...@vowleyfarm.co.uk
Subject: [libreoffice-users] Parameterised query
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 15:06

Hi,

Taking advice here and the French FAQ on the Wiki (now translated :-) 
), I see how to use parameters in a query.

I have a query in my database that's linked to a MySQL database and 
it just complains The data content could not be loaded.  No value 
specified for parameter 1 with the query

SELECT      Several fields
FROM        a table
JOIN        five other tables
WHERE issues.Issue = ?Isssue_Num AND sent.sent = 1
    AND textvalues.Field = 'CBOSUBTYPE' 
ORDER BY    FirstName, Surname

I have tried the :Parameter form, which doesn't work either.
It works perfectly well if I give a value instead of ?Issue_Num.

Any suggestions why this doesn't work?
This is LO 3.4.5, whose Base component is presumably almost exactly 
the same as 3.5.

Mark Stanton
One small step for mankind...



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


-- 
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] Re: Tell me it's not true

2012-02-29 Thread Andreas Säger

Am 29.02.2012 18:15, Dan Lewis wrote:

This thread for the most part is exactly what should not be part of
this mailing list.


@Mark Stanton,
Would you please visit us at 
http://user.services.openoffice.org/en/forum/index.php next time?



  What would most people who are new to Base think after reading the
negative comments about Base? Statements about how hard it is to learn
(comparing learning at least some of it to the difficulty of learning a
new language). No one seems to be able to give references that would
help. (No one has so far.)


You should read what people think after trying to work with Base in a 
user interface that suggests something very similar to MS Access. 
Everybody working through the ungrateful topics of Base support has to 
put things straight regarding what Base is and what it's not.


Drew Jensen is the single person who deserves all merits that some 
people (including me) found their way to do very productive things with 
this office suite's database connectivity.


Actually it is easy enough to access arbitrary table data beyond file 
format issues in order to make them appear in our office documents (once 
you got used to the fact that in most cases a database document may 
not contain any database). Slightly advanced users can prepare data 
sources and queries that are easy to use by the less capable users. Your 
letter template may use some Name-Address-ZIP-City query from a MySQL 
server and then you advise the end user to use another 
Name-Address-ZIP-City query from a plain text file you created this 
morning. The end user does not notice any difference between MySQL 
server and plain text when he reconnects his letter to another data 
source item.


Building a simple database application with data flowing from the office 
suite back to some connected database takes a conception of the database 
you are going to write to. This expert knowledge is beyond the scope of 
most users and it has nothing to do with ODF documents. It takes 
extremely complex tools to assist laymen in this effort. Even the 
expensive database suites can not do that much when you are not aware of 
some theoretical concepts.


First you have a relational database ready to use, then building some 
ODF input forms to edit the relational data is no black art. The minimum 
tools are availlable in Writer, Calc, Draw, Impress. They are very 
simple and simple is not the same as easy. The design process 
involves user-ability rather than usability.


The resulting forms, reports and mail merge templates work very well for 
my users and me. My users refers to a group of rather computer 
illiterate professionals who need to write lots of info snippets into 
protocols, memos, inventories and serial letters collecting some 100 
records per day in a small business network of 6 personal computers.


If LibreOffice would drop 90% of Base, keeping the mere connectivity, 
the primitive query parser and ODF forms, we could still work with it in 
the same way as we do today. All the convenient but misleading rubbish 
built around the core functionality is obsolete.
Base should start again where OOo 2.0 left the well thought concept of 
OOo 1.x.
Wrapping portable databases in extensions rather than documents would 
solve all the data loss problems of the embedded database.

Reduce to the max!


--
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] Re: Headless mode examples for socket and pipe methods.

2012-02-29 Thread Alex Thurgood

Le 29/02/2012 07:42, Harry Simons a écrit :

Hi Harry,

You might find some hints here :

http://www.linuxjournal.com/content/starting-stopping-and-connecting-openoffice-python

http://codesnippets.services.openoffice.org/Office/Office.ConnectToListeningOpenOfficeVariant2_BSF4Rexx_.snip

http://www.codeproject.com/Articles/26555/Batch-Converting-and-Merging-Multiple-Documents-to

http://www.oooforum.org/forum/viewtopic.phtml?t=64007

http://technology.amis.nl/2006/06/getting-started-with-the-openofficeorg-api-part-i-connecting-to-openofficeorg/

http://www.openoffice.org/udk/python/python-bridge.html

http://www.openoffice.org/udk/python/python-bridge.html#binding


Alex



--
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] How to use GTK open dialog box in LibreOffice

2012-02-29 Thread Arnaud Champollion

Le 29/02/2012 17:29, Mirosław Zalewski a écrit :


You are using Debian, right? Which version


Wheezy




How did you install MATE? It hasn't made it into official
Debian repository yet.


with the following repository :

deb http://packages.mate-desktop.org/repo/debian/ wheezy main



Do you know what login manager you are using?


Lightdm (from the Debian main repository, installed with apt-get)

I had gdm, but after having a problem with gdm background (disappeared) 
I switched to Lightdm. I can try with gdm if that can help.






--
Arnaud Champollion

--
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] LO 3.5 Templates

2012-02-29 Thread Keith Bates

On 01/03/12 02:05, Tom Davies wrote:

Hi :)
It might be worth renaming your User Profile
https://wiki.documentfoundation.org/Documentation/UserProfile
It would be great to save a copy somewhere safe and far away from where LO will look for it, perhaps in your My Documents folder. 

Hopefully the 3.4 will start up just fine after that but you will need to copy-back the templates and maybe a few other things from your old UserProfile to the new one that automatically gets generated. 

If that hasn't worked try fully uninstalling LibreOffice again, reboot (especially if using Windows) and then re-install the 3.4.5.  Again you will need to copy the templates and stuff back from the copy you made into the new one that got generated in the previous paragraph. 


Regards from
Tom :)


Hi Tom,

I managed to get 3.4.4 working after several attempts at re-installing.

I don't know what the problem was with 3.5. I guess I'll just have to 
wait for a later version.


Keith



--- On Wed, 29/2/12, Keith Bateske...@new-life.org.au  wrote:

From: Keith Bateske...@new-life.org.au
Subject: [libreoffice-users] LO 3.5 Templates
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 1:09

I made a big mistake this morning.

I upgraded to 3.5- I'm using Ubuntu 11.10. Installed from the libreoffice ppa

I discovered early that it won't print multiple copies.

I tried to revert to 3.4 by removing 3.4 and re-installing. It wouldn't start 
up.

Now I find that I can't use templates. There is not even a templates folder in 
the organize templates module.

The templates exist but just can't be used.

If I try to use a template I get an error message templates already exists. 
If I try to open them as documents and save them as templates I get another similar error 
about them already existing- no option to overwrite.

Has anyone come across any of this insanity?

-- God bless you
Keith Bates
Narrabri NSW

Jesus is the Way
the Truth and the Life


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





--
God bless you
Keith Bates
Narrabri NSW

Jesus is the Way
the Truth and the Life


--
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-29 Thread Mark Stanton
Hi Drew,

 Not really...Also, normally one would allow the tool to generate unique
 index names - for example creating a FK relation will automatically
 create required indexes, adding a PK to a table also.

I'm a little surprised.  Although I've got over twenty years of database 
development experience, it is largely in FoxPro (a dBase improvement), 
although with a little of a few others. I've not seen, and certainly 
wouldn't want, an insistence on automatically named indices.


 And sorry if this is off track - but I just want to be sure that you are
 referring to index names and not column names

Yes, I'm definitely talking about index names.
I took up Andreas' idea of importing my dbase-type files into an HSQL LO 
database.  It didn't realise the tables already had primary key fields.  I 
usually call these iId (as integer ID fields), and so want an index 
(called iId) on each table. I can't do that in HSQL.

I know there's an idea that index names should include table names, which 
would completely eradicate the issue, it's just that I don't agree :-)

It's a (perhaps) interesting discussion point rather than a problem 
though.

Thanks for the info
Mark Stanton
One small step for mankind...



-- 
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-29 Thread Mark Stanton
 @Mark Stanton,
 Would you please visit us at 
 http://user.services.openoffice.org/en/forum/index.php next time?

Coo, look at that!  A busy Base forum.  

I really much prefer stuff that arrives in my mailbox, but yes, I will visit 
there.  Thanks (again) Andreas.

Mark Stanton
One small step for mankind...



-- 
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] Parameterised query

2012-02-29 Thread Mark Stanton
Hi Fernand,

 ?Isssue_Num (3s) ?
   greetz
 Fernand

Thanks, but nope.  The name Issue_Num, just identifies a parameter, it 
doesn't have to match the name of any field.

The problem was the wrong SQL mode.

Mark Stanton
One small step for mankind...



-- 
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-29 Thread Mark Stanton
 A database component without databases would be as interesting as a 
 spreadsheet without references.

That's true, but e-letter was talking about adding spreadsheet-type 
facilities, not taking away database-type ones.  In view of the 
previous thread, and general experience, suggesting that spreadsheet 
users sometimes want to make the jump to databases but find it 
difficult, I'm interested in thoughts about facilities that would help 
bridge that gap.  Particularly as I'm starting to do some Base 
development...

Cheers
Mark Stanton
One small step for mankind...



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



[Solved] Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Tom Davies
Hi :)
Congrats on fixing the problem :)  Nicely done :)
Regards from
Tom :)


--- On Wed, 29/2/12, Mark Stanton m...@vowleyfarm.co.uk wrote:

From: Mark Stanton m...@vowleyfarm.co.uk
Subject: Re: [libreoffice-users] Parameterised query
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 22:13

Hi Fernand,

 ?Isssue_Num (3s) ?
   greetz
 Fernand

Thanks, but nope.  The name Issue_Num, just identifies a parameter, it 
doesn't have to match the name of any field.

The problem was the wrong SQL mode.

Mark Stanton
One small step for mankind...



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


-- 
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: Libreoffice 3.5

2012-02-29 Thread MoolsM

On 28/02/2012 19:45, Tom wrote:

Hi :)
I think it might just be that you have to reboot your machine after an
install.  Also after an uninstall.  Remember this from the early days of Xp?
http://nabble.documentfoundation.org/file/n3785115/mouse-reboot.jpg
mouse-reboot.jpg
Not a genuine message of course but it felt about right at the time.

Instead of uninstalling perhaps try just renaming your User Profile as that
does what most people expect an uninstallreinstall to do
http://wiki.documentfoundation.org/Documentation/UserProfile


Also with Vista it has some strange permissions thing that tries to block
unwanted events from happening so perhaps it's the UAE or something blocking
the install?  Perhaps try downloading LIbreOffice 3.4.5 from the official
web-site
http://www.libreoffice.org/download/?type=win-x86lang=en-US
I got there by choosing the option
Change system, version or language - and then choose US as the language.
Good luck and regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-3-5-tp3781541p3785115.html
Sent from the Users mailing list archive at Nabble.com.


Tom,

Thanks for your advice.

I've tried various combinations of  uninstall, reboot and reinstall to 
no avail.


I can't even retreat to a previous viable version of L.O.

I've removed L.O. from my Windows laptop and re-installed MSoffice. I'm 
still happily running L.O. on my Ubuntu laptop.



--
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-29 Thread Tom Davies
Hi :)
Yes, if you want to get involved with Base then OpenOffice has far better 
routes for getting in contact with people.  TDF see Base as very very low 
priority so it refuses to give it even 1 mailing list let alone a whole forum.  
Still, it seems that here is the better place to actually get on with any work, 
such as documentation, faqs, coding or whatever area interests a person. 
Regards from
Tom :)


--- On Wed, 29/2/12, Mark Stanton m...@vowleyfarm.co.uk wrote:

From: Mark Stanton m...@vowleyfarm.co.uk
Subject: Re: [libreoffice-users] Tell me it's not true
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 22:13

 @Mark Stanton,
 Would you please visit us at 
 http://user.services.openoffice.org/en/forum/index.php next time?

Coo, look at that!  A busy Base forum.  

I really much prefer stuff that arrives in my mailbox, but yes, I will visit 
there.  Thanks (again) Andreas.

Mark Stanton
One small step for mankind...



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


-- 
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: Libreoffice 3.5

2012-02-29 Thread Tom Davies
Hi :)
Ages ago Earl Melton made this post


No, no. It's an excellent free replacement and far superior to MS' Add/Remove, 
IMO. You can download it at the link below and install just like any other app. 
After clicking the link, be careful to not choose the 30-day free trial of the 
Pro version -- you don't really need it..well, unless you're needing to put 
your wallet on a diet. :-)  Instead, scroll to the bottom of the page and click 
on the FREE download button. Works great on Win-XP and Vista. If your OS is 
otherwise, check requirements at the link before downloading. HTH!

http://www.revouninstaller.com/revo_uninstaller_free_download.html

-- 
I'm so busy, I don't know whether I found a rope or lost my horse!
  Earl 

--
 (21st June 2011)

A few other people on the lists at the time also said it was pretty awesome but 
i'm not sure if they had tried it on Vista.  They probably had as that seems to 
be the trickiest version of Windows at the moment.  
Regards from
Tom :)


--- On Wed, 29/2/12, MoolsM mools.marin...@gmail.com wrote:

From: MoolsM mools.marin...@gmail.com
Subject: Re: [libreoffice-users] Re: Libreoffice 3.5
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 22:27

On 28/02/2012 19:45, Tom wrote:
 Hi :)
 I think it might just be that you have to reboot your machine after an
 install.  Also after an uninstall.  Remember this from the early days of Xp?
 http://nabble.documentfoundation.org/file/n3785115/mouse-reboot.jpg
 mouse-reboot.jpg
 Not a genuine message of course but it felt about right at the time.

 Instead of uninstalling perhaps try just renaming your User Profile as that
 does what most people expect an uninstallreinstall to do
 http://wiki.documentfoundation.org/Documentation/UserProfile


 Also with Vista it has some strange permissions thing that tries to block
 unwanted events from happening so perhaps it's the UAE or something blocking
 the install?  Perhaps try downloading LIbreOffice 3.4.5 from the official
 web-site
 http://www.libreoffice.org/download/?type=win-x86〈=en-US
 I got there by choosing the option
 Change system, version or language - and then choose US as the language.
 Good luck and regards from
 Tom :)

 --
 View this message in context: 
 http://nabble.documentfoundation.org/Libreoffice-3-5-tp3781541p3785115.html
 Sent from the Users mailing list archive at Nabble.com.

Tom,

Thanks for your advice.

I've tried various combinations of  uninstall, reboot and reinstall to 
no avail.

I can't even retreat to a previous viable version of L.O.

I've removed L.O. from my Windows laptop and re-installed MSoffice. I'm 
still happily running L.O. on my Ubuntu laptop.


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


-- 
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] Libreoffice 3.5

2012-02-29 Thread MoolsM
On 28/02/2012 16:44, e-letter wrote:On 27/02/2012, 
MoolsMmools.marinair@gmail.comwrote:I'm currently running Windows Vista.A 
mistake...When I click on the icon I get some startup details and then a windows
message saying L.O has stopped working.


Tried a few cycles of un-install and reinstall but keep getting the same
problem.


Any thoughts?Please contact m$ and tell us your experience.A mistake...I've run 
Vista for nearly three years without any major problems apart from this. 
However in 2012, who gives a sh!t about the OS.


I didn't post this problem because I expected a simple resolution, although 
that would have been nice. 


My intention was to warn others who might have been seduced by the happy 
combination of Vista and previous versions of L.O., as indeed I was.
-- 
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] LO 3.5 Templates

2012-02-29 Thread Tom Davies
Hi :)
Congrats :)  Nicely done :)

The 3.5.0 is the first in that branch and we didn't actively ask people to get 
involved with beta-testing it early enough.  I was one of those guilty of 
telling people to stay away from it until the 3.5.1 so i'm feeling like i  
kicked myself in the leg and also am feeling quite guilty.  However the devs 
are stars so i'm sure the 3.5.1 will clear up a lot of the problems.  

If you would like to get a sneak preview of the 3.5.1 then when the 
beta-testing releases are made try installing it alongside the LO you already 
have
http://wiki.documentfoundation.org/Installing_in_parallel
or better still test on an older machine or in a virtual machine.  This allows 
you to switch back to the one you know works if you run into a problem and have 
a de4ad-line to keep.

Regards from
Tom :)  


--- On Wed, 29/2/12, Keith Bates ke...@new-life.org.au wrote:

From: Keith Bates ke...@new-life.org.au
Subject: Re: [libreoffice-users] LO 3.5 Templates
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 22:03

On 01/03/12 02:05, Tom Davies wrote:
 Hi :)
 It might be worth renaming your User Profile
 https://wiki.documentfoundation.org/Documentation/UserProfile
 It would be great to save a copy somewhere safe and far away from where LO 
 will look for it, perhaps in your My Documents folder. 

 Hopefully the 3.4 will start up just fine after that but you will need to 
 copy-back the templates and maybe a few other things from your old 
 UserProfile to the new one that automatically gets generated. 

 If that hasn't worked try fully uninstalling LibreOffice again, reboot 
 (especially if using Windows) and then re-install the 3.4.5.  Again you will 
 need to copy the templates and stuff back from the copy you made into the new 
 one that got generated in the previous paragraph. 

 Regards from
 Tom :)

Hi Tom,

I managed to get 3.4.4 working after several attempts at re-installing.

I don't know what the problem was with 3.5. I guess I'll just have to 
wait for a later version.

Keith


 --- On Wed, 29/2/12, Keith Bateske...@new-life.org.au  wrote:

 From: Keith Bateske...@new-life.org.au
 Subject: [libreoffice-users] LO 3.5 Templates
 To: users@global.libreoffice.org
 Date: Wednesday, 29 February, 2012, 1:09

 I made a big mistake this morning.

 I upgraded to 3.5- I'm using Ubuntu 11.10. Installed from the libreoffice ppa

 I discovered early that it won't print multiple copies.

 I tried to revert to 3.4 by removing 3.4 and re-installing. It wouldn't start 
 up.

 Now I find that I can't use templates. There is not even a templates folder 
 in the organize templates module.

 The templates exist but just can't be used.

 If I try to use a template I get an error message templates already exists. 
 If I try to open them as documents and save them as templates I get another 
 similar error about them already existing- no option to overwrite.

 Has anyone come across any of this insanity?

 -- God bless you
 Keith Bates
 Narrabri NSW

 Jesus is the Way
 the Truth and the Life


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




-- 
God bless you
Keith Bates
Narrabri NSW

Jesus is the Way
the Truth and the Life


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


-- 
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] Fw: [MariaDB Announce] MariaDB 5.3.5 now available!

2012-02-29 Thread Tom Davies


--- On Wed, 29/2/12, MariaDB Announce List annou...@mariadb.org wrote:

From: MariaDB Announce List annou...@mariadb.org
Subject: [MariaDB Announce] MariaDB 5.3.5 now available!
To: annou...@mariadb.org
Date: Wednesday, 29 February, 2012, 20:24

The MariaDB project is pleased to announce the immediate availability of
MariaDB 5.3.5!

MariaDB 5.3.5 is the first stable (GA) release in the 5.3 series.


--- MariaDB 5.3.5 Release Notes, Changelog, Downloads -

The release notes are available at:
  http://kb.askmonty.org/en/mariadb-535-release-notes

A changelog is available at:
  http://kb.askmonty.org/en/mariadb-535-changelog 

Sources, binaries and packages can be downloaded from:
  http://downloads.askmonty.org/mariadb/5.3.5/ 

  Debian and Ubuntu packages are available from our mirrored apt
  repositories. A sources.list generator can be found at:
    http://downloads.askmonty.org/mariadb/repositories/


--- About MariaDB 5.3 -

The MariaDB 5.3 series introduces many new features, includes MariaDB
5.2, and is based on MariaDB 5.1  MySQL 5.1. Some highlights of new
features in MariaDB 5.3 include:

- subquery optimizations that finally make subqueries usable
- many optimizer changes, including Classic Hash Join, Batched Key
  Access, a new implementation of Multi-Range-Read optimizations as
  well as Index Condition Pushdown
- NoSQL-style interfaces via the HandlerSocket plugin as well as
  dynamic columns
- group commit in XtraDB when the binary log is enabled
- Microsoft Windows performance improvements

These are just some of the highlights, and for a more complete list of
changes, please read the What is MariaDB 5.3 page:
  http://kb.askmonty.org/en/what-is-mariadb-53



--- SkySQL and MariaDB: Solutions Day -

We'll be co-hosting the the SkySQL  MariaDB: Solutions Day for the
MySQL® Database one day event on 13 April, 2012, at the Hyatt Regency
Santa Clara. 

During this event, attendees will receive free, hands-on training and
consulting on MariaDB and MySQL® database solutions from the experts at
SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog,
among others. SkySQL and MariaDB will bring together industry
visionaries, including Michael (Monty) Widenius and David Axmark, the
original authors of the MySQL database, to share their insights on
current and future trends pertaining to the world's most popular open
source database.

To learn more about this free event, visit
http://www.skysql.com/events/mysql-solutions-day

The schedule for the event is here:
http://www.skysql.com/events/mysql-solutions-day/schedule

Attendees are also invited to participate in Drizzle Day– a parallel
event co-hosted by SkySQL, Percona, and the Drizzle Development Team,
featuring tutorials on the Drizzle database.


--- User Feedback plugin --

MariaDB includes a User Feedback plugin. This plugin is disabled by
default. If enabled, it submits basic, completely anonymous MariaDB
usage information. This information is used by the developers to track
trends in MariaDB usage to better guide development efforts.

If you would like to help make MariaDB better, please add
--plugin-load=feedback.so to your my.cnf file! On Windows, add
feedback=ON to your my.ini file, or click the checkbox during the
installation of the MSI package.

See http://kb.askmonty.org/en/user-feedback-plugin for more information.


--- MariaDB Crash Course book -

We would also like to mention the book MariaDB Crash Course, by Ben
Forta. This book - for beginner to intermediate level users - will get
you up and running with MariaDB, even if you've never used a database
before. More information is available at:
http://forta.com/books/0321799941/


--- Quality ---

The project always strives for quality, but in reality, nothing is
perfect. Please take time to report any issues you encounter at:
https://bugs.launchpad.net/maria

We hope you enjoy MariaDB!

-- 
Daniel Bartholomew
MariaDB - http://mariadb.org
Monty Program - http://montyprogram.com
AskMonty Knowledgebase - http://kb.askmonty.org

___
announce mailing list
annou...@mariadb.org
http://lists.askmonty.org/cgi-bin/mailman/listinfo/announce
To unsubscribe, send an email with unsubscribe as the Subject: to 
announce-requ...@mariadb.org
-- 
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: Tell me it's not true

2012-02-29 Thread Tom Davies
Hi :)
The documentation appearing at 
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
The Faq at 
https://wiki.documentfoundation.org/Faq#Base
(and the forum at OpenOffice, grrr) are having a major effect on Base.  

It used to be almost impossible to get any answer at all about Base on this 
list.  Now lots of people are giving opinions and sometimes even helpful 
advice.  People don't come to this list to ask questions when everything runs 
smoothly!  

Keep up the good work!  Documentation is leading the way!
Thanks and regards from
Tom :)


--- On Wed, 29/2/12, Dan Lewis elderdanle...@gmail.com wrote:

     This thread for the most part is exactly what should not be part of
this mailing list. The attitudes are horrible with very little said in a
positive way. Yes, why have Base? Why have a Base Guide? The person who
wrote a suggested outline for the Base Guide is among this group. With
this attitude, how could the outline be what it should be? Does it
suffer the same attitude problem? Besides, what purpose would it serve
given the comments about Base?
     What would most people who are new to Base think after reading the
negative comments about Base? Statements about how hard it is to learn
(comparing learning at least some of it to the difficulty of learning a
new language). No one seems to be able to give references that would
help. (No one has so far.)
     Recently there was a long thread that began with a problem with a
large spreadsheet. One of the early comments was that the data should
have been in a database. Now, it appears that that comment should have
been: you should be using a database but don't use Base. Strange very
little help was give as to how Calc could be used. So, it sounds like to
me that the advice seems to be: limit your use of Calc and DON'T USE
Base.
     OK, I have had my say. I will likely delete any replies that come
from this thread because I have seen people justify their actions in the
past threads. This is suppose to be a list to help others, and their
comments are not likely to do that. Besides, any replies to me need to
consist of references for getting the most from Base. Other than help in
learning more about how to use it, I don't need.

--Dan


-- 
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] Closing Calc Documents

2012-02-29 Thread Tom Davies
Hi :)
I thought closing with the little white-on-red X at the top right of a window 
was fine but people have sometimes tried to tell me that i 'should' use 
File - Close
because it's better apparently.  I really don't think it makes a difference 
but i was hoping other people would know more about it and give a better answer 
to this thread.

Regards from
Tom :)


--- On Wed, 29/2/12, alnuwer alnu...@cox.net wrote:

From: alnuwer alnu...@cox.net
Subject: [libreoffice-users] Closing Calc Documents
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 4:03

On SOME occasions (not all), after I close a calc doc, my Windows Explorer
still shows it as open. To remove the lock-file name entry in Explorer, I
must reopen the doc and close it again. This usually gets the job done. Is
this a bug, or am I not closing the doc properly? I usually hit the big red
X to close (but sometimes the little black X to just close the doc and not
calc.

LibreOffice 3.3
Windoes XL Pro

Thanks for your help!
Al 

--
View this message in context: 
http://nabble.documentfoundation.org/Closing-Calc-Documents-tp3786180p3786180.html
Sent from the Users mailing list archive at Nabble.com.

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


-- 
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] Re: increase testing to improve quality

2012-02-29 Thread NoOp
On 02/29/2012 03:14 AM, e-letter wrote:
 On 29/02/2012, NoOp sniprudeemailquotefrome-letter-fixyourclient wrote:
 There is a web page which describes manual testing:
 http://wiki.documentfoundation.org/QA/Testing/Manual_Tests. Clearly,
 there are insufficient testers...

 Clearly:
 quote
 IMPORTANT: Obsoleted by Litmus

 Litmus is a useful tool for organizing manual tests. Please, help us to
 migrate all these test cases there and remove them from this wiki page.
 /quote

 So why even point 'users' to that page?

 
 The initial purpose is to promote the existence of QA testing, both in
 terms of the history (the wiki) and the future (litmus).

And if the manual test is obsolete  LO wish to migrate everyone to the
litmus test page instead you think it's a good idea to direct users on
this list to that page? Seems a bit odd to me.


 Cool. Have you *actually* installed 3.5.1rc1 (as noted in the litmus test)?
 Description: Test run for *3.5.1 RC* regression testing. Please use
 *3.5.1 RC* build to test the cases in this run.

 
 No, there are no new features of personal interest.

Well you've got me there... You are asking everyone on this list to hop
on over  perform pre-release testing  yet you've not bothered to
install  do the same? Amazing.

 
 If you did (and you'd need to find it someplace other than:
 http://www.libreoffice.org/download/pre-releases/ and (currently) only
 on http://dev-builds.libreoffice.org/daily/
 you'd find that the install (at least on a debian linux system) smokes
 your existing 3.5.0 install (remember 3.5.0 is the released version).

 
 I don't fully understand, but perhaps this is a serious bug?

No. It's not a bug at all. It is a fact of testing. If you actually
actively did what you are flogging in this thread (pre-release testing)
you'd be well aware of the issues with installing test versions on
existing systems. To promote otherwise on *this* list is both
disingenuous and dangerous.

 
 So, while I (we?) appreciate your efforts to get users on this user
 list as pre-release testers, I'd be overly cautious about asking users
 on this list to perform litmus tests... At least not without explaining
 in *detail* what is required, and how to avoid existing LO standard
 installations being blown away by a pre-release version.

 
 That is valid and is of such high importance to be published on the
 'qa' web page!
 
 IMO it's probably better for 'users' on this list to wait to
 test/participate when http://www.libreoffice.org/download/pre-releases/
 actually shows a pre-release version. *And* testers understand the
 implications of testing. This will avoid the LO blew up my thesis and
 wiped out all of my exisiting templates/files/settings. (Note: I'm not
 making light of those that do report such, but instead trying to avoid
 such reports here in the first place as they are *serious* issues  can
 happen if you don't understand what you are doing when you test.)

 
 True, but surely users are sufficiently intelligent to understand not
 to use alpha, beta, pre-release, release candidate, etc. on computers
 containing important information such as a thesis???

You've already stated that you've not installed/tested/tried 3.5.x
yourself (No, there are no new features of personal interest.) and are
unaware that the RC does not install as a dev version and installs
over the top of a pre-installed 3.5.0 standard version. So... are you
sufficiently intelligent enough to understand that your advise made no
mention of this?

 
 Any competent tester should have a separate machine.

Right... Do you? I seriously doubt that.
Any competent tester would have tested on his/her own system *first*
(with at several OS's) before posting on this list.
Did you?

Note: If you (or anyone else) is still reading; I highly advocate
testing pre-release versions of LO and AOO whenever possible. However I
do not advocate posting invites on an LO (or AOO/OOo) user list
recommending that the users on the list jump on in and test an
alpha/beta/RC version of LO (or anything) without *first* advising the
users/testers of the issues (including data loss/profile loss etc) in
doing so blindly.

@e-letter: I'm not attempting to dissuade you (and others on this list)
from from promoting/asking others to assist in testing alpha/beta/RC
versions of LO. I *am* attempting to dissuade you from doing this
without first: 1) doing it yourself, 2) knowing  explaining the
benefits  hazards of doing the tests, 3) where  how to report what
you've done/tested.

I would add: 4) ensure that any particular user on this list be
prepared to *not* attempt to engage in any dev LO devs/lists regarding
issues they find with testing these pre-release versions, particularly
those that may involve developers as they will be greeted with both
animosity and insults in the process. You'll then be asked for a
software patch  solution to the problem that you've inocently brought
up on the dev list, and then be sent to dev-hell because: 1)