Re: [dev] StarOffice3.1 executing macros from the command line

2009-12-11 Thread Markus Daniel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello Matthias,

thank you for the quick response.

Mathias Bauer schrieb:
> Markus Daniel wrote:
> 
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hello,
>>
>> this is not really an OpenOffice-Issue but I am running out of ideas...
>>
>> I am trying to convert old StarOffice3.1 Documents in PDFs.
>>
>> I cannot use OpenOffice because the formatting of the documents will be
>> destroid (tested with OpenOffice 1.0.3).
>>
>> With OpenOffice I called a macro from the commandline like (all on Windows)
>> soffice.exe macro:///lib.module.macro1
>> this works fine but
>> soffice3.exe macro:///lib.module.macro1 with StarOffice3.1 doesn't work
>>
>> I tried a lot of possibilities nothing works.
>> It looks like StarOffice3 was not able to execute macros from the
>> commandline.
>> Is this true?
>>
>> Is a install version of StarOffice3.1 somewhere available?
> 
> I don't think so, at least not if you want to avoid illegal copies.
> Besides that, AFAIR there was no PDF export in SO3, so all you can do
> with it is converting the documents into SO5 binary format.
> 
> This can be done in batch processing using the built-in document
> converter. Then you can use OOo1.x to load the SO5 documents and export
> to PDF. OOo1.x is the closest match for the SO binary format.

I tried to load the documents with OpenOffice, this works fine, but the
layout was not like the original sdw-Files and the pdf-export in early
OpenOffice-Versions is not so good as needed.

> Perhaps you can find an SO5 copy somewhere (as this was available as a
> free download at some point in time) and - if you are lucky - this
> version handles your SO3 documents properly.

I will try this approach, thank you for the tipp.

Can you tell me if the command promt call of a macro works or not?
"soffice3.exe macro:///lib.module.macro1"

Thanks a lot.

Kind regards
Markus

- --
/**
 * Markus Daniel
 * Bachelor of Science
 *
 * Synyx GmbH & Co. KG
 * OpenSource Solutions
 * Karlstr. 68
 * 76137 Karlsruhe
 *
 * phone +49(0)721 66 48 79 31
 * fax   +49(0)721 66 48 877
 * eMail markus.dan...@synyx.de
 * www   http://www.synyx.de
 * skype synyx_daniel
 * irc   irc.synyx.de
 *
 * Sitz der Gesellschaft: Karlsruhe
 * Registergericht: Mannheim
 * Handelsregisternummer: HRA 4793
 * USt-IdNr.: DE249264296
 *
 * Komplementärin: Elatech Verwaltungs GmbH
 * Sitz der Gesellschaft: Karlsruhe
 * Geschäftsführer: Markus Daniel
 * Registergericht: Mannheim
 * Handelsregisternummer: HRB 7250
 */
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFLInl7A6KmbVkuXQkRAgWsAJ9aeZuOX+3l1gveWjF7BGH6zys06gCfXuMe
TBkY5gFJ/xSK5KEeEFj9Ggk=
=vYgI
-END PGP SIGNATURE-

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



[dev] Re:

2009-12-11 Thread Andreas Saeger
ODF is the the only relevant "free and open" feature. Any of your 
programs can generate perfectly valid office documents with a similar 
feature set as in MS Office, usable with many different applications.
Translating a typical "VBA solution" to something equivalent in 
Basic/Python/Java requires far more effort than writing the original VBA 
leading from one vendor lock-in to another one. The whole programming 
logic depends on one particular office application.
The infamous "VBA compatibility mode" covers some trivial methods and 
properties but you can not be sure that your VBA does exactly the same 
thing in this app as it used to do in the other app. It does not support 
anything more sophisticated, no user interface elements, no complex 
method calls (spreadsheet: sort, filter, conditional formatting, 
validation, charts, pivots,...).

Bugs anyone?
print cDbl("1.234"), cDbl("1,234")
http://www.openoffice.org/issues/show_bug.cgi?id=6 (so easy to 
confuse this interpreter using simple variants).
The absence of class modules makes Basic perfectly incompatible with 
slightly advanced "VBA solutions".
StarBasic is a simplistic embeddable facility for batches of API calls. 
The runtime functions hardly invites anyone to write a program logic 
(arrays anyone? hashes/dictionaries? string replacements? format? regex? 
abandon all hope).



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