Re: [libreoffice-users] Frequent crashing

2011-07-28 Thread Jean-Baptiste Faure
Le 28/07/2011 06:02, JeepNut a écrit :
> Have been having significant trouble keeping LibreOffice Writer running. 
> Lost a pretty important file recently and some helpful soul had suggested
> there should be some sort of logs being generated during these events.  
> I'm one of those users who knows enough to make him dangerous, HOWEVER, I
> think I have found the log files being generated when this puppy gags. 
> There are several of these all during the time frame that the software kept
> crashing on me the other night.  These files are all similar if not exactly
> the same and seem to be giving me the idea that the problem is related to
> Java.  I'm not sure just how Java is related to the LO suite, but the well
> of what I don't know is a deep one.
> 
> I'm going to make an attempt here at attaching the file for review by anyone
> who might be able to help.
> Thanks!
> 
> http://nabble.documentfoundation.org/file/n3205545/hs_err_pid4845.log
> hs_err_pid4845.log 

This file is indeed the crash log of your Java virtual machine.
I suggest you to give a try to the vanilla version of LibreOffice :
http://www.libreoffice.org/download/

If you do not want to remove the Ubuntu version of LibO first, then
install vanilla version without the libreoffice-debian-menu package.
Then you will have to launch LibO by using the command line :
/opt/Libreoffice/program/soffice  (version 3.3.3)
or /opt/libreoffice3.4/program/soffice (version 3.4.1)

Usefull to know : http://wiki.documentfoundation.org/Installing_in_parallel

Best regards
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
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 record access unacceptably slow

2011-07-28 Thread Tom Cloyd

, On 07/28/2011 12:53 AM, Tom Cloyd wrote:

On 07/28/2011 12:44 AM, Alexander Thurgood wrote:

Le 27/07/11 18:14, Tom Cloyd a écrit :



That command appears to have cut 5 seconds off the record pointer move
test, and also off the full db search test I ran previously.


Well better than nothing I suppose, but I do sympathise. Did the JDK/JRE
change suggested by someone else help any further ?


Alex



Am just about to make the switch - will let you know asap! I'm very 
hopeful. And I've decided to switch to sqlite when I'm not so rushed. 
Have heard that that's where LO's going anyway.


Tom

Ug. This is getting ugly really fast. I'm really not on home ground  
here at all.


After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I downloaded
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and

sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0 
.



Then I did this at a console, with the following result:


tomc@LDT:~/software_archive$ sudo dpkg --unpack 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb

[sudo] password for tomc:
dpkg: warning: parsing file '/var/lib/dpkg/status' near line 38010 
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit
dpkg: warning: parsing file '/var/lib/dpkg/available' near line 40706 
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit
dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to 
6.22-0ubuntu1~10.04.

(Reading database ... 190655 files and directories currently installed.)
Preparing to replace sun-java6-bin 6.26-1natty1 (using 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb) ...

debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend requires a screen at least 13 lines tall and 
31 columns wide.)

debconf: falling back to frontend: Readline
sun-dlj-v1-1 license has already been accepted
Unpacking replacement sun-java6-bin ...
Processing triggers for desktop-file-utils ...
Processing triggers for menu ...
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 38010 
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit


Most of this is just garble to me,


THIS is scary: "dpkg: warning: downgrading sun-java6-bin from 
6.26-1natty1 to 6.22-0ubuntu1~10.04."
I said UNPACK, not INSTALL. What's this "downgrading" nonsense? Then 
this: "Preparing to replace sun-java6-bin 6.26-1natty1" Huh? All this on 
an "unpack". This is beyond scary. This is nuts. What's up with this???



Then, and this is the main problem - where's the result of the command? 
I expected the unpack to put files in a dir, in the same dir as the DEB 
file. Isn't this usually what happens when one unpacks a file? But 
there's nothing there.



I'm in freefall right now. Don't know what just happened, don't know 
what to do next. Can anyone help?



Guess I'm not going to get any db work done tonight, after all. Not a 
good day.



Tom


--
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: Connect ODBC / JDBC Firebird database - LibreOffice 3.3.3 - Windows XP

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 01:14, Giovanni Romero Pérez a écrit :

Hi Giovanni,


> Then I created a database in Base and did the settings to connect to the
> database using the ODBC source. The connection is OK, but when I try to
> Access to a table or run a query, Base throws this message:
> 
> --
> No se pudieron cargar los contenidos de los datos.
> Fetch type out of range
> --
> 
> And I can not see the results.

>From what I remember of other people's attempts to connect using ODBC,
this is currently not working with LibreOffice (or even OpenOffice.org
for that matter).

> 
> I thought about using JDBC, as I have read that allows you to connect more
> easily. The problem is that I don't find documentation to configuring
> Firebird JDBC connector (called Jaybird and available at
> http://www.firebirdsql.org/en/jdbc-driver).

You have to first declare the JDBC JAR within LibreOffice so that it
knows where to look to find it.

1) Menu Tools - Options - LibreOffice - Java

wait for it to detect your Java installation(s), select the one that you
want as required (if you have a choice).

2) Click on the button "Classpath", then on the button "Add archive".

3) Navigate using the file picker dialog to where your JAR file is
located, select it, then click on OK. It should then appear in the list
of added java archives.

4) Click on OK to quit the Java configuration dialog.

5) Shut down LibreOffice, including any quickstarter (icon in the tray
at the bottom right of your screen)

6) Restart LibreOffice

7) Click on File - New - Database

8) Choose "Connect to an existing Database" and select "JDBC" from the
driver selection list.

9) In the JDBC setup fields :

Datasource URL :
firebirdsql://servername:port//path/to/db/location/dbname.fdb

JDBC driver class : org.firebirdsql.jdbc.FBDriver


Note that these last two parameters I obtained from this page :

http://www.insttech.washington.edu/~lab/Support/HowtoUse/UsingJDBCWithFirebird.html

I don't actually have a firebird server running to be able to test.



Alex




-- 
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: Base record access unacceptably slow

2011-07-28 Thread Andreas Säger

Am 28.07.2011 08:15, Heinrich Stoellinger wrote:

I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H



Dear Heinrich,

Face it: There is not a single LO developer doing anything Base related. 
The Base component will fall apart sooner or later. Writer's mail merge 
and bibliography will be spreadsheets, form controls will be mere 
gimmicks and nobody except you and me and some hundreds of professionals 
will notice the severe loss.


Grüße aus NRW,
Andreas


--
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 record access unacceptably slow

2011-07-28 Thread Tom Davies






From: Tom Cloyd 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 9:04:22
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

, On 07/28/2011 12:53 AM, Tom Cloyd wrote:
> On 07/28/2011 12:44 AM, Alexander Thurgood wrote:
>> Le 27/07/11 18:14, Tom Cloyd a écrit :
>> 
>> 
>>> That command appears to have cut 5 seconds off the record pointer move
>>> test, and also off the full db search test I ran previously.
>>> 
>> Well better than nothing I suppose, but I do sympathise. Did the JDK/JRE
>> change suggested by someone else help any further ?
>> 
>> 
>> Alex
>> 
>> 
>> 
> Am just about to make the switch - will let you know asap! I'm very hopeful. 
>And I've decided to switch to sqlite when I'm not so rushed. Have heard that 
>that's where LO's going anyway.
> 
> Tom
> 
Ug. This is getting ugly really fast. I'm really not on home ground  here at 
all.

After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I downloaded
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and

sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0
.
.


Then I did this at a console, with the following result:


tomc@LDT:~/software_archive$ sudo dpkg --unpack 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb
[sudo] password for tomc:
dpkg: warning: parsing file '/var/lib/dpkg/status' near line 38010 package 
'amaya':
error in Version string 'wx-11.3.1-1': version number does not start with digit
dpkg: warning: parsing file '/var/lib/dpkg/available' near line 40706 package 
'amaya':
error in Version string 'wx-11.3.1-1': version number does not start with digit
dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to 
6.22-0ubuntu1~10.04.
(Reading database ... 190655 files and directories currently installed.)
Preparing to replace sun-java6-bin 6.26-1natty1 (using 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb) ...
debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend requires a screen at least 13 lines tall and 31 
columns wide.)
debconf: falling back to frontend: Readline
sun-dlj-v1-1 license has already been accepted
Unpacking replacement sun-java6-bin ...
Processing triggers for desktop-file-utils ...
Processing triggers for menu ...
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 38010 
package 
'amaya':
error in Version string 'wx-11.3.1-1': version number does not start with digit

Most of this is just garble to me,


THIS is scary: "dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to 
6.22-0ubuntu1~10.04."
I said UNPACK, not INSTALL. What's this "downgrading" nonsense? Then this: 
"Preparing to replace sun-java6-bin 6.26-1natty1" Huh? All this on an "unpack". 
This is beyond scary. This is nuts. What's up with this???


Then, and this is the main problem - where's the result of the command? I 
expected the unpack to put files in a dir, in the same dir as the DEB file. 
Isn't this usually what happens when one unpacks a file? But there's nothing 
there.


I'm in freefall right now. Don't know what just happened, don't know what to do 
next. Can anyone help?


Guess I'm not going to get any db work done tonight, after all. Not a good day.


Tom



Hi
Don't worry about downgrading a package.  It's easy to upgrade again if you 
need 
to do that later.  Sometimes packages suffer from regressions making it 
important to downgrade.  Wine has often suffered from this.
Regards from
Tom :)

-- 
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 record access unacceptably slow

2011-07-28 Thread Heinrich Stoellinger

Hallo Andreas,
In my view, BASE "falling apart" would mean LO's "death sentence" in the long
run! Anybody in even the simplest business environment will want to write
documents based on data stored in business-critical databases (and I think I
am right in assumung that relational DBs have been the standard now for 
decades!).
Does anybody REALLY think that a package like LO can survive if it ignores
such an important sector of users? I sure don't!!!
Gruesse aus Salzburg
Heinz


On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger  wrote:


Am 28.07.2011 08:15, Heinrich Stoellinger wrote:

I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H



Dear Heinrich,

Face it: There is not a single LO developer doing anything Base related.
The Base component will fall apart sooner or later. Writer's mail merge
and bibliography will be spreadsheets, form controls will be mere
gimmicks and nobody except you and me and some hundreds of professionals
will notice the severe loss.

Grüße aus NRW,
Andreas





--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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 record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi :)
Good call.  Wikipedia gave this
http://en.wikipedia.org/wiki/MariaDB
and  their homepage
http://mariadb.org/

Perhaps we could try to get some help from their devs.  They might have soem 
good ideas on how Base needs to be developed.
Regards from
Tom :)




From: Heinrich Stoellinger 
To: users@global.libreoffice.org; Tom Cloyd 
Sent: Thu, 28 July, 2011 7:15:31
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Hi Tom,
Just my - maybe naive - 2 pennies worth of comments:
As I mentioned before, I have been using OO/LO for years together with
BASE with MySQL (which - also "sigh") now "belongs" to Oracle as well.
As a connector to the DB I have tried out the Java version (always had
trouble with it one way or the other!) as well as ODBC/UNIXODBC (which
is what I am now using under Linux and which works sort of!). With
MySQL there is also the native connector which I would actually prefer
to use - but, yes you guess right - does NOT work on either LO 3.3.3 or
3.4.1 under Linux. A bit confusing, isn't it!
I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H


On Thu, 28 Jul 2011 00:19:26 +0200, Tom Cloyd  wrote:

