[api-dev] Re: about macros and database

2011-02-26 Thread Andreas Säger

Am 18.02.2011 05:34, joe wrote:

where I can find macros and exemples of database because I want to create a 
database. can you helpme please


Nobody needs macros to create a usable database.

--

To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: sy...@api.openoffice.org with Subject: help


[api-dev] Re: I can see the method/property which can not be found ...

2011-02-12 Thread Andreas Säger

Am 09.02.2011 18:23, Bernard Marcelly wrote:

Hi Andreas,
I ran your code on OOo 3.3.0 / Windows XP.
I got a Writer table with the formatted cells. It works as expected.

Suggestion : re-install OOo after a good cleaning.

Regards
Bernard


Resetting my profiles for OOo2.4, 3.3 and LO3.3 cured the problem. But I 
do not like the disadvantages of this step, so I investigated a little 
bit further.
After restoring the old 3.3 profile, I removed some subdirectories one 
after the other and found that the basic subfolder is the culprit.


I comment out all libraries in basic/script.xlb and activate them one by 
one while testing the problematic macro. It turns out that my library 
"Standard" causes the problem. Within my Standard library a module named 
"CELL" makes the cell-copy macro fail.

Any module named CELL, even a blank one, makes the cell-copy macro fail.
A module name CELL in some other library does not harm.

http://qa.openoffice.org/issues/show_bug.cgi?id=116934

Cheers,
Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: I can see the method/property which can not be found ...

2011-02-11 Thread Andreas Säger

Am 11.02.2011 08:56, Peter Eberlein wrote:

Am 10.02.2011 16:40, schrieb Andreas Säger:

Am 10.02.2011 15:30, Peter Eberlein wrote:

Just tested with 3.2 and m95 (3.4), no problems.



Which OS, please?

WinXP SP 2

Peter


Thank you, Peter. Meanwhile I ran the macro successfully on WinXP. It is 
not a Linux issue though. It is some bug in all of my user profiles for 
OOo3, LibO3 and OOo2.



-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: I can see the method/property which can not be found ...

2011-02-10 Thread Andreas Säger

Am 10.02.2011 15:30, Peter Eberlein wrote:

Just tested with 3.2 and m95 (3.4), no problems.



Which OS, please?
Thank you for testing to you both Bernard and Peter.

Regards,
Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] I can see the method/property which can not be found ...

2011-02-09 Thread Andreas Säger

Hello API experts,

Initial problem: first post in 
http://www.oooforum.org/forum/viewtopic.phtml?t=45971
Satisfactory solution as of Nov. 2006: 
http://www.oooforum.org/forum/viewtopic.phtml?t=47340


Today's problem (versions 3.3 and 2.4.3): Empty Writer table.
I comment out the error handler:

'   on error goto errExit


and get

"Method/property not found in line

 cursor = cell.createTextCursor


I can put a stop mark in that line and inspect the cell. It offers 
method "createTextCursor" and "getEnd" from that cursor.


However, the newly created Writer frame looks a little bit strange. The 
component window is transparent.


It makes not difference when I comment out

doc.lockcontrollers



Thanks in advance for any suggestions,
Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: LO removing Java, why would they want to? (Re: [api-dev] Java-Midi not working on Mac?

2011-01-09 Thread Andreas Säger

Am 27.12.2010 13:41, Jürgen Schmidt wrote:

On 12/27/10 1:00 PM, Andreas Säger wrote:


A user installs the software from its home page, together with a bundle
of Java by default, although he has Java installed already, possibly
even a more recent one which gets updated without OOo taking any advantage.
Without Java, menu:Tools>Macros>Run... raises an error suggesting that
you can not run any macros without JRE, which is untrue as far as Basic
and Python are concerned.


i agree again and that is a bug for me.



Hi Jürgen,

The issue is http://qa.openoffice.org/issues/show_bug.cgi?id=86541 which 
has been rejected as invalid. In fact it is still an issue.

Disable Java.
Tools>Macros>Run... gives the error message but as a matter of fact you 
can run Basic and Python with Java disabled.

No such error message when you follow:
Tools>Macros>Organize>Basic|Python... button [Run]

Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: LO removing Java, why would they want to? (Re: [api-dev] Java-Midi not working on Mac?

2010-12-27 Thread Andreas Säger

Am 27.12.2010 12:22, Jürgen Schmidt wrote:


I do understand that Java is a holy cow for Oracle employees but you
will not stop the discussion about it.

;-) i don't think so, but Java is besides Python the only reliable way
to add new components as extensions. Well i talk not about macros etc.

Juergen


Juergen,
Of course, Java is *the* language for optional new components.

I refered to the built-in set of features, some of which rely on Java 
since the very first version (menu:File>Wizards>...), some of which are 
not desirable in my honest opinion (embedded HSQLDB and misleading 
database wizards).


A user installs the software from its home page and gets error messages 
about Java missing when calling some wizard.
A user installs the software from its home page, together with a bundle 
of Java by default, although he has Java installed already, possibly 
even a more recent one which gets updated without OOo taking any advantage.
Without Java, menu:Tools>Macros>Run... raises an error suggesting that 
you can not run any macros without JRE, which is untrue as far as Basic 
and Python are concerned.


Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: LO removing Java, why would they want to? (Re: [api-dev] Java-Midi not working on Mac?

2010-12-27 Thread Andreas Säger

Am 27.12.2010 09:22, Jürgen Schmidt wrote:


At the moment there is indeed no real technical reason to remove Java.
Ok on Mac OS there exists some problems (only a few use cases) but i
hope that this can be solved in the future.



Technical reasons:
More dependencies than necessary.
Compare the cold start times with and without Java.


Sorry that i have put this sentence with removing Java in LibO in the
game.


It was Rony who asked a reasonable question in the subject line. From my 
point of view it would be possible to remove the Java dependencies from 
the built-in features once you dropped the embedded HSQLDB which proves 
to be failing since 5 years by now.
I do understand that Java is a holy cow for Oracle employees but you 
will not stop the discussion about it.


Good Slide! (as we say in German),
Andreas Säger


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org



[api-dev] Re: LO removing Java, why would they want to? (Re: [api-dev] Java-Midi not working on Mac?

2010-12-24 Thread Andreas Säger

Am 24.12.2010 10:57, Rony G. Flatscher wrote:

One premiere example is the scripting subsystem, which makes JavaScript,
BeanShell, ooRexx and others available to OOo. Removing Java removes all
these options and renders programs written in these languages useless.



Only Tools>Macros>Run... raises a misleading error message about missing 
Java. Basic and Python keep on working as usual from that dialog.

Using Tools>Macros>Organize>Basic|Python avoids the error message.
The script providers don't need to be written in Java.
A modified Python script provider written in Python which helps to embed 
Python in documents: 
http://hermione.s41.xrea.com/pukiwiki/index.php?OOobbs2%2F194


The biggest chunk of Java might be the Base component with all the 
useless/misleading Java wizards and the embedded Java-HSQLDB.
It could be removed all together in favour of a much simpler and more 
functional database connectivity like it used to be in version 1.x. 
(with less bugs and working as specified, of course).


The "Access equivalent" with a database in a single file failed.
Even the "simple users" do understand the concept of a registered 
database from where to fetch mail merge addresses. But even advanced 
users become extremely irritated by the fact that this configuration 
involves a separate "Base document", a Calc document (in most cases), 
and one or two Writer documents.
Some of the wizards under File>Wizard>... are really useful but 
nevertheless replaceable with something better.


Merry Christmas,
Andreas


-
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org