Apache OpenOffice Wiki - User contributions [en]

Report bugs

2011-04-28T20:54:51Z

Skelem: /* What you need */

== What you need==

A [http://download.openoffice.org/ recent OpenOffice.org] installation

An [http://www.openoffice.org/servlets/Join account on OpenOffice.org]

Get a little familiar with [http://qa.openoffice.org/issue_handling/ IssueZilla / IssueTracker]

[http://qa.openoffice.org/issue_handling/pre_submission.html Research, then Submit a new issue].

== What you don't need ==

Programming experience

Knowledge of the help file format

Long term commitment

== What you do ==

Find issues (wrong instructions, terminology flaws, missing descriptions)

Report them using Issuezilla

== What you get ==

A better product!

We may start keeping a top 10 issues submitters list ;-)

[[Category:Documentation/OnlineHelp]]

Report bugs

2011-04-28T20:52:18Z

Skelem: /* What you get */

== What you need==

A [http://download.openoffice.org/ recent OpenOffice.org] installation

An [http://www.openoffice.org/servlets/Join account on OpenOffice.org]

Get a little familiar with [http://qa.openoffice.org/issue_handling/ IssueZilla / IssueTracker]

== What you don't need ==

Programming experience

Knowledge of the help file format

Long term commitment

== What you do ==

Find issues (wrong instructions, terminology flaws, missing descriptions)

Report them using Issuezilla

== What you get ==

A better product!

We may start keeping a top 10 issues submitters list ;-)

[[Category:Documentation/OnlineHelp]]

Talk:Run OOo versions parallel

2011-04-01T23:00:33Z

Skelem: /* = But how do you invoke the development version on Linux? */

Hi, I've come here after seeing [http://www.oooninja.com/2008/01/alternative-installation-on-windows.html Secrets of alternative installation on Windows - OpenOffice .org Ninja]

I have a problem getting this administrative-install running on XP SP3 w/ OOO3... I followed the instructions, and firest it reports "sal3.dll cannot be found". Once I add D:\ooo3\Basis\program;D:\ooo3\URE\bin to the path, I get, basically a blank OpenOffice.org window and everything shuts down afterwards:
[[Image:Cygooo3.png]]

As it is visible, it is ran from cygwin, and no output is recorded whatsoever, unlike what [http://wiki.services.openoffice.org/wiki/Windows_Debugging Windows Debugging - OpenOffice .org Wiki] said...
<pre>Using normal command-line in Windows, you cannot see the standard out or standard error.
The trick is to start OOo (soffice.exe) from cygwin. </pre>

So, I tried debugging (Profiling) using Dependancy Walker on soffice.bin, and one of the first problematic entries (but not the only ones) are:
<pre>GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsAlloc") called from "MSVCR90.DLL" at address 0x78543ACC and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsGetValue") called from "MSVCR90.DLL" at address 0x78543AD9 and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsSetValue") called from "MSVCR90.DLL" at address 0x78543AE6 and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsFree") called from "MSVCR90.DLL" at address 0x78543AF3 and returned NULL. Error: The specified procedure could not be found (127).
</pre>

The only thing I have found on the net that sort of clarifies this problem is in [http://groups.google.com/group/microsoft.public.dotnet.languages.vc.libraries/browse_thread/thread/c45d96cdaaa938f2 incompatibilites between run-time dll's? ]:
<pre>> It turns out that the reason things aren't working is that msvcr71.dll
> is trying to access some Fiber APIs in Kernel32.dll. The procedures it's
> trying to access (FlsAlloc, FlsFree, FlsGetValue, FlsSetValue) are ONLY
> available in Windows Server 2003
...
The problem seems to stem from the LEDA library which I'm linking into
my app as a DLL. It's leda.dll which is dependent on msvcr71.dll, and
therefore indirectly (I guess) is the root of the problem.</pre>

MSDN [http://msdn.microsoft.com/en-us/library/ms682664(VS.85).aspx FlsAlloc Function (Windows)] also says
<pre>Minimum supported client Windows Vista
Minimum supported server Windows Server 2003</pre>

So, I'm wandering - has the OOO3 for Windows possibly have been built on Server 2003 or Vista, therefore making this parallel / portable running of openoffice impossible on XP?

The moment of the window appearing, and OOO exiting, is I believe within these Dependancy Walker lines:
<pre>Loaded "I18NPOOL.UNO.DLL" at address 0x635B0000. Successfully hooked module.
Loaded "ICUIN36.DLL" at address 0x62A20000. Successfully hooked module.
DllMain(0x62A20000, DLL_PROCESS_ATTACH, 0x00000000) in "ICUIN36.DLL" called.
DllMain(0x62A20000, DLL_PROCESS_ATTACH, 0x00000000) in "ICUIN36.DLL" returned 1 (0x1).
DllMain(0x635B0000, DLL_PROCESS_ATTACH, 0x00000000) in "I18NPOOL.UNO.DLL" called.
DllMain(0x635B0000, DLL_PROCESS_ATTACH, 0x00000000) in "I18NPOOL.UNO.DLL" returned 1 (0x1).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironmentExt") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironment") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B150B.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getFactory") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B4EAF.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_canUnload") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironmentExt") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironment") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B150B.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getFactory") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B4EAF.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_canUnload") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C900000 [NTDLL.DLL], "RtlDllShutdownInProgress") called from "MSCTF.DLL" at address 0x7475FA60 and returned 0x7C9136B0.
LoadLibraryExW("C:\Program Files\WIDCOMM\Bluetooth Software\btkeyind.dll", 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) called from "USER32.DLL" at address 0x7E428055.
Loaded "BTKEYIND.DLL" at address 0x043A0000. Successfully hooked module.
DllMain(0x043A0000, DLL_PROCESS_ATTACH, 0x00000000) in "BTKEYIND.DLL" called.
DllMain(0x043A0000, DLL_PROCESS_ATTACH, 0x00000000) in "BTKEYIND.DLL" returned 1 (0x1).
LoadLibraryExW("C:\Program Files\WIDCOMM\Bluetooth Software\btkeyind.dll", 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned 0x043A0000.
DllMain(0x043A0000, DLL_PROCESS_DETACH, 0x00000001) in "BTKEYIND.DLL" called.
DllMain(0x043A0000, DLL_PROCESS_DETACH, 0x00000001) in "BTKEYIND.DLL" returned 1 (0x1).</pre>

== fixed for OOO3... ==

Finally, I think I got this solved for OOO3... So, for a 'portable' - administrative - install of OpenOffice3, instead of doing 'msiexec /a ..', one should do 'setup /a', as per:
Step 2 – Create Network Installation Images | Open Office Technology
[http://openofficetechnology.com/node/26]
Then the running of executables runs fine from a folder..

== But how do you invoke the development version on Linux? ==

I used the methods here to install OOo-Dev_DEV300m104_Linux_x86-64_install-rpm_en-US.tar.gz into /opt/ooo-dev and /opt/ooo-dev3. My normal installation is part of the Fedora 14 distribution, and it installs somewhere else.

How do I invoke this alpha version?

Neither of these directories contain soffice or openoffice.org or writer!

Talk:Run OOo versions parallel

2011-04-01T22:59:55Z

Skelem: Linux run question.

Hi, I've come here after seeing [http://www.oooninja.com/2008/01/alternative-installation-on-windows.html Secrets of alternative installation on Windows - OpenOffice .org Ninja]

I have a problem getting this administrative-install running on XP SP3 w/ OOO3... I followed the instructions, and firest it reports "sal3.dll cannot be found". Once I add D:\ooo3\Basis\program;D:\ooo3\URE\bin to the path, I get, basically a blank OpenOffice.org window and everything shuts down afterwards:
[[Image:Cygooo3.png]]

As it is visible, it is ran from cygwin, and no output is recorded whatsoever, unlike what [http://wiki.services.openoffice.org/wiki/Windows_Debugging Windows Debugging - OpenOffice .org Wiki] said...
<pre>Using normal command-line in Windows, you cannot see the standard out or standard error.
The trick is to start OOo (soffice.exe) from cygwin. </pre>

So, I tried debugging (Profiling) using Dependancy Walker on soffice.bin, and one of the first problematic entries (but not the only ones) are:
<pre>GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsAlloc") called from "MSVCR90.DLL" at address 0x78543ACC and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsGetValue") called from "MSVCR90.DLL" at address 0x78543AD9 and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsSetValue") called from "MSVCR90.DLL" at address 0x78543AE6 and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C800000 [KERNEL32.DLL], "FlsFree") called from "MSVCR90.DLL" at address 0x78543AF3 and returned NULL. Error: The specified procedure could not be found (127).
</pre>

The only thing I have found on the net that sort of clarifies this problem is in [http://groups.google.com/group/microsoft.public.dotnet.languages.vc.libraries/browse_thread/thread/c45d96cdaaa938f2 incompatibilites between run-time dll's? ]:
<pre>> It turns out that the reason things aren't working is that msvcr71.dll
> is trying to access some Fiber APIs in Kernel32.dll. The procedures it's
> trying to access (FlsAlloc, FlsFree, FlsGetValue, FlsSetValue) are ONLY
> available in Windows Server 2003
...
The problem seems to stem from the LEDA library which I'm linking into
my app as a DLL. It's leda.dll which is dependent on msvcr71.dll, and
therefore indirectly (I guess) is the root of the problem.</pre>

MSDN [http://msdn.microsoft.com/en-us/library/ms682664(VS.85).aspx FlsAlloc Function (Windows)] also says
<pre>Minimum supported client Windows Vista
Minimum supported server Windows Server 2003</pre>

So, I'm wandering - has the OOO3 for Windows possibly have been built on Server 2003 or Vista, therefore making this parallel / portable running of openoffice impossible on XP?

The moment of the window appearing, and OOO exiting, is I believe within these Dependancy Walker lines:
<pre>Loaded "I18NPOOL.UNO.DLL" at address 0x635B0000. Successfully hooked module.
Loaded "ICUIN36.DLL" at address 0x62A20000. Successfully hooked module.
DllMain(0x62A20000, DLL_PROCESS_ATTACH, 0x00000000) in "ICUIN36.DLL" called.
DllMain(0x62A20000, DLL_PROCESS_ATTACH, 0x00000000) in "ICUIN36.DLL" returned 1 (0x1).
DllMain(0x635B0000, DLL_PROCESS_ATTACH, 0x00000000) in "I18NPOOL.UNO.DLL" called.
DllMain(0x635B0000, DLL_PROCESS_ATTACH, 0x00000000) in "I18NPOOL.UNO.DLL" returned 1 (0x1).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironmentExt") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironment") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B150B.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getFactory") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B4EAF.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_canUnload") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironmentExt") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getImplementationEnvironment") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B150B.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_getFactory") called from "SAL3.DLL" at address 0x6011C01D and returned 0x635B4EAF.
GetProcAddress(0x635B0000 [I18NPOOL.UNO.DLL], "component_canUnload") called from "SAL3.DLL" at address 0x6011C01D and returned NULL. Error: The specified procedure could not be found (127).
GetProcAddress(0x7C900000 [NTDLL.DLL], "RtlDllShutdownInProgress") called from "MSCTF.DLL" at address 0x7475FA60 and returned 0x7C9136B0.
LoadLibraryExW("C:\Program Files\WIDCOMM\Bluetooth Software\btkeyind.dll", 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) called from "USER32.DLL" at address 0x7E428055.
Loaded "BTKEYIND.DLL" at address 0x043A0000. Successfully hooked module.
DllMain(0x043A0000, DLL_PROCESS_ATTACH, 0x00000000) in "BTKEYIND.DLL" called.
DllMain(0x043A0000, DLL_PROCESS_ATTACH, 0x00000000) in "BTKEYIND.DLL" returned 1 (0x1).
LoadLibraryExW("C:\Program Files\WIDCOMM\Bluetooth Software\btkeyind.dll", 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned 0x043A0000.
DllMain(0x043A0000, DLL_PROCESS_DETACH, 0x00000001) in "BTKEYIND.DLL" called.
DllMain(0x043A0000, DLL_PROCESS_DETACH, 0x00000001) in "BTKEYIND.DLL" returned 1 (0x1).</pre>

== fixed for OOO3... ==

Finally, I think I got this solved for OOO3... So, for a 'portable' - administrative - install of OpenOffice3, instead of doing 'msiexec /a ..', one should do 'setup /a', as per:
Step 2 – Create Network Installation Images | Open Office Technology
[http://openofficetechnology.com/node/26]
Then the running of executables runs fine from a folder..

== But how do you invoke the development version on Linux? =

I used the methods here to install OOo-Dev_DEV300m104_Linux_x86-64_install-rpm_en-US.tar.gz into /opt/ooo-dev and /opt/ooo-dev3. My normal installation is part of the Fedora 14 distribution, and it installs somewhere else.

How do I invoke this alpha version?

Neither of these directories contain soffice or openoffice.org or writer!

Python

2009-04-20T18:48:50Z

Skelem: grammar corrections

{{Extensions}}
[[image:Py-uno_128.png|PyUNO Logo]] [[image:Pyuno_logo_a.jpg]]
=== News ===
Efforts on moving PyUNO to '''Python 2.5''' continue. Liyuan is pushing this initiative and has [http://udk.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=3704 commited the CWS] on the UDK mailing list the [[CWS]] however is not ready and was sent back on issue [http://www.openoffice.org/issues/show_bug.cgi?id=71327 71327].

=== Python and OpenOffice.org ===
OpenOffice.org ships with a python scripting language, version 2.3.4. This Python distribution comes with the [[Uno]] module which connects the [[API|UNO API]] with the python scripting language. To run this version of Python on Linux you can go to the direct OpenOffice.org PATH. OOo-Python can be run from the command line as well as you might expect with any other distribution of Python.

==== Where is the IDE ? ====
OpenOffice.org's IDE doesn't support Python, so development has to be done from another editor that does. Any volunteer for a binding is welcomed

==== Tips & Tricks ====

Here are some useful information, helping to use python in OOo

===== Debug output =====

If you launch a python script, any error will silently break the execution and your extension will be hard to debug. To change this behaviour, one can change the '''LogLevel'''

Have a look in
''/path/to/ooo/program/'''pythonscript.py'''''
and replace
''LogLevel.use = LogLevel.'''NONE'''''
with
''LogLevel.use = LogLevel.'''DEBUG'''''

There are also currently undocumented environment variables, which tell the pyUno bridge to log every call, set therefor the environment variable
''export PYUNO_LOGLEVEL=ARGS''
, the output is a little hard to read, but helpful during development.

This applies to Linix. For Windows you need some more switches and the output gets written to files (no stdout on windows :-( ).

Some error messages still don't appear in these logs, this will improve
in the near future (cws pyunofixes4). Once the cws is integrated, I will document these switches on the official pyuno site.

''Thanks to Joerg Budischewski''

=== Python specific information for Extension creation ===
To create extensions for python it is important that you have enough familiarity with the UNO components as well as packaging your code to be able to easily distribute your scripts through the ''OpenOffice.org package manager''. Please check the tutorials on how to componentize your code as well as how to deploy remote scripting through a service implementation.

To learn to run Python on Windows you could visit [[Using Python on Windows| this link]] for more detail information.

=== Getting Started ===
*[[Using Python on Windows]] - New to Python? Learn how to use python on Windows
*[[Using Python on Linux]] - A must read for an overwiew on Python and OOo relations
* [[pyUNO bridge]] - Official page of the PyUNO bridge at the [http://udk.openoffice.org/ UDK site]
* [[Python as a macro language]] in OpenOffice.org 2.x - How to use the Python scripting framework
* [http://lucasmanual.com/mywiki/OpenOffice PyUNO Manual] Lukasz created a pyUNO manual. '''new'''
* [http://www.linuxjournal.com/content/starting-stopping-and-connecting-openoffice-python Starting/Stoping and connecting using Python] From Linux Journal
* Introduction on testing pyUNO programs with [[doctests]]
* Create a [http://codesnippets.services.openoffice.org/Office/Office.MessageBoxWithTheUNOBasedToolkit.snip dialog box] in PyUNO.
* [http://codesnippets.services.openoffice.org/Office/Office.ConnectViaPipe.snip Connect to openoffice.org] from PyUNO
* [[PyUNO samples]] currently shipping with OpenOffice.org and the explanation.
* Enhanced [http://www.oooforum.org/forum/viewtopic.phtml?p=257496#257496 Capitalized.py] script by ''The gray Cardinal'' at OOoforum.

=== PyUNO Modules ===
*[[Danny's Python Modules]] - Collection guide from DannyB's modules.
*[[PrinttoWriter.py]] - This makes it easy and convenient to print a bunch of text into a Writer document.
*[http://www.oooforum.org/forum/viewtopic.phtml?t=8456 Developing Calc Funcions in Python] - Learn how Python can be used to script your spreadsheets
*[http://www.oooforum.org/forum/viewtopic.phtml?p=56037#56037 Generating a Spreadsheet through Python] - Automatically generate new spreadsheets
*[http://www.oooforum.org/forum/viewtopic.phtml?t=9115 Python container components]
*[[PyUNOServer]] - The PyUNOServer is a script that works as an XML server for OpenOffice.org Calc
*[[calcParser]] - calcParser is a small parser using the native SAX utilities within the OpenOffice.org python
*[[OoConfig]] - OoConfig is a Python extension that seeks to provide a configuration editing facility similar to Mozilla's about:config
*[[Bibliographic/Hints and Tips/OOoRISExport.py|OOoRISExport.py]] - Exports the bibliographic database in RIS format. Also [http://bibliographic.openoffice.org/files/documents/124/3078/RISImport.py RISImport.py]
*[[Zotero_Plugin |Zotero Plugin]] - The Zotero plugin provides citation and bibliographic table insertion and editing functions for Writer documents.

=== Hacking Arround ===
*[[UNO component packaging]] - How to create UNO components as well as the basics of script componentizing
*[http://www.oooforum.org/forum/viewtopic.phtml?p=38234#38234 Python component to parse XML] - Python is great to parse XML, PyUNO is also excellent when working with XML
*[[Example of Service in Python]] - Learn how to run Python as a service, this is useful for remote scripting.
*[http://www.oooforum.org/forum/viewtopic.phtml?p=76972#76972 Modify spreadsheet] - Example of storing and retrieving a custom attribute on a spreadsheet cell.
*A simple [[daemon in Python]] - Learn how to run Python as a daemon
*[[Loook.py]] - a simple Python tool that searches for text strings in OpenOffice.org.
*[[odt2txt.py]] - convert ODF to plain text using python (and convert the txt to html).

=== Python rules OOo (by B. Bois) ===
[[image:python_power_for_OOo.png|Python rules OOo :-)]]

[[Category:Extensions]]
[[Category:Python]]
[[Category:Uno]]