> Thanks, Andreas.
>
> To summarize what I learned from that second link: I need to install
> sun-java6-jre_6.22-0ubuntu1~10.04 into a directory of my choosing, then
> direct LO to use this special older version (which, it is reported, does
> not cause the awful slowdown we're experiencing).
>
> Look like a short-term solution I can live with. Give me hope that I get
> back to work, later today
>
> The long-term solution appears entirely opaque, however. Is the problem
> being reported to Oracle (who I presume is behind the latest sun-java
> updates). Is this an Oracle plot to blow OO and LO opensource dbs out of
> the water?
>
> Is there any hope we can cut this dependancy upon a java version that is
> now associated with Oracle?
>
> Sigh.
>
> Tom
>
> On 07/27/2011 02:26 AM, Andreas Säger wrote:
>> The Base documentation:
>>http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial
>>l
>>
>>
>> My chrystal ball tells me that you run LibreOffice with a recent Java
>> version under Linux, therefore this is the solution to your problem:
>> http://www.oooforum.org/forum/viewtopic.phtml?t=125253
>>
>>
>
>


-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

-- 
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
-- 
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] Doubt about digital signature

2011-07-28 Thread Grasiela Peccini
Hi Jay,

I don't save the file with password, this is ok. The problem is only with
digital signature. The LibO doesn't request the smart card key when I try
sign the file a second time.

Thanks for the feedback!

Grasip.

On Wed, Jul 27, 2011 at 7:54 PM, planas  wrote:

> Hi Grasiela,
>
> On Wed, 2011-07-27 at 12:00 -0300, Grasiela Peccini wrote:
>
> > Hi,
> > I need information about digital signature. I don't know if i'm working
> with
> > a bug or it's a normal behavior of LibreOffice.
> > The steps:
> > 1- User saves a document and signs it, when is requested the PIN
> > 2 - User makes changes on the document, saves it and signs it again
> > 3 - Here is the point. The PIN is no longer requested. A new request is
> made
> > only when the smart card is removed from the reader or when the
> LibreOffice
> > is closed and reopened.
> > I'm using LibreOffice 3.3.0, on Windows XP. I've done the same test on
> > LibreOffice 3.4, with the same results.
> > Thanks a lot,
> > Grasip.
> >
> > --
> > "Eu quase nada sei, mas desconfio de muita coisa."
> >   Guimarães Rosa
> >
>
> Are saving the document with a password using FILE>>SAVE AS and
> selecting "Save with Password"?
>
> When I tested this with file with a password, I was asked for it every
> time I opened the file. I do not use a smart card so the behavior may be
> caused by the smart card.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
> --
> 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
>



-- 
"Eu quase nada sei, mas desconfio de muita coisa."
  Guimarães Rosa

-- 
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 record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi again :)
As well as MariaDb there is also Drizzle which is supported by many of TDF's 
supporters
http://en.wikipedia.org/wiki/Drizzle_(database_server)
and their homepage
http://drizzle.org/
Regards again from 
that other Tom ;)






From: Heinrich Stoellinger 
To: users@global.libreoffice.org; Tom Cloyd 
Sent: Thu, 28 July, 2011 7:15:31
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Hi Tom,
Just my - maybe naive - 2 pennies worth of comments:
As I mentioned before, I have been using OO/LO for years together with
BASE with MySQL (which - also "sigh") now "belongs" to Oracle as well.
As a connector to the DB I have tried out the Java version (always had
trouble with it one way or the other!) as well as ODBC/UNIXODBC (which
is what I am now using under Linux and which works sort of!). With
MySQL there is also the native connector which I would actually prefer
to use - but, yes you guess right - does NOT work on either LO 3.3.3 or
3.4.1 under Linux. A bit confusing, isn't it!
I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H


On Thu, 28 Jul 2011 00:19:26 +0200, Tom Cloyd  wrote:

> Thanks, Andreas.
>
> To summarize what I learned from that second link: I need to install
> sun-java6-jre_6.22-0ubuntu1~10.04 into a directory of my choosing, then
> direct LO to use this special older version (which, it is reported, does
> not cause the awful slowdown we're experiencing).
>
> Look like a short-term solution I can live with. Give me hope that I get
> back to work, later today
>
> The long-term solution appears entirely opaque, however. Is the problem
> being reported to Oracle (who I presume is behind the latest sun-java
> updates). Is this an Oracle plot to blow OO and LO opensource dbs out of
> the water?
>
> Is there any hope we can cut this dependancy upon a java version that is
> now associated with Oracle?
>
> Sigh.
>
> Tom
>
> On 07/27/2011 02:26 AM, Andreas Säger wrote:
>> The Base documentation:
>>http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial
>>l
>>
>>
>> My chrystal ball tells me that you run LibreOffice with a recent Java
>> version under Linux, therefore this is the solution to your problem:
>> http://www.oooforum.org/forum/viewtopic.phtml?t=125253
>>
>>
>
>


-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

-- 
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
-- 
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] spellcheck in calc

2011-07-28 Thread Tom Davies
Hi :)
Could you post a bug-report about it?
http://wiki.documentfoundation.org/BugReport

Until it gets fixed could you select  cell just past the one that causes 
problems and "Resume spell check from current position" rather than begin spell 
check at the beginning of the document again?  I don't know if it gives the 
option or not but often an interrupted spell check will offer it in other apps. 
 

Regards from
Tom :)





From: Thomas Blasejewicz 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 3:38:08
Subject: [libreoffice-users] spellcheck in calc

Good morning
I have noted this in the past already several times, but since this is
not something I use frequently just ignored it.

I am trying to spellcheck in Calc.
Set the language to German (English seems to (?) work).
Start spelling.
Speller encounters unknown term -> instruct to "ignore once"
For reasons unknown it hangs up here.
Where the button "ignore once" was, now "Resume" is displayed.
Click Resume -> unknown term -> instruct to "ignore once" -> Resume


Once this cycle starts the speller NEVER gets out of that cell again.
And if this happens say in the third cell of a 5,000-cell sheet ---
it renders the spell checker completely useless.

Is there a way of telling the spell checker it has more work to do?


*** Also - sorry for the confusion - but, ...
the function "ignore all" seems not to be working.
Since I constantly get those funny viscious cycles mentioned above I am
not really sure about Calc,
but in Writer this is a constant + persistant behavior.
Regarding THIS behavior, I have to admit I was very much annoyed by it
in Wordperfect, Word and other software too.

I wish there were a magic spell that could fix these very
counterproductive ticks.

Thank you in advance
Thomas

-- 
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
-- 
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: New User: Three Questions

2011-07-28 Thread Tom Davies
Hi :)
That is strange and i'm sure "Webmaster at Kracked Press" has probably 
mentioned 
it before but it might be worth posting a bug-report about it.  It's a bit 
weird 
to have to keep copies of fonts in several different places.
http://wiki.documentfoundation.org/BugReport
I have a feeling that short-cuts (="links" in linux and perhaps Mac?) mightwork 
well but it's still weird and inconvenient.  

Regards from
Tom :)





From: Rich Shepard 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 2:46:39
Subject: Re: [libreoffice-users] Re: New User: Three Questions

On Wed, 27 Jul 2011, NoOp wrote:

> I only referred to that as it shows making a ~/.fonts folder etc. Please
> create and put the BakerSignet font in there & see if LO picks it up.

> Not really, as I don't know what the astrisk is in '1152a___.*' - I know
> of no fonts that are listed as .* Nor are there any fonts that use a
> .atm extension. .atm is used for the Adobe Type Manager font
> catalog/file & ATM fonts are generally Type 1 fonts with an .pfb, .afm
> and .pfm (and possibly .pfa) files. So I'm still confused.

  The asterisk means multiple suffixes. In this case, 1152a___.afm,
1152a___.inf, 1152a___.pfb, and 1152a___.pfm. I mistyped afm as atm.

  Well, I guess LO is different from other apps in that it cannot see fonts
in /usr/share/fonts, but does in ~/.fonts. Very strange. Regardless, I will
make softlinks in ~/.fonts to the directories in /usr/share/fonts.

Thanks,

Rich


-- 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
-- 
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: New User: Three Questions

2011-07-28 Thread Rich Shepard

On Thu, 28 Jul 2011, Tom Davies wrote:


It's a bit weird to have to keep copies of fonts in several different
places. I have a feeling that short-cuts (="links" in linux and perhaps
Mac?) mightwork well but it's still weird and inconvenient.


Tom,

  I've not needed to do this with WordPerfect/linux, Abiword, or
OpenOffice.org. Yes, it is strange.

  Links in linux are not equivalent to Microsoft shortcuts. The latter are
icons on the root window, but I have no idea what they do behind the scenes.
The default for link creation is a hard link; that is, an actual copy of the
file at a new location. Most of the time a soft link does the job. Those are
pointers to the actual file so there's only one copy on the system.

  I'm not going to dig into the code and try to learn why the application
does not pick up the LHS default location of /usr/share/fonts. Perhaps it's
mimicing a single-user application (which is what I assume Microsoft Office
is) so it wants everything local to the user invoking it. Shrug. A minor
PITA for maintenance, but at least I can now access all the fonts on my
system.

Regards,

Rich

--
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] (help macro base)Open form with a button form another form with filter

2011-07-28 Thread rogerio dandrea
my macro dont apply filter why?


GLOBAL myindex as integer

sub pega( oev as variant )
dim odoc,oform,sfilter
odoc=thiscomponent
oform=odoc.drawpage.forms.getbyindex(0)
  'pega o dado da primeira linha(=index =campo Cad no meu caso) do registro
atual
 myindex=oform.getstring(1)

 ThisDatabaseDocument.FormDocuments.getByName( "animal3" ).open

  odoc=thiscomponent
 oform=odoc.drawpage.forms.getbyindex(0)

  'define o filtro para achar os registros

 sfilter =  chr(34) & "Cad" & chr(34) & chr(61) & myindex
 print sfilter
 oform.filter = sfilter
 oform.applyfilter= True
 oform.reload  ' recarrega o formulario com o filtro pelo na
teoria pois não esta funcionando
  'reload the form with the filter apply
dont work

end sub

-- 
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: Base record access unacceptably slow

2011-07-28 Thread Andreas Säger

Am 28.07.2011 10:04, Tom Cloyd wrote:


I'm in freefall right now. Don't know what just happened, don't know
what to do next. Can anyone help?


Guess I'm not going to get any db work done tonight, after all. Not a
good day.


Tom





I used my graphical zip tool to extract the data.tar.gz from the 2 
package files.



--
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: Doubt about digital signature

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 14:12, Grasiela Peccini a écrit :

Hi Grasiela,

> I don't save the file with password, this is ok. The problem is only with
> digital signature. The LibO doesn't request the smart card key when I try
> sign the file a second time.

That sounds like a bug to me. Which OS are you using ?

You might like to read up on how it is supposed to work here (if this is
still relevant) :

http://wiki.services.openoffice.org/wiki/How_to_use_digital_Signatures


My understanding of current LibreOffice development was that digital
signing did not work (either properly or at all), because of having to
build against a very old version of nss from Mozilla.


Alex


-- 
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: (help macro base)Open form with a button form another form with filter

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 15:40, rogerio dandrea a écrit :

Hi Rogerio,


> 
>  ThisDatabaseDocument.FormDocuments.getByName( "animal3" ).open
> 
>   odoc=thiscomponent
>  oform=odoc.drawpage.forms.getbyindex(0)
> 
>   'define o filtro para achar os registros
> 
>  sfilter =  chr(34) & "Cad" & chr(34) & chr(61) & myindex
>  print sfilter
>  oform.filter = sfilter
>  oform.applyfilter= True
>  oform.reload  ' recarrega o formulario com o filtro pelo na
> teoria pois não esta funcionando
>   'reload the form with the filter apply
> dont work
> 

I could be wrong here, but you could try setting the focus on one of
this form's controls before attempting to reload, or alternatively you
might find you have to reload the first form that was opened in order to
get the second one to update. From memory, I think that there was a
discussion about this on the old OpenOffice.org dba discuss or user list.


Alex


-- 
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: New User: Three Questions

2011-07-28 Thread Tom Davies






From: Rich Shepard 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 14:15:40
Subject: Re: [libreoffice-users] Re: New User: Three Questions

On Thu, 28 Jul 2011, Tom Davies wrote:

> It's a bit weird to have to keep copies of fonts in several different
> places. I have a feeling that short-cuts (="links" in linux and perhaps
> Mac?) mightwork well but it's still weird and inconvenient.

Tom,

  I've not needed to do this with WordPerfect/linux, Abiword, or
OpenOffice.org. Yes, it is strange.

  Links in linux are not equivalent to Microsoft shortcuts. The latter are
icons on the root window, but I have no idea what they do behind the scenes.
The default for link creation is a hard link; that is, an actual copy of the
file at a new location. Most of the time a soft link does the job. Those are
pointers to the actual file so there's only one copy on the system.

  I'm not going to dig into the code and try to learn why the application
does not pick up the LHS default location of /usr/share/fonts. Perhaps it's
mimicing a single-user application (which is what I assume Microsoft Office
is) so it wants everything local to the user invoking it. Shrug. A minor
PITA for maintenance, but at least I can now access all the fonts on my
system.

Regards,

Rich


Hi :)
If you have fixed the problem then that's great but it would help other people 
if you could just post a bug-report to let the devs know that there is 
something 
worth fixing.  Posting a bug-report does not mean fixing the problem yourself 
and does not mean doing coding work yourself.  It's roughly like sending an 
email to the devs group and leaving it for them to do the work.  By "like" i do 
not mean "identical to".  


"Equivalents" is also a very ambiguous word.  I was referring to soft-links as 
created in a DE when you right-click on a file and choose "Make Link" or on a 
menu item and choose "Add to desktop" (or panel).  My understanding of 
hard-links is sketchy but i think they don't create copies of files
http://www.cyberciti.biz/tips/understanding-unixlinux-symbolic-soft-and-hard-links.html

Regards from
Tom :)
-- 
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 record access unacceptably slow

2011-07-28 Thread Heinrich Stoellinger

Hello Tom,
That's fine. However, to use such a DB-backend one also needs support in a
myriad of other software in a webserver (mail, PHP-frameworks, etc., etc.).
Regards
H. S.

On Thu, 28 Jul 2011 14:31:50 +0200, Tom Davies  wrote:


Hi again :)
As well as MariaDb there is also Drizzle which is supported by many of TDF's
supporters
http://en.wikipedia.org/wiki/Drizzle_(database_server)
and their homepage
http://drizzle.org/
Regards again from
that other Tom ;)






From: Heinrich Stoellinger 
To: users@global.libreoffice.org; Tom Cloyd 
Sent: Thu, 28 July, 2011 7:15:31
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Hi Tom,
Just my - maybe naive - 2 pennies worth of comments:
As I mentioned before, I have been using OO/LO for years together with
BASE with MySQL (which - also "sigh") now "belongs" to Oracle as well.
As a connector to the DB I have tried out the Java version (always had
trouble with it one way or the other!) as well as ODBC/UNIXODBC (which
is what I am now using under Linux and which works sort of!). With
MySQL there is also the native connector which I would actually prefer
to use - but, yes you guess right - does NOT work on either LO 3.3.3 or
3.4.1 under Linux. A bit confusing, isn't it!
I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H


On Thu, 28 Jul 2011 00:19:26 +0200, Tom Cloyd  wrote:


Thanks, Andreas.

To summarize what I learned from that second link: I need to install
sun-java6-jre_6.22-0ubuntu1~10.04 into a directory of my choosing, then
direct LO to use this special older version (which, it is reported, does
not cause the awful slowdown we're experiencing).

Look like a short-term solution I can live with. Give me hope that I get
back to work, later today

The long-term solution appears entirely opaque, however. Is the problem
being reported to Oracle (who I presume is behind the latest sun-java
updates). Is this an Oracle plot to blow OO and LO opensource dbs out of
the water?

Is there any hope we can cut this dependancy upon a java version that is
now associated with Oracle?

Sigh.

Tom

On 07/27/2011 02:26 AM, Andreas Säger wrote:

The Base documentation:
http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial
l


My chrystal ball tells me that you run LibreOffice with a recent Java
version under Linux, therefore this is the solution to your problem:
http://www.oooforum.org/forum/viewtopic.phtml?t=125253











--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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 record access unacceptably slow

2011-07-28 Thread Don C. Myers

Hi Tom,

When the first problems showed up for me about 6 months ago, it was 
recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my 
database on 4 computers, and could never make things work with getting a 
previous version installed, so I gave up and just tolerated the 
situation. Also, I had security concerns going backwards since, as I 
understand it, among other things updated Java versions have have 
security issues fixed. I'm relatively good with Ubuntu, but far from an 
expert. What we all know is that Java is the problem. Can someone give 
us instructions on how to use the LibreOffice front end with a database 
that doesn't require Java. I see that you had said that LibreOffice may 
be moving to sqlite? Is that a solution that anyone could help us with?


Don

On 07/28/2011 04:04 AM, Tom Cloyd wrote:

, On 07/28/2011 12:53 AM, Tom Cloyd wrote:

On 07/28/2011 12:44 AM, Alexander Thurgood wrote:

Le 27/07/11 18:14, Tom Cloyd a écrit :



That command appears to have cut 5 seconds off the record pointer move
test, and also off the full db search test I ran previously.

Well better than nothing I suppose, but I do sympathise. Did the 
JDK/JRE

change suggested by someone else help any further ?


Alex



Am just about to make the switch - will let you know asap! I'm very 
hopeful. And I've decided to switch to sqlite when I'm not so rushed. 
Have heard that that's where LO's going anyway.


Tom

Ug. This is getting ugly really fast. I'm really not on home ground  
here at all.


After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I 
downloaded

sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and

sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0 
. 




Then I did this at a console, with the following result:


tomc@LDT:~/software_archive$ sudo dpkg --unpack 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb

[sudo] password for tomc:
dpkg: warning: parsing file '/var/lib/dpkg/status' near line 38010 
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit
dpkg: warning: parsing file '/var/lib/dpkg/available' near line 40706 
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit
dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to 
6.22-0ubuntu1~10.04.

(Reading database ... 190655 files and directories currently installed.)
Preparing to replace sun-java6-bin 6.26-1natty1 (using 
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb) ...

debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend requires a screen at least 13 lines tall and 
31 columns wide.)

debconf: falling back to frontend: Readline
sun-dlj-v1-1 license has already been accepted
Unpacking replacement sun-java6-bin ...
Processing triggers for desktop-file-utils ...
Processing triggers for menu ...
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 
38010 package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start 
with digit


Most of this is just garble to me,


THIS is scary: "dpkg: warning: downgrading sun-java6-bin from 
6.26-1natty1 to 6.22-0ubuntu1~10.04."
I said UNPACK, not INSTALL. What's this "downgrading" nonsense? Then 
this: "Preparing to replace sun-java6-bin 6.26-1natty1" Huh? All this 
on an "unpack". This is beyond scary. This is nuts. What's up with 
this???



Then, and this is the main problem - where's the result of the 
command? I expected the unpack to put files in a dir, in the same dir 
as the DEB file. Isn't this usually what happens when one unpacks a 
file? But there's nothing there.



I'm in freefall right now. Don't know what just happened, don't know 
what to do next. Can anyone help?



Guess I'm not going to get any db work done tonight, after all. Not a 
good day.



Tom




--

***
*


--
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: New User: Three Questions

2011-07-28 Thread Rich Shepard

On Thu, 28 Jul 2011, Tom Davies wrote:


My understanding of hard-links is sketchy but i think they don't create
copies of files
http://www.cyberciti.biz/tips/understanding-unixlinux-symbolic-soft-and-hard-links.html


  Hard links use another node for the same file; that's equivalent to making
copies. Each directory has a limited, but large, number of nodes available.
That's why a partition can be out of space while not completely filled if
there are several thousand tiny files in it.

Rich

--
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 record access unacceptably slow

2011-07-28 Thread Tom Cloyd

Heinz,

I completely agree. LO without a function Base won't fly. Either TDF 
recognizes this - by DOING something - or we have our answer.


Tom

On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote:

Hallo Andreas,
In my view, BASE "falling apart" would mean LO's "death sentence" in 
the long

run! Anybody in even the simplest business environment will want to write
documents based on data stored in business-critical databases (and I 
think I
am right in assumung that relational DBs have been the standard now 
for decades!).
Does anybody REALLY think that a package like LO can survive if it 
ignores

such an important sector of users? I sure don't!!!
Gruesse aus Salzburg
Heinz


On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger 
 wrote:



Am 28.07.2011 08:15, Heinrich Stoellinger wrote:

I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H



Dear Heinrich,

Face it: There is not a single LO developer doing anything Base related.
The Base component will fall apart sooner or later. Writer's mail merge
and bibliography will be spreadsheets, form controls will be mere
gimmicks and nobody except you and me and some hundreds of professionals
will notice the severe loss.

Grüße aus NRW,
Andreas








--
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 record access unacceptably slow

2011-07-28 Thread Heinrich Stoellinger

Hi Don,
In my view LO/OO do NOT require Java, neither on Linux nor on Windows.
As I posted earlier, I have been using ODBC for both the Windows and
Linux versions. It works o.k., even though I still hope that the native
MySQL-supplied connector will function correctly under 3.4.2.
Regards
H

On Thu, 28 Jul 2011 17:16:05 +0200, Don C. Myers  wrote:


Hi Tom,

When the first problems showed up for me about 6 months ago, it was
recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my
database on 4 computers, and could never make things work with getting a
previous version installed, so I gave up and just tolerated the
situation. Also, I had security concerns going backwards since, as I
understand it, among other things updated Java versions have have
security issues fixed. I'm relatively good with Ubuntu, but far from an
expert. What we all know is that Java is the problem. Can someone give
us instructions on how to use the LibreOffice front end with a database
that doesn't require Java. I see that you had said that LibreOffice may
be moving to sqlite? Is that a solution that anyone could help us with?

Don

On 07/28/2011 04:04 AM, Tom Cloyd wrote:

, On 07/28/2011 12:53 AM, Tom Cloyd wrote:

On 07/28/2011 12:44 AM, Alexander Thurgood wrote:

Le 27/07/11 18:14, Tom Cloyd a écrit :



That command appears to have cut 5 seconds off the record pointer move
test, and also off the full db search test I ran previously.


Well better than nothing I suppose, but I do sympathise. Did the
JDK/JRE
change suggested by someone else help any further ?


Alex




Am just about to make the switch - will let you know asap! I'm very
hopeful. And I've decided to switch to sqlite when I'm not so rushed.
Have heard that that's where LO's going anyway.

Tom


Ug. This is getting ugly really fast. I'm really not on home ground
here at all.

After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I
downloaded
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and

sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0
.



Then I did this at a console, with the following result:


tomc@LDT:~/software_archive$ sudo dpkg --unpack
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb
[sudo] password for tomc:
dpkg: warning: parsing file '/var/lib/dpkg/status' near line 38010
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit
dpkg: warning: parsing file '/var/lib/dpkg/available' near line 40706
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit
dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to
6.22-0ubuntu1~10.04.
(Reading database ... 190655 files and directories currently installed.)
Preparing to replace sun-java6-bin 6.26-1natty1 (using
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb) ...
debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend requires a screen at least 13 lines tall and
31 columns wide.)
debconf: falling back to frontend: Readline
sun-dlj-v1-1 license has already been accepted
Unpacking replacement sun-java6-bin ...
Processing triggers for desktop-file-utils ...
Processing triggers for menu ...
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line
38010 package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit

Most of this is just garble to me,


THIS is scary: "dpkg: warning: downgrading sun-java6-bin from
6.26-1natty1 to 6.22-0ubuntu1~10.04."
I said UNPACK, not INSTALL. What's this "downgrading" nonsense? Then
this: "Preparing to replace sun-java6-bin 6.26-1natty1" Huh? All this
on an "unpack". This is beyond scary. This is nuts. What's up with
this???


Then, and this is the main problem - where's the result of the
command? I expected the unpack to put files in a dir, in the same dir
as the DEB file. Isn't this usually what happens when one unpacks a
file? But there's nothing there.


I'm in freefall right now. Don't know what just happened, don't know
what to do next. Can anyone help?


Guess I'm not going to get any db work done tonight, after all. Not a
good day.


Tom







--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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] Doubt about digital signature

2011-07-28 Thread Tom Davies
Hi :)
Do you have any personal info stored in 
Tools - Options - LibreOffice - UserData
I seem to remember some weird bug about this sort of thing not working unless 
there was some personal data in there?  Even if it's fictitious or so generic 
that it doesn't get traced back you you as an individual it seemed to help with 
something like this a few months ago.

I could be wrong as Jay brilliantly fixed the problem last time so this is 
probably some other issue
Regards from
Tom :)





From: planas 
To: users@global.libreoffice.org
Sent: Wed, 27 July, 2011 23:54:27
Subject: Re: [libreoffice-users] Doubt about digital signature

Hi Grasiela,

On Wed, 2011-07-27 at 12:00 -0300, Grasiela Peccini wrote:

> Hi,
> I need information about digital signature. I don't know if i'm working with
> a bug or it's a normal behavior of LibreOffice.
> The steps:
> 1- User saves a document and signs it, when is requested the PIN
> 2 - User makes changes on the document, saves it and signs it again
> 3 - Here is the point. The PIN is no longer requested. A new request is made
> only when the smart card is removed from the reader or when the LibreOffice
> is closed and reopened.
> I'm using LibreOffice 3.3.0, on Windows XP. I've done the same test on
> LibreOffice 3.4, with the same results.
> Thanks a lot,
> Grasip.
> 
> -- 
> "Eu quase nada sei, mas desconfio de muita coisa."
>   Guimarães Rosa
> 

Are saving the document with a password using FILE>>SAVE AS and
selecting "Save with Password"?

When I tested this with file with a password, I was asked for it every
time I opened the file. I do not use a smart card so the behavior may be
caused by the smart card.

-- 
Jay Lozier
jsloz...@gmail.com

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

-- 
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 record access unacceptably slow

2011-07-28 Thread Tom Cloyd

Don,

Seems like a reasonable request to me, and I'll up the ante.

Where the &^%$ is the management - The Document Foundation - in all 
this, right now, today? Do they even watch this list? In short, do they 
give a damn that the only theoretically viable alternative to Access 
(for ordinary users) is in real trouble? Why aren't they showing up here 
with some clarifying position statement?


I'm desperate for time, a fix, and vision of a long-term solution to 
this mess. I have work to do today, a lot of it, and I can't do it. I 
can't solve the problem, and other than by implementing the 
regress-your-java solution idea (which I have yet to be successful 
with). No one else is solving it, either. For some, migrating to another 
backend is not a challenge. For the rest of us, it's unknown territory. 
I researched this a bit, and while there certainly IS stuff out there 
about how to do it, there's not a lot, and there are multiple levels of 
challenge with this solution anyway.


Personally, I'm definitely up for taking this on (what option do I 
really have?), but do we really have to straggle through the mountains 
one by one, eventually meeting on the other side, those who make it, to 
talk about the experience?


So, I propose two things:

1. Anyone who has TDF connections - please get on the phone and update 
them. The question is this, I think: how important, going forward, is 
Base, to them? If they are going to support it, today would be a very 
good day to do it. If not, yank the code, stop telling people they have 
a db component in LO, and start getting honest.


2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache 
in this situation? Again, where's *TDF*? Why aren't they and Apache 
working together on this? Looks rather like a leadership problem, to me.


2. On the assumption that those of use who need a working db are going 
to have to find the way home ourselves (as I said, I need to get work 
done TODAY, and I'm not kidding) -


a. Can someone more Linux-clever than I lay out clearly the steps 
involve in implementing the solution found at the end of this thread - 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0 
. 
As I pointed on in another post last night, I tried it and simply got in 
over my head. This is a decent short-term solution.


b. Can we work together to lay out the steps to set up an alternative 
back end? I'm going to start on sqlite, Others may wish to work on a 
different db engine. Then let's get the procedure out where it can be 
seen and used by others.


c. Let's get altruistic about the poor bloke who, this morning, is about 
to set up a Base db using a java-run backend: Could someone put a notice 
in the documentation updating people about the current situation? It's 
not right for us to keep this information only on this list.


Now I'm off to fully regress my java (I don't see a problem with this), 
while I work on getting sqlite and Base to play together.


Tom

On 07/28/2011 09:16 AM, Don C. Myers wrote:

Hi Tom,

When the first problems showed up for me about 6 months ago, it was 
recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my 
database on 4 computers, and could never make things work with getting 
a previous version installed, so I gave up and just tolerated the 
situation. Also, I had security concerns going backwards since, as I 
understand it, among other things updated Java versions have have 
security issues fixed. I'm relatively good with Ubuntu, but far from 
an expert. What we all know is that Java is the problem. Can someone 
give us instructions on how to use the LibreOffice front end with a 
database that doesn't require Java. I see that you had said that 
LibreOffice may be moving to sqlite? Is that a solution that anyone 
could help us with?


Don

On 07/28/2011 04:04 AM, Tom Cloyd wrote:

, On 07/28/2011 12:53 AM, Tom Cloyd wrote:

On 07/28/2011 12:44 AM, Alexander Thurgood wrote:

Le 27/07/11 18:14, Tom Cloyd a écrit :


That command appears to have cut 5 seconds off the record pointer 
move

test, and also off the full db search test I ran previously.

Well better than nothing I suppose, but I do sympathise. Did the 
JDK/JRE

change suggested by someone else help any further ?


Alex



Am just about to make the switch - will let you know asap! I'm very 
hopeful. And I've decided to switch to sqlite when I'm not so 
rushed. Have heard that that's where LO's going anyway.


Tom

Ug. This is getting ugly really fast. I'm really not on home ground  
here at all.


After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I 
downloaded

sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and

sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi :)
I agree too but i think we have to agitate to get something done.  So far the 
only response i got was an unhelpful RMS quote.  I have a Gandhi one  "First 
they ignore you, then they laugh at you, then they fight you, then you win.".  
Which means we have all 4 steps to work through but since some fairly major 
companies would benefit it might be possible to get through most of those steps 
quite fast.  


Could TDF join
http://montyprogram.com/commercial/
Would that help?

TDF is not the type of organisation where we wait to see what "they" do.  It's 
up to us to work out what we need and from who and go get it.
Regards from
Tom :)




From: Tom Cloyd 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 17:06:15
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Heinz,

I completely agree. LO without a function Base won't fly. Either TDF recognizes 
this - by DOING something - or we have our answer.

Tom

On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote:
> Hallo Andreas,
> In my view, BASE "falling apart" would mean LO's "death sentence" in the long
> run! Anybody in even the simplest business environment will want to write
> documents based on data stored in business-critical databases (and I think I
> am right in assumung that relational DBs have been the standard now for 
>decades!).
> Does anybody REALLY think that a package like LO can survive if it ignores
> such an important sector of users? I sure don't!!!
> Gruesse aus Salzburg
> Heinz
> 
> 
> On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger  
wrote:
> 
>> Am 28.07.2011 08:15, Heinrich Stoellinger wrote:
>>> I am not giving up hope yet for LO 3.4.2 - especially since it targets
>>> business...
>>> Isn't there a OpenSource fork of MySQL called MariaDB?!?
>>> Regards
>>> H
>>> 
>> 
>> Dear Heinrich,
>> 
>> Face it: There is not a single LO developer doing anything Base related.
>> The Base component will fall apart sooner or later. Writer's mail merge
>> and bibliography will be spreadsheets, form controls will be mere
>> gimmicks and nobody except you and me and some hundreds of professionals
>> will notice the severe loss.
>> 
>> Grüße aus NRW,
>> Andreas
>> 
>> 
> 
> 


-- 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
-- 
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 record access unacceptably slow

2011-07-28 Thread Paul D. Mirowsky
Has anybody suggested that this command should an option when saving 
when ever records are deleted?


On 7/27/2011 12:14 PM, Tom Cloyd wrote:

SHUTDOWN COMPACT


--
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 record access unacceptably slow

2011-07-28 Thread Don C. Myers

Hi,

Different ones of us have tried this. It is a Java issue. I keep my 
database compacted on a regular basis. Thank you for trying to be of 
assistance.


Don

On 07/28/2011 12:45 PM, Paul D. Mirowsky wrote:
Has anybody suggested that this command should an option when saving 
when ever records are deleted?


On 7/27/2011 12:14 PM, Tom Cloyd wrote:

SHUTDOWN COMPACT




--

***
*


--
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 record access unacceptably slow

2011-07-28 Thread Andy Brown

Tom Cloyd wrote:

< much clipped to save space >


2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache
in this situation? Again, where's *TDF*? Why aren't they and Apache
working together on this? Looks rather like a leadership problem, to me.



Tom,  the other points I can not speak to but Apache does not have the 
code to work with yet.  There are people working on getting it so that 
work can get started.  Base is one of the problem areas that I plan to 
help work on, maybe a move to another DB engine is the answer.


As side note: There are sections on the two forums for base tutorials.

[1] http://user.services.openoffice.org/en/forum/viewforum.php?f=83
[2] http://www.oooforum.org/forum/viewforum.phtml?f=10

I am no expert on Base so can not say how much the links will help but 
hopefully they will help some.


Andy

--
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 record access unacceptably slow

2011-07-28 Thread Jean-Francois Nifenecker

Hi,

Le 28/07/2011 18:10, Heinrich Stoellinger a écrit :

In my view LO/OO do NOT require Java, neither on Linux nor on Windows.


AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF 
have announced they would get rid of the java-isms in the code. This 
implies a major rewrite of Base, though.


--
Jean-Francois Nifenecker, Bordeaux

--
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 record access unacceptably slow

2011-07-28 Thread Don C. Myers

Hi Tom,

Thank you for your great ideas and suggestions.

Starting with Java 1.6.0_24, this problem arose with both OpenOffice 
Base and LibreOffice Base. The problems were documented on an OpenOffice 
forum that I searched when the problem first arose. Another alternative 
would be for LibreOffice to have its own embedded version of Java that 
works instead of using the system Java. One person a month or so ago 
posted here as to the exact reason the issue has happened. He felt the 
problem would be corrected when Java was again updated. I was greatly 
disappointed when 1.6.0_26 came out and the issue was still here. My 
data base has about 2500 entries with complete contact information, and 
then a separate text area I use to keep a running record of my contacts 
with each person. Before Java 1.6.0_24 going from the first record to 
last last record was almost instantaneous. Now if is painful. I wait 
patiently for the 20 to 25 seconds for it to happen on my fastest 
computer, a quad core AMD 910 with 8 gigs of ram. It is slower on my 
other ones. Then paging backwards through the database, I can click 5 
records and each one appears instantly, then before the 6th record there 
is a pause. This happens consistently. 5 records, pause, 5 records, 
pause. I need a database. I need one that works proficiently in Linux. I 
was so glad when Base was added to OpenOffice. I used it for years 
without issue until about 6 months ago.


Don

On 07/28/2011 12:22 PM, Tom Cloyd wrote:

Don,

Seems like a reasonable request to me, and I'll up the ante.

Where the &^%$ is the management - The Document Foundation - in all 
this, right now, today? Do they even watch this list? In short, do 
they give a damn that the only theoretically viable alternative to 
Access (for ordinary users) is in real trouble? Why aren't they 
showing up here with some clarifying position statement?


I'm desperate for time, a fix, and vision of a long-term solution to 
this mess. I have work to do today, a lot of it, and I can't do it. I 
can't solve the problem, and other than by implementing the 
regress-your-java solution idea (which I have yet to be successful 
with). No one else is solving it, either. For some, migrating to 
another backend is not a challenge. For the rest of us, it's unknown 
territory. I researched this a bit, and while there certainly IS stuff 
out there about how to do it, there's not a lot, and there are 
multiple levels of challenge with this solution anyway.


Personally, I'm definitely up for taking this on (what option do I 
really have?), but do we really have to straggle through the mountains 
one by one, eventually meeting on the other side, those who make it, 
to talk about the experience?


So, I propose two things:

1. Anyone who has TDF connections - please get on the phone and update 
them. The question is this, I think: how important, going forward, is 
Base, to them? If they are going to support it, today would be a very 
good day to do it. If not, yank the code, stop telling people they 
have a db component in LO, and start getting honest.


2. If LO's in trouble with the current sun-Java, so's OO. Where's 
Apache in this situation? Again, where's *TDF*? Why aren't they and 
Apache working together on this? Looks rather like a leadership 
problem, to me.


2. On the assumption that those of use who need a working db are going 
to have to find the way home ourselves (as I said, I need to get work 
done TODAY, and I'm not kidding) -


a. Can someone more Linux-clever than I lay out clearly the steps 
involve in implementing the solution found at the end of this thread - 
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0 
. 
As I pointed on in another post last night, I tried it and simply got 
in over my head. This is a decent short-term solution.


b. Can we work together to lay out the steps to set up an alternative 
back end? I'm going to start on sqlite, Others may wish to work on a 
different db engine. Then let's get the procedure out where it can be 
seen and used by others.


c. Let's get altruistic about the poor bloke who, this morning, is 
about to set up a Base db using a java-run backend: Could someone put 
a notice in the documentation updating people about the current 
situation? It's not right for us to keep this information only on this 
list.


Now I'm off to fully regress my java (I don't see a problem with 
this), while I work on getting sqlite and Base to play together.


Tom

On 07/28/2011 09:16 AM, Don C. Myers wrote:

Hi Tom,

When the first problems showed up for me about 6 months ago, it was 
recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my 
database on 4 computers, and could never make things work with 
getting a previous version installed, so I gave up and just tolerated 
the situation. Also, I had security concerns going backwards

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd

I'm up for it! (Love that quote!)

Maybe leaking this issue to the press would get some attention??

Tom C.

On 07/28/2011 10:29 AM, Tom Davies wrote:

Hi :)
I agree too but i think we have to agitate to get something done.  So far the
only response i got was an unhelpful RMS quote.  I have a Gandhi one  "First
they ignore you, then they laugh at you, then they fight you, then you win.".
Which means we have all 4 steps to work through but since some fairly major
companies would benefit it might be possible to get through most of those steps
quite fast.


Could TDF join
http://montyprogram.com/commercial/
Would that help?

TDF is not the type of organisation where we wait to see what "they" do.  It's
up to us to work out what we need and from who and go get it.
Regards from
Tom :)




From: Tom Cloyd
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 17:06:15
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Heinz,

I completely agree. LO without a function Base won't fly. Either TDF recognizes
this - by DOING something - or we have our answer.

Tom

On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote:

Hallo Andreas,
In my view, BASE "falling apart" would mean LO's "death sentence" in the long
run! Anybody in even the simplest business environment will want to write
documents based on data stored in business-critical databases (and I think I
am right in assumung that relational DBs have been the standard now for
decades!).
Does anybody REALLY think that a package like LO can survive if it ignores
such an important sector of users? I sure don't!!!
Gruesse aus Salzburg
Heinz


On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger

wrote:

Am 28.07.2011 08:15, Heinrich Stoellinger wrote:

I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H


Dear Heinrich,

Face it: There is not a single LO developer doing anything Base related.
The Base component will fall apart sooner or later. Writer's mail merge
and bibliography will be spreadsheets, form controls will be mere
gimmicks and nobody except you and me and some hundreds of professionals
will notice the severe loss.

Grüße aus NRW,
Andreas






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



--
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] Shrinking buttons

2011-07-28 Thread Bill Gradwohl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have a spreadsheet containing 39 sheets, of which 21 are duplicates of
one another. They represent tables in a restaurant.

On an average laptop or desktop, everything is fine. When I load this up
on a netbook with lousy resolution (1024x600), every time I save the
file, the buttons on the 21 sheets get smaller and smaller till they
some of them have a height of .06cm making them unusable. I leave the
screen scaling at 100%.

I manually went thru 10 of the sheets and using the forms control tool
reset each button to its proper dimensions. Everything looked good as I
went from sheet to sheet. I saved the file and brought it back up and
the height that was .50cm is now .33cm or .31cm. Why they are different
is a mystery. Another save and reload AND SOME OF THE BUTTONS are
smaller still.

I have no code that attempts to manipulate the buttons, so I conclude
that LO is making the changes, and is making these changes permanent
across saves. If I move the file back to my development laptop, its trashed.

I understand scaling due to resolution issues, but rewriting my code
permanently has got to be a bug.

I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice.
Both display the identical problem.

I can supply additional details, as the whole story has some additional
twists, but I'd like to know if this will be taken as a serious issue.



- -- 
Bill Gradwohl
Roatan, Honduras
504 9 899 2652
IM:billgradw...@gmail.com (No email please-IM only)
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP
0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm
=0qkh
-END PGP SIGNATURE-

-- 
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 record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi :)
I think it's more a case of working on several fronts within TDF.  
1.   joining the Steering-Discuss mailing list and promoting the cause there.  
2.   working out a few large organisations that could put resources towards it. 
 
What would they gain?  Canonical (of Ubuntu fame) and RedHat might reduce a 
"blocker" that stops people from leaving Windows.  Google migth gain an 
OpenSource database that they could adapt to add to their Cloud initiative, 
Google-Docs.  All three would increase the level of support they could sell to 
companies and perhaps even to individuals.  Support contracts are one of the 
main money spinners in OpenSource.  

3.  find places where devs are.  Preferably ones that are familiar with working 
on database issues and see if we can encourage some to work on Base.  But they 
would have to be happy about releasing the code under copy-left rather than 
copyright agreements to keep things OpenSource.  There might be other 
OpenSource 
programs that rely on Base in some way that might be willing to encourage some 
of their devs to take the opportunity to steer things in a useful direction for 
their needs.  


Errr, some of these ideas might be daft and i am very likely missing some other 
positive directions.  As for the press it's better if outsiders see TDF in a 
positive light so that people are attracted to the quagmire that is Base and 
pleased to join in and fix it.
Regards from
Tom :)







From: Tom Cloyd 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 18:16:57
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

I'm up for it! (Love that quote!)

Maybe leaking this issue to the press would get some attention??

Tom C.

On 07/28/2011 10:29 AM, Tom Davies wrote:
> Hi :)
> I agree too but i think we have to agitate to get something done.  So far the
> only response i got was an unhelpful RMS quote.  I have a Gandhi one  "First
> they ignore you, then they laugh at you, then they fight you, then you win.".
> Which means we have all 4 steps to work through but since some fairly major
> companies would benefit it might be possible to get through most of those 
steps
> quite fast.
>
>
> Could TDF join
> http://montyprogram.com/commercial/
> Would that help?
>
> TDF is not the type of organisation where we wait to see what "they" do.  It's
> up to us to work out what we need and from who and go get it.
> Regards from
> Tom :)
>
>
>
> 
> From: Tom Cloyd
> To: users@global.libreoffice.org
> Sent: Thu, 28 July, 2011 17:06:15
> Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow
>
> Heinz,
>
> I completely agree. LO without a function Base won't fly. Either TDF 
recognizes
> this - by DOING something - or we have our answer.
>
> Tom
>
> On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote:
>> Hallo Andreas,
>> In my view, BASE "falling apart" would mean LO's "death sentence" in the long
>> run! Anybody in even the simplest business environment will want to write
>> documents based on data stored in business-critical databases (and I think I
>> am right in assumung that relational DBs have been the standard now for
>> decades!).
>> Does anybody REALLY think that a package like LO can survive if it ignores
>> such an important sector of users? I sure don't!!!
>> Gruesse aus Salzburg
>> Heinz
>>
>>
>> On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger
> wrote:
>>> Am 28.07.2011 08:15, Heinrich Stoellinger wrote:
 I am not giving up hope yet for LO 3.4.2 - especially since it targets
 business...
 Isn't there a OpenSource fork of MySQL called MariaDB?!?
 Regards
 H

>>> Dear Heinrich,
>>>
>>> Face it: There is not a single LO developer doing anything Base related.
>>> The Base component will fall apart sooner or later. Writer's mail merge
>>> and bibliography will be spreadsheets, form controls will be mere
>>> gimmicks and nobody except you and me and some hundreds of professionals
>>> will notice the severe loss.
>>>
>>> Grüße aus NRW,
>>> Andreas
>>>
>>>
>>
>
> -- 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


-- 
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
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd
Once again I find myself agreeing with you, on all fronts. I'm also 
keenly aware that I'm maxed out right now and must first get my db 
running (via java regression) then get some work done. Hours I don't 
have have been lost this morning trying to decide what to do about all 
this, and I must get something moving forward, immediately.


Will return.

Tom C

On 07/28/2011 12:02 PM, Tom Davies wrote:

Hi :)
I think it's more a case of working on several fronts within TDF.
1.   joining the Steering-Discuss mailing list and promoting the cause there.
2.   working out a few large organisations that could put resources towards it.
What would they gain?  Canonical (of Ubuntu fame) and RedHat might reduce a
"blocker" that stops people from leaving Windows.  Google migth gain an
OpenSource database that they could adapt to add to their Cloud initiative,
Google-Docs.  All three would increase the level of support they could sell to
companies and perhaps even to individuals.  Support contracts are one of the
main money spinners in OpenSource.

3.  find places where devs are.  Preferably ones that are familiar with working
on database issues and see if we can encourage some to work on Base.  But they
would have to be happy about releasing the code under copy-left rather than
copyright agreements to keep things OpenSource.  There might be other OpenSource
programs that rely on Base in some way that might be willing to encourage some
of their devs to take the opportunity to steer things in a useful direction for
their needs.


Errr, some of these ideas might be daft and i am very likely missing some other
positive directions.  As for the press it's better if outsiders see TDF in a
positive light so that people are attracted to the quagmire that is Base and
pleased to join in and fix it.
Regards from
Tom :)







From: Tom Cloyd
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 18:16:57
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

I'm up for it! (Love that quote!)

Maybe leaking this issue to the press would get some attention??

Tom C.

On 07/28/2011 10:29 AM, Tom Davies wrote:

Hi :)
I agree too but i think we have to agitate to get something done.  So far the
only response i got was an unhelpful RMS quote.  I have a Gandhi one  "First
they ignore you, then they laugh at you, then they fight you, then you win.".
Which means we have all 4 steps to work through but since some fairly major
companies would benefit it might be possible to get through most of those

steps

quite fast.


Could TDF join
http://montyprogram.com/commercial/
Would that help?

TDF is not the type of organisation where we wait to see what "they" do.  It's
up to us to work out what we need and from who and go get it.
Regards from
Tom :)




From: Tom Cloyd
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 17:06:15
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Heinz,

I completely agree. LO without a function Base won't fly. Either TDF

recognizes

this - by DOING something - or we have our answer.

Tom

On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote:

Hallo Andreas,
In my view, BASE "falling apart" would mean LO's "death sentence" in the long
run! Anybody in even the simplest business environment will want to write
documents based on data stored in business-critical databases (and I think I
am right in assumung that relational DBs have been the standard now for
decades!).
Does anybody REALLY think that a package like LO can survive if it ignores
such an important sector of users? I sure don't!!!
Gruesse aus Salzburg
Heinz


On Thu, 28 Jul 2011 12:18:49 +0200, Andreas Säger

wrote:

Am 28.07.2011 08:15, Heinrich Stoellinger wrote:

I am not giving up hope yet for LO 3.4.2 - especially since it targets
business...
Isn't there a OpenSource fork of MySQL called MariaDB?!?
Regards
H


Dear Heinrich,

Face it: There is not a single LO developer doing anything Base related.
The Base component will fall apart sooner or later. Writer's mail merge
and bibliography will be spreadsheets, form controls will be mere
gimmicks and nobody except you and me and some hundreds of professionals
will notice the severe loss.

Grüße aus NRW,
Andreas



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





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

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 18:22, Tom Cloyd a écrit :

Hi Tom,


> Where the &^%$ is the management - The Document Foundation - in all
> this, right now, today? Do they even watch this list? In short, do they
> give a damn that the only theoretically viable alternative to Access
> (for ordinary users) is in real trouble? Why aren't they showing up here
> with some clarifying position statement?

Been there, seen it, done that. The clarifying statements of opinion I
have had from the developers - they are after the all the ones that
write the code, either as volunteers and/or paid employees, are those
that Michael Meeks has expressed (albeit in other words). If you, as a
user, want Base to be actively supported, corrected, developed...then
sign up to a commercial support contract where your concerns will be
taken as a business case user by that support company, be it Novell,
Suse, Redhat, Lanedo, or whoever else might be in that loop. I would
actually probably pay for support if I knew that it would go towards
fixing the things I want fixed in Base. However, the support contracts
being offered are, to my knowledge, general support for the whole of the
suite, not specifically oriented to Base as such, in fact some of them
are even more general than that, i.e OS-support based, and some of them
are rather pricy. Again, price would probably not be an issue if I was
guaranteed that the money would go to paying someone to develop on Base.


History calls :
If one looks back to how the current HSQLDB came to be in Base, this was
only due to the fact that Sun helped pay Fred Toussi (the guy who
developed HSQLDB) to help them integrate it into OOo - otherwise it was
a non-starter. Fred also had donations from the community to help get
the work done.

So there you go, even back then, Base would not have become what it is
today without independent funding of development. Perhaps, a new set of
funding is indeed what is required to bring about changes in Base as it
is now, and develop for the future.


> 
> I'm desperate for time, a fix, and vision of a long-term solution to
> this mess. I have work to do today, a lot of it, and I can't do it. I
> can't solve the problem, and other than by implementing the
> regress-your-java solution idea (which I have yet to be successful
> with). No one else is solving it, either. For some, migrating to another
> backend is not a challenge. For the rest of us, it's unknown territory.
> I researched this a bit, and while there certainly IS stuff out there
> about how to do it, there's not a lot, and there are multiple levels of
> challenge with this solution anyway.

Well, I jumped onto the mysql bandwagon very early on, before Base 2
even came into being. As Heinz has said ODBC worked fairly well even
back then and it was lightning fast. Unfortunately, things are not going
so smoothly with that solution for me now on OSX, where I can't get it
to work, even with a commercial paid-up ODBC driver.

Sun also came along and developed the mysql connector extension. This
actually still works fairly well for me, but none of the developers are
building it and making it available on the extensions site, which is
what Sun used to do each time a new version of OOo was released. There
has not been one single release of the connector extension by the
LibreOffice project since its inception. After enquiring over at the
Apache OOo project, the mysql is not part of the software grant from
Oracle, and so because the libmysql library is GPL code, it can't be
included in the Apache repositories and therefore the connector
extension will not be built and hosted by the Apache project. In other
words, unless someone else independently and repeatedly builds andhosts
the connector for each new version of OOo/LibO that comes out, and for
each platform, even the native mysql connector is doomed.

The other alternative to MyODBC or the native connector : JDBC
Connector, but again, this is not without several major problems,
including performance from within LibO, and date string management, and
blob and object management and, and...all of which are problems that
mysql (now Oracle) were aware of and never bothered to fix.

Anyway, other avenues are out there, I am exploring them as I speak,
because I'm not going to keep flogging a dead horse for much longer. If
it can be shown that its not actually dead, then I'm all for helping out
testing, documenting, etc, but if TDF itself is not prepared to clearly
show that this module is one of its centres and remain true to its
declaration of "protecting the investments of the past 10 years", I'm at
a loss to see what difference my willingness will make.


Alex





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

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi :)

Apache are far behind TDF in this.  They are about where TDF was about 11 
months 
ago; with no infrastructure and bloated code filled with nonsense entangling 
the  
useful stuff.

TDF is not  traditional hierarchical organisation where "they" run things and 
"we" wait for "them" to do stuff.  There is no "them" and "us" there is only 
"us" and "some more of us".  We need some of us that have experience and 
knowledge about databases to join in with management levels by joining 
Steering-Discuss and finding ways to manage a drive forwards for Base.  We need 
to manage this not sit&wait.  


Regards from
Tom :)





From: Andy Brown 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 17:57:32
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Tom Cloyd wrote:

< much clipped to save space >

> 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache
> in this situation? Again, where's *TDF*? Why aren't they and Apache
> working together on this? Looks rather like a leadership problem, to me.
> 

Tom,  the other points I can not speak to but Apache does not have the code to 
work with yet.  There are people working on getting it so that work can get 
started.  Base is one of the problem areas that I plan to help work on, maybe a 
move to another DB engine is the answer.

As side note: There are sections on the two forums for base tutorials.

[1] http://user.services.openoffice.org/en/forum/viewforum.php?f=83
[2] http://www.oooforum.org/forum/viewforum.phtml?f=10

I am no expert on Base so can not say how much the links will help but 
hopefully 
they will help some.

Andy

-- 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
-- 
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: Connect ODBC / JDBC Firebird database - LibreOffice 3.3.3 - Windows XP

2011-07-28 Thread Giovanni Romero Pérez
Hi, Alex!

Thank you very much. I did what you said and all is OK.

Since the Firebird server is on Windows, the string to connect is:

firebirdsql:servername/3050:C:\\FOLDER\\DATABASE.FDB

Thank you again.

GIOVANNI ROMERO PÉREZ

-Mensaje original-
De: Alexander Thurgood [mailto:alex.thurg...@gmail.com] 
Enviado el: Jueves, 28 de Julio de 2011 05:17 a.m.
Para: users@global.libreoffice.org
Asunto: [libreoffice-users] Re: Connect ODBC / JDBC Firebird database -
LibreOffice 3.3.3 - Windows XP

Le 28/07/11 01:14, Giovanni Romero Pérez a écrit :

Hi Giovanni,


> Then I created a database in Base and did the settings to connect to the
> database using the ODBC source. The connection is OK, but when I try to
> Access to a table or run a query, Base throws this message:
> 
> --
> No se pudieron cargar los contenidos de los datos.
> Fetch type out of range
> --
> 
> And I can not see the results.

>From what I remember of other people's attempts to connect using ODBC,
this is currently not working with LibreOffice (or even OpenOffice.org
for that matter).

> 
> I thought about using JDBC, as I have read that allows you to connect more
> easily. The problem is that I don't find documentation to configuring
> Firebird JDBC connector (called Jaybird and available at
> http://www.firebirdsql.org/en/jdbc-driver).

You have to first declare the JDBC JAR within LibreOffice so that it
knows where to look to find it.

1) Menu Tools - Options - LibreOffice - Java

wait for it to detect your Java installation(s), select the one that you
want as required (if you have a choice).

2) Click on the button "Classpath", then on the button "Add archive".

3) Navigate using the file picker dialog to where your JAR file is
located, select it, then click on OK. It should then appear in the list
of added java archives.

4) Click on OK to quit the Java configuration dialog.

5) Shut down LibreOffice, including any quickstarter (icon in the tray
at the bottom right of your screen)

6) Restart LibreOffice

7) Click on File - New - Database

8) Choose "Connect to an existing Database" and select "JDBC" from the
driver selection list.

9) In the JDBC setup fields :

Datasource URL :
firebirdsql://servername:port//path/to/db/location/dbname.fdb

JDBC driver class : org.firebirdsql.jdbc.FBDriver


Note that these last two parameters I obtained from this page :

http://www.insttech.washington.edu/~lab/Support/HowtoUse/UsingJDBCWithFirebi
rd.html

I don't actually have a firebird server running to be able to test.



Alex




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


-- 
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 record access unacceptably slow

2011-07-28 Thread Tom Davies
Hi :)
It might be a good idea to post a bug-report
http://wiki.documentfoundation.org/BugReport
I think the guide helps you look-up to see if there is already a bug-report 
about it but if you don't have time for that just post the reoprt and worry 
about it later.  Triagers can mark bugs as duplicates quite quickly when they 
are on a roll.  

Regards from
Tom :)





From: Paul D. Mirowsky 
To: users@global.libreoffice.org
Sent: Thu, 28 July, 2011 17:45:05
Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow

Has anybody suggested that this command should an option when saving when ever 
records are deleted?

On 7/27/2011 12:14 PM, Tom Cloyd wrote:
> SHUTDOWN COMPACT

-- 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
-- 
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] Doubt about digital signature

2011-07-28 Thread Grasiela Peccini
Hi Alex, Tom

I'm using Windows XP and the user information is correctly stored...

Regards,
Grasip.

On Thu, Jul 28, 2011 at 1:12 PM, Tom Davies  wrote:

> Hi :)
> Do you have any personal info stored in
> Tools - Options - LibreOffice - UserData
> I seem to remember some weird bug about this sort of thing not working
> unless
> there was some personal data in there?  Even if it's fictitious or so
> generic
> that it doesn't get traced back you you as an individual it seemed to help
> with
> something like this a few months ago.
>
> I could be wrong as Jay brilliantly fixed the problem last time so this is
> probably some other issue
> Regards from
> Tom :)
>
>
>
>
> 
> From: planas 
> To: users@global.libreoffice.org
> Sent: Wed, 27 July, 2011 23:54:27
> Subject: Re: [libreoffice-users] Doubt about digital signature
>
> Hi Grasiela,
>
> On Wed, 2011-07-27 at 12:00 -0300, Grasiela Peccini wrote:
>
> > Hi,
> > I need information about digital signature. I don't know if i'm working
> with
> > a bug or it's a normal behavior of LibreOffice.
> > The steps:
> > 1- User saves a document and signs it, when is requested the PIN
> > 2 - User makes changes on the document, saves it and signs it again
> > 3 - Here is the point. The PIN is no longer requested. A new request is
> made
> > only when the smart card is removed from the reader or when the
> LibreOffice
> > is closed and reopened.
> > I'm using LibreOffice 3.3.0, on Windows XP. I've done the same test on
> > LibreOffice 3.4, with the same results.
> > Thanks a lot,
> > Grasip.
> >
> > --
> > "Eu quase nada sei, mas desconfio de muita coisa."
> >   Guimarães Rosa
> >
>
> Are saving the document with a password using FILE>>SAVE AS and
> selecting "Save with Password"?
>
> When I tested this with file with a password, I was asked for it every
> time I opened the file. I do not use a smart card so the behavior may be
> caused by the smart card.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
> --
> 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
>
> --
> 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
>
>


-- 
"Eu quase nada sei, mas desconfio de muita coisa."
  Guimarães Rosa

-- 
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 record access unacceptably slow

2011-07-28 Thread planas
Heinrich,

On Thu, 2011-07-28 at 08:15 +0200, Heinrich Stoellinger wrote: 

> Hi Tom,
> Just my - maybe naive - 2 pennies worth of comments:
> As I mentioned before, I have been using OO/LO for years together with
> BASE with MySQL (which - also "sigh") now "belongs" to Oracle as well.
> As a connector to the DB I have tried out the Java version (always had
> trouble with it one way or the other!) as well as ODBC/UNIXODBC (which
> is what I am now using under Linux and which works sort of!). With
> MySQL there is also the native connector which I would actually prefer
> to use - but, yes you guess right - does NOT work on either LO 3.3.3 or
> 3.4.1 under Linux. A bit confusing, isn't it!
> I am not giving up hope yet for LO 3.4.2 - especially since it targets
> business...
> Isn't there a OpenSource fork of MySQL called MariaDB?!?
> Regards
> H


MariaDB is an OSS fork of MySQL, it is available from the Ubuntu
repositories, I assume Debian and other Linux distros.

It apparently is only available for Linux and Windows, no Mac version
listed on their downloads. Their homepage is > mariadb.org



> 
> On Thu, 28 Jul 2011 00:19:26 +0200, Tom Cloyd  wrote:
> 
> > Thanks, Andreas.
> >
> > To summarize what I learned from that second link: I need to install
> > sun-java6-jre_6.22-0ubuntu1~10.04 into a directory of my choosing, then
> > direct LO to use this special older version (which, it is reported, does
> > not cause the awful slowdown we're experiencing).
> >
> > Look like a short-term solution I can live with. Give me hope that I get
> > back to work, later today
> >
> > The long-term solution appears entirely opaque, however. Is the problem
> > being reported to Oracle (who I presume is behind the latest sun-java
> > updates). Is this an Oracle plot to blow OO and LO opensource dbs out of
> > the water?
> >
> > Is there any hope we can cut this dependancy upon a java version that is
> > now associated with Oracle?
> >
> > Sigh.
> >
> > Tom
> >
> > On 07/27/2011 02:26 AM, Andreas Säger wrote:
> >> The Base documentation:
> >> http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial
> >>
> >>
> >> My chrystal ball tells me that you run LibreOffice with a recent Java
> >> version under Linux, therefore this is the solution to your problem:
> >> http://www.oooforum.org/forum/viewtopic.phtml?t=125253
> >>
> >>
> >
> >
> 
> 
> -- 
> Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
> 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
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] Shrinking buttons

2011-07-28 Thread planas
Biil

On Thu, 2011-07-28 at 10:57 -0600, Bill Gradwohl wrote: 

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> I have a spreadsheet containing 39 sheets, of which 21 are duplicates of
> one another. They represent tables in a restaurant.
> 
> On an average laptop or desktop, everything is fine. When I load this up
> on a netbook with lousy resolution (1024x600), every time I save the
> file, the buttons on the 21 sheets get smaller and smaller till they
> some of them have a height of .06cm making them unusable. I leave the
> screen scaling at 100%.
> 
> I manually went thru 10 of the sheets and using the forms control tool
> reset each button to its proper dimensions. Everything looked good as I
> went from sheet to sheet. I saved the file and brought it back up and
> the height that was .50cm is now .33cm or .31cm. Why they are different
> is a mystery. Another save and reload AND SOME OF THE BUTTONS are
> smaller still.
> 
> I have no code that attempts to manipulate the buttons, so I conclude
> that LO is making the changes, and is making these changes permanent
> across saves. If I move the file back to my development laptop, its trashed.
> 
> I understand scaling due to resolution issues, but rewriting my code
> permanently has got to be a bug.
> 
> I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice.
> Both display the identical problem.
> 
> I can supply additional details, as the whole story has some additional
> twists, but I'd like to know if this will be taken as a serious issue.


Please file a bug, I do not what the issue is. I have never seen any
behavior like this myself. 

If you could give more details may be (very may be) someone monitoring
the list may know what is happening. 

> 
> 
> - -- 
> Bill Gradwohl
> Roatan, Honduras
> 504 9 899 2652
> IM:billgradw...@gmail.com (No email please-IM only)
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.11 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
> 
> iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP
> 0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm
> =0qkh
> -END PGP SIGNATURE-
> 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
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] Shrinking buttons

2011-07-28 Thread webmaster for Kracked Press Productions


I wonder if there is some code that tries to match the image sizes to 
the resolution of the screen.  Since the resolution you state on the 
netbook seems to be a non-standard, the system cannot figure out what is 
what.


I do not know if that is correct, but it seems to me that there is 
something in the file that deals with screen size/resolution.


On 07/28/2011 12:57 PM, Bill Gradwohl wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have a spreadsheet containing 39 sheets, of which 21 are duplicates of
one another. They represent tables in a restaurant.

On an average laptop or desktop, everything is fine. When I load this up
on a netbook with lousy resolution (1024x600), every time I save the
file, the buttons on the 21 sheets get smaller and smaller till they
some of them have a height of .06cm making them unusable. I leave the
screen scaling at 100%.

I manually went thru 10 of the sheets and using the forms control tool
reset each button to its proper dimensions. Everything looked good as I
went from sheet to sheet. I saved the file and brought it back up and
the height that was .50cm is now .33cm or .31cm. Why they are different
is a mystery. Another save and reload AND SOME OF THE BUTTONS are
smaller still.

I have no code that attempts to manipulate the buttons, so I conclude
that LO is making the changes, and is making these changes permanent
across saves. If I move the file back to my development laptop, its trashed.

I understand scaling due to resolution issues, but rewriting my code
permanently has got to be a bug.

I tested this on Fedora 14 as OpenOffice and Fedora 15 as LibreOffice.
Both display the identical problem.

I can supply additional details, as the whole story has some additional
twists, but I'd like to know if this will be taken as a serious issue.



- -- 
Bill Gradwohl

Roatan, Honduras
504 9 899 2652
IM:billgradw...@gmail.com (No email please-IM only)
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk4xlOkACgkQ7Orvev+eC8pjqQCbBadkTrBEznB0UjH8OAM/qRAP
0mwAoLEXYNCs9dYHwuo4DZZDqqfI+WSm
=0qkh
-END PGP SIGNATURE-




--
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 record access unacceptably slow

2011-07-28 Thread Cor Nouws

Hi Tom,

Tom Cloyd wrote (28-07-11 18:06)


I completely agree. LO without a function Base won't fly. Either TDF
recognizes this - by DOING something - or we have our answer.


Well, the challenges with base are known. This does not mean that there 
is an instant solution. However the fast growing support for TDF and 
from interested people with developing skills, make that there are 
reasons for some optimism :-)
Maybe the LibreOffice conference or another hackers event is a good 
opportunity too to make so first steps,  share experience ...


Regards,
Cor

--
 - Cor
 - http://nl.libreoffice.org


--
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] Calc row filter extraction

2011-07-28 Thread Hylton Conacher (ZR1HPC)
Hi all,

I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1
with multiple columns and different information in each column. Please
see the text example I include below.

What I would ideally like to do is have rows on sheet A, where Column D
is the same, linked onto another sheet(B). My next requirement is to
group all the like column B on sheet B, C and link them onto sheet D but
group them according to column B and SUM the amounts from sheets B, C.

I have included a brief text example below:

Sheet A
A   B   C   D   E
20-July SVP SBP Robert  200
20-July STP SPG Hazel   100
21-July STP SBP Robert  180
22-July SVP SBP Robert  50
23-July STP SBP Hazel   400

Sheet B
A   B   C   D   E
20-July SVP SBP Robert  200
21-July STP SBP Robert  180
22-July SVP SBP Robert  50

Sheet C
A   B   C   D   E
20-July STP SPG Hazel   100
23-July STP SBP Hazel   400

Sheet D
A   B   C   D   E
STP SBP Robert  100
STP SBP Hazel   500
SVP SBP Robert  250

I have done some googling regarding row extraction and have also
investigated the SUMIF command. and whilst I can get a total of all the
STP's, I cannot SUM it by user at STP.
The SUMD command has also raised its head but I cannot figure out how to
get it to work in conjunction with SUMIF.

Any help appreciated, even telling me MySQL is a better option. My
problem is that the data is Sheet A is ever growing and being edited by
a basic Excel user, and sheets b->D need to reflect those changes made
on sheet A.

Again, Any Help Appreciated
-- 

Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO


-- 
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: (help macro base)Open form with a button form another form with filter

2011-07-28 Thread rogerio dandrea
Hi

Sorry if this is a silly question but, how do I switch the focus from one
form to another?

Thanks

2011/7/28 Alexander Thurgood 

> Le 28/07/11 15:40, rogerio dandrea a écrit :
>
> Hi Rogerio,
>
>
> >
> >  ThisDatabaseDocument.FormDocuments.getByName( "animal3" ).open
> >
> >   odoc=thiscomponent
> >  oform=odoc.drawpage.forms.getbyindex(0)
> >
> >   'define o filtro para achar os registros
> >
> >  sfilter =  chr(34) & "Cad" & chr(34) & chr(61) & myindex
> >  print sfilter
> >  oform.filter = sfilter
> >  oform.applyfilter= True
> >  oform.reload  ' recarrega o formulario com o filtro pelo na
> > teoria pois não esta funcionando
> >   'reload the form with the filter apply
> > dont work
> >
>
> I could be wrong here, but you could try setting the focus on one of
> this form's controls before attempting to reload, or alternatively you
> might find you have to reload the first form that was opened in order to
> get the second one to update. From memory, I think that there was a
> discussion about this on the old OpenOffice.org dba discuss or user list.
>
>
> Alex
>
>
> --
> 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
>
>

-- 
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: Connect ODBC / JDBC Firebird database - LibreOffice 3.3.3 - Windows XP

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 20:31, Giovanni Romero Pérez a écrit :

Ciao Giovanni,

> 
> Thank you very much. I did what you said and all is OK.
> 

Glad I could be of some help.



> Since the Firebird server is on Windows, the string to connect is:
> 
> firebirdsql:servername/3050:C:\\FOLDER\\DATABASE.FDB

Ah, OK, thanks for the OS specific details.


Alex


-- 
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] Can't set each "level" of a bullet list style

2011-07-28 Thread stranger barbecue
In Libreoffice Writer, I am trying to make a document with bullets, but not
continuously. So I have some bullets, then some paragraphs or other text,
then more bullets. But I realized that whenever I turned bullets back on, it
was resetting the bullet style to the default. It became a hassle to have to
set the distance of the bullet from the left side, the amount of spacing
between the right side of the bullet and my text, etc. So I turned to "List
Styles" under "Styles and Formatting".

This is where my real problem started. I noticed that Libreoffice supports
up to 10 levels of bullet or number lists. I noticed that if I went to
Format --> Bullets and Numbering, I could set a different type of bullet for
each level under the "Options" tab. I just had to highlight "1", switch to
the "Bullets" tab, and pick the type of bullet I wanted. Then I could switch
back to the "Options" tab, highlight "2", switch to the "Bullets" tab, pick
another type of bullet (or even the same type of bullet as 1), and so on.

However, when I tried to do this which a list style, it didn't work. All I
could do was set the same type of bullet for 1-10, because whenever I
highlighted 1 and switched to the "Options" tab to choose a bullet, the 1
was deselected by the time I switched back to the "Options" tab.

This is getting very frustrating. If I can set a different type of bullet
for each level of bullet under Format --> Bullets and Numbering, why can't I
do the same when I make a custom list style to save time?

Thanks in advance to anyone who can help!

-- 
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] Calc row filter extraction

2011-07-28 Thread planas
Hi Hylton,

On Thu, 2011-07-28 at 21:50 +0200, Hylton Conacher (ZR1HPC) wrote: 

> Hi all,
> 
> I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1
> with multiple columns and different information in each column. Please
> see the text example I include below.
> 
> What I would ideally like to do is have rows on sheet A, where Column D
> is the same, linked onto another sheet(B). My next requirement is to
> group all the like column B on sheet B, C and link them onto sheet D but
> group them according to column B and SUM the amounts from sheets B, C.
> 
> I have included a brief text example below:
> 
> Sheet A
> A B   C   D   E
> 20-July   SVP SBP Robert  200
> 20-July   STP SPG Hazel   100
> 21-July STP   SBP Robert  180
> 22-July   SVP SBP Robert  50
> 23-July   STP SBP Hazel   400
> 
> Sheet B
> A B   C   D   E
> 20-July   SVP SBP Robert  200
> 21-July STP   SBP Robert  180
> 22-July   SVP SBP Robert  50
> 
> Sheet C
> A B   C   D   E
> 20-July   STP SPG Hazel   100
> 23-July   STP SBP Hazel   400
> 
> Sheet D
> A B   C   D   E
>   STP SBP Robert  100
>   STP SBP Hazel   500
>   SVP SBP Robert  250
> 
> I have done some googling regarding row extraction and have also
> investigated the SUMIF command. and whilst I can get a total of all the
> STP's, I cannot SUM it by user at STP.
> The SUMD command has also raised its head but I cannot figure out how to
> get it to work in conjunction with SUMIF.
> 
> Any help appreciated, even telling me MySQL is a better option. My
> problem is that the data is Sheet A is ever growing and being edited by
> a basic Excel user, and sheets b->D need to reflect those changes made
> on sheet A.
> 
> Again, Any Help Appreciated
> -- 
> 
> Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
> http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO
> 
> 

If I understand your problem, you want conditionally add data based on a
selection criteria from different sheets. I believe sumif works best
using columns from on one sheet.

I wonder if using an intermediate sheet using vlookup and sum these
results might work. One issue, vlookup is to have a unique lookup
parameter in the selection column.

-- 
Jay Lozier
jsloz...@gmail.com

-- 
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: (help macro base)Open form with a button form another form with filter

2011-07-28 Thread Alexander Thurgood
Le 28/07/11 22:11, rogerio dandrea a écrit :

Hi Rogerio,

> 
> Sorry if this is a silly question but, how do I switch the focus from one
> form to another?
> 

I actually looked this up on the OpenOffice.org forum, but I can't find
the link to the post anymore. There might also be a bug in LibreOffice
that prevents the form from reloading. I seem to recall having seen
something similar somewhere, because the filter.appply = true and
form.reload used to work with OpenOffice.org.


Alex





-- 
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: Base record access unacceptably slow

2011-07-28 Thread Andreas Säger

Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote:

Hi,

Le 28/07/2011 18:10, Heinrich Stoellinger a écrit :

In my view LO/OO do NOT require Java, neither on Linux nor on Windows.


AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF
have announced they would get rid of the java-isms in the code. This
implies a major rewrite of Base, though.



No, this is not true. You can use any non-Java database in OOo. You can 
build queries and forms manually in design view, and you can use 
external document templates for reporting. Both built-in report 
generators use Java. IMHO Calc outperforms both report generators anyway.


Hit F4 in Writer or Calc, right-click>Open the dBase "Bibliography".
All the functionality of a flat (unrelational) dBase connection is 
there. You can connect, query, edit data through forms and dump any row 
set into office documents.



--
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: QUESTION: Libreoffice documents constantly need recovery

2011-07-28 Thread Juan Carlos
I have the same problem with L.O Writer 3.4.1 in Ubuntu 10.10. L.O. uses java
1.6.0_26. Also I downloaded the deb packages from the web page (not from
PPA)

Is there any news about this problem?

Another question, where is located the log file with the error reported by
L.O.?

--
View this message in context: 
http://nabble.documentfoundation.org/QUESTION-Libreoffice-documents-constantly-need-recovery-tp2515584p3208186.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: New User: Three Questions

2011-07-28 Thread NoOp
On 07/27/2011 06:46 PM, Rich Shepard wrote:
> On Wed, 27 Jul 2011, NoOp wrote:
> 
>> I only referred to that as it shows making a ~/.fonts folder etc. Please
>> create and put the BakerSignet font in there & see if LO picks it up.
> 
>> Not really, as I don't know what the astrisk is in '1152a___.*' - I know
>> of no fonts that are listed as .* Nor are there any fonts that use a
>> .atm extension. .atm is used for the Adobe Type Manager font
>> catalog/file & ATM fonts are generally Type 1 fonts with an .pfb, .afm
>> and .pfm (and possibly .pfa) files. So I'm still confused.
> 
>The asterisk means multiple suffixes. In this case, 1152a___.afm,
> 1152a___.inf, 1152a___.pfb, and 1152a___.pfm. I mistyped afm as atm.

Got it.

> 
>Well, I guess LO is different from other apps in that it cannot see fonts
> in /usr/share/fonts, but does in ~/.fonts. Very strange. Regardless, I will
> make softlinks in ~/.fonts to the directories in /usr/share/fonts.
...

Might be an issue with the slackware build - you might consider filing a
bug report.

It gets even more interesting; I was experimenting with some old Adobe
FrameMaker .pfb files & used FontForge to convert a .pdb to the
respective .pfa & .afm files. Placed those in ~/.fonts and LO 3.3.3 and
OOo 3.2.1 pick up the font just fine. However, LO 3.4.2 rc2
(pre-release) and OOo-Dev 3.4.0 do not. I'll file a bug on those if I
get time in the next few days.




-- 
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: Base record access unacceptably slow

2011-07-28 Thread NoOp
On 07/28/2011 12:50 PM, Andreas Säger wrote:
> Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote:
>> Hi,
>>
>> Le 28/07/2011 18:10, Heinrich Stoellinger a écrit :
>>> In my view LO/OO do NOT require Java, neither on Linux nor on Windows.
>>
>> AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF
>> have announced they would get rid of the java-isms in the code. This
>> implies a major rewrite of Base, though.
>>
> 
> No, this is not true. You can use any non-Java database in OOo. You can 
> build queries and forms manually in design view, and you can use 
> external document templates for reporting. Both built-in report 
> generators use Java. IMHO Calc outperforms both report generators anyway.
> 
> Hit F4 in Writer or Calc, right-click>Open the dBase "Bibliography".
> All the functionality of a flat (unrelational) dBase connection is 
> there. You can connect, query, edit data through forms and dump any row 
> set into office documents.
> 
> 

http://www.libreoffice.org/get-help/system-requirements/

For certain features of the software - but not most - Java is required.
Java is notably required for Base.




-- 
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: QUESTION: Libreoffice documents constantly need recovery

2011-07-28 Thread David Nelson
Hi Juan,

On Fri, Jul 29, 2011 at 2:02 AM, Juan Carlos  wrote:
> I have the same problem with L.O Writer 3.4.1 in Ubuntu 10.10. L.O. uses java
> 1.6.0_26. Also I downloaded the deb packages from the web page (not from
> PPA)
>
> Is there any news about this problem?

It's not actually an erroneous behavior. It depends how you close the
document(s). For example, if you work on a doc, save it, leave it open
(and, therefore, leave LibreOffice open), and then exit Ubuntu
perfectly normally then, the next time you open LibreOffice, you will
be prompted to recover the docs as if some horrible disaster had
happened, even though there has been no data loss or anything.

If you don't want this behavior to happen then, before you exit
Ubuntu, cleanly close your doc(s) and cleanly exit your LibreOffice,
and THEN exit Ubuntu.

The above was just an example of when it happens. It can happen in
other circumstances, too. It's actually considered to be perfectly
normal AFAIK. Microsoft Office 2010, for instance, behaves in pretty
much the same way.

It irritates me as well, but you'd have to file a feature request to
ask for the behavior to be re-examined and possibly re-designed.

HTH.

> Another question, where is located the log file with the error reported by
> L.O.?

I can't remember off-hand.

-- 
David Nelson

-- 
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] Mac OSX Intel - DOXC with Pictures

2011-07-28 Thread thomi
hi all

we have a problem on a Mac OSX intel 10.6.8 with libreoffice 3.4.1.

See this file http://db.tt/7tOH9Gb, it contains the following:
Example.docx - docx with a embedded picture
Example.pdf - the pdf, was created from Example.docx
Screenshot-01.png - screenshot in edit mode
Screenshot-02.png - screenshot in print preview mode

i think you will see the problem...

Main Problem, picture are there.. but not visible, just with a border... if
exporting to pdf or print/preview they are there.. but while working on that
docx it's not possible to see the picture...

We also found out, that the same problem occurs while creating a new odt on
Mac OSX and embed a picture, see following file: http://db.tt/KKCAZdn

Myself i'm working on Linux Kubuntu 11.04 with libreoffice 3.3.3 and can
open all above file (docx, odt) and see the picture...

Hope someone can help or have an idea...

Thanks a lot
Kind regards
thomi



--
View this message in context: 
http://nabble.documentfoundation.org/Mac-OSX-Intel-DOXC-with-Pictures-tp3208813p3208813.html
Sent from the Users mailing list archive at Nabble.com.

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