headers
Dean Allen Provins, P. Geoph. | 18 Nov 19:03
Favicon

Python <-> Calc interface code

Hello:

This is a second attempt at sending the following.  Apparently I
was subscribed under an alias.

---------previously sent message...

I have just been to the OO page
<http://udk.openoffice.org/python/python-bridge.html> and found
this address.  

I have some code to contribute.  I have written a set of three
classes (document, sheet and cell) to allow Python programmers
easy access to a spreadsheet.

It runs successfully under OO 3.3 (for me at least) and I suspect
that these codes would be very useful for others wishing to
implement Python routines that exploit OO spreadsheets.

Without doubt there are bugs that I have not yet discovered, so
some user feedback would be desirable.

The codes are available from
<http://telusplanet.net/~provinsd/SOFTWARE/software.html>.

Regards,

Dean

--

--
(Continue reading)

Permalink | Reply | 0 comments |
headers
Bohdan Zograf | 26 Apr 00:34
Picon

'Python-UNO bridge' translation

Hi!

I'm willing to translate publication located at 
http://udk.openoffice.org/python/python-bridge.html to the Belorussian 
language (my mother tongue). What I'm asking for is your written 
permission, so you don't mind after I'll post the translation to my 
blog. The translation is intended only for web, no print copies planned.
Visitors of your website, who come from Minsk (Belorussia) will be the 
ones, who will read this blogpost, that's the only way to spread them, 
no additional instruments we can use. Every translation we ever do does 
not costs a penny for the webpage, which is translated. All we ask is to 
link back in whatever way you feel confident about it.

Thank you for the article.
You can leave a voice message and I will call you back, if you prefer a 
call instead of emails.

Sincerely,
Bohdan Zograf
+(360) 488-0303
--

-- 
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscribe@...
For additional commands send email to sympa@...
with Subject: help
Permalink | Reply | 1 comment |
headers
Dean Allen Provins, P. Geoph. | 4 Mar 17:48
Favicon

python setDataArray query

Hello:

I'm working up some Python code and have successfully used
"getDataArray" and "getFormulaArray", but have been singularly
unsuccessful in using "setDataArray" or "setFormulaArray".

The Python-UNO bridge document says to use a sequence,
specifically a ByteSequence to pass the relevant parameters to
the desired function.  I have employed several variations of the
following, without success:

	self.sheet.setDataArray (uno.ByteSequence ("((5.,),(6.,),(7.,))"))
	..........................................."(5.,6.,7.)"
	..........................................."(5.,6.,7.,)"
	..........................................."(5.,),(6.,),(7.,)"

The error most frequently seen is:

	__main__.CannotConvertException: conversion not possible!

When calling (say) "getDataArray", a tuple of tuples is returned,
such as:

	((2.0,) (3.0,) (4.0,))

so I thought the first example would be most likely to work.
Alas, that was not the case.

Any suggestions would be most gratefully received.
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jean-Baptiste Faure | 1 Feb 22:21
Favicon

[discuss] OpenOffice.org 3.3.0 est disponible en français

Bonjour,

La nouvelle version 3.3.0 de OpenOffice.org est disponible en français.
Vous pouvez la télécharger depuis la page web habituelle :
http://fr.openoffice.org/

Elle est disponible pour MS-Windows (Xp, Vista et Seven), Linux / Deb 32
et 64 bits, MacOS-X processeurs Intel et PowerPC. Les packs langues
français correspondants sont également disponibles.

Attention : la version pour Linux / rpm n'ayant pu être testée faute de
volontaire, celle-ci n'a pas été validée et restera donc au stade de
"release candidate".

L'annonce officielle de la publication de la version anglophone est
disponible ici :
http://www.mail-archive.com/announce <at> openoffice.org/msg00197.html

Bonne soirée
JBF

--

-- 
Jean-Baptiste FAURE
Responsable du projet OpenOffice.org Francophone
http://fr.openoffice.org

Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Permalink | Reply | 0 comments |
headers
Jean-Baptiste Faure | 1 Feb 22:21
Favicon

OpenOffice.org 3.3.0 est disponible en français

Bonjour,

La nouvelle version 3.3.0 de OpenOffice.org est disponible en français.
Vous pouvez la télécharger depuis la page web habituelle :
http://fr.openoffice.org/

Elle est disponible pour MS-Windows (Xp, Vista et Seven), Linux / Deb 32
et 64 bits, MacOS-X processeurs Intel et PowerPC. Les packs langues
français correspondants sont également disponibles.

Attention : la version pour Linux / rpm n'ayant pu être testée faute de
volontaire, celle-ci n'a pas été validée et restera donc au stade de
"release candidate".

L'annonce officielle de la publication de la version anglophone est
disponible ici :
http://www.mail-archive.com/announce <at> openoffice.org/msg00197.html

Bonne soirée
JBF

--

-- 
Jean-Baptiste FAURE
Responsable du projet OpenOffice.org Francophone
http://fr.openoffice.org

Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Permalink | Reply | 0 comments |
headers
Serge Noiraud | 7 Jan 14:26
Picon

python uno : the page number is blank on the first page

Hi,

I didn't found this subject in the faq, so I ask it.
I create a writer document and I'd like to have the page numbering.
It works except for the first page.
If I use PageNumberOffset to a value > 1, it works correctly.
If I set this to one or I don't set it, I have a blank number on the first page.
Do I forget something ?
Here is my sample :

# access the current writer document
model = desktop.loadComponentFromURL("private:factory/swriter", "_blank", 0, ())
# access the document's text property
text = model.Text
# create a cursor
cursor = text.createTextCursor()
print "page syle : ", cursor.PageStyleName
cursor.setPropertyValue("PageNumberOffset", 1)
PageStyles = model.StyleFamilies.getByName("PageStyles")
StdPage = PageStyles.getByName("Standard")
StdPage.FooterIsOn = True
PageCount = model.createInstance("com.sun.star.text.textfield.PageCount")
PageCount.NumberingType = ARABIC
PageNumber = model.createInstance("com.sun.star.text.textfield.PageNumber")
PageNumber.NumberingType = ARABIC
FooterCursor = StdPage.FooterTextLeft.Text.createTextCursor()
StdPage.FooterTextLeft.Text.insertString(FooterCursor, "Page : ", False)
StdPage.FooterTextLeft.Text.insertTextContent(FooterCursor, PageNumber, False)
StdPage.FooterTextLeft.Text.insertString(FooterCursor, "/", False)
StdPage.FooterTextLeft.Text.insertTextContent(FooterCursor, PageCount, False)
(Continue reading)

Permalink | Reply | 2 comments |
headers
Gabriel Monnerat | 25 Nov 14:38
Picon
Gravatar

many .recently-used.xbel in home user

Hi,

Exists one feature to remove or disable to not create many files in home 
user.
e.g
.recently-used.xbel
.recently-used.xbel.L14MMV

--

-- 
Gabriel M. Monnerat
Permalink | Reply | 0 comments |
headers
Jayesh Patel | 15 Nov 08:25

Reg about Licences

Hello Sir

Myself jayesh patel from LEAD IMPORTER LLP ,

WE are manufuture of Usb pen drive I want to Install your open office
application in my all pen drive ,

So please can you tell me can I install it ?

Waiting for your positive reply

Thank you
Permalink | Reply | 0 comments |
headers
Lukasz Szybalski | 12 Nov 23:10
Picon

ootools and openoffice.org headless with 3.2.1 WOW

Hello,
Finally after few months of waiting the openoffice.org 3.2.1 is here
in lenny backports. The speed improvement in that version are just
insane fast. The response time compared to 3.1.1 is just amazing.
Congrats to OO team.

 So if you are into doing some kind of templates here is how to use
openoffice in the code without touching ui !

Install ootools program: (http://pypi.python.org/pypi/ootools/0.1dev)
easy_install ootools

Then in python:

import ootools
oor=ootools.OORunner()
oor.start()
desktop=oor.connect()
#......
oor.stop()

The ootools start and stop the openoffice.org --hedless mode for you.
This is a great tool for creating templates. In my case I use it with
sqlalchemy to loop through records and create odt documents for each
record that then get it printed and mailed.

Few helpful links on how to write code for headless mode:
http://lucasmanual.com/mywiki/OpenOffice

Thank you,
(Continue reading)

Permalink | Reply | 2 comments |
headers
Roman Gelbort | 11 Nov 03:19
Picon

Carta abierta de oooES para OOo|LibO|Educooo

Amigos.

Como parte de los cambios que estamos proponiendo por estos días, hemos
desarrollado tres cartas abiertas a los proyectos LibreOffice,
OpenOffice.org y Educooo. La idea es explicarles el rol que queremos que
oooES tenga en adelante.

Ponemos en consideración de todos ustedes estas cartas, para que las
lean, propongan y nos digan si están de acuerdo para sumarse en las
firmas de las mismas.

El objetivo es claramente "incluir" a todos en este proyecto que es
oooES, una comunidad independiente que soporte a todos los proyectos en
español y que colabore con todos también.

Las cartas pueden leerse en:

http://oooes.org/carta-educoo.html
http://oooes.org/carta-ooo.html
http://oooes.org/carta-tdf.html

Por favor contesten a este mail aquellos que quieran estar incluidos en
las firmas.

P.D.: Las escribimos en inglés dado que están dirigidas a los proyectos globales. Si alguno
quiere/puede traducirlas al español, sería de gran ayuda para aquellos que no puedan leer en inglés.

--

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Prof. Román H. Gelbort
(Continue reading)

Permalink | Reply | 0 comments |
headers
Nelson, Robert | 26 Oct 20:52
Favicon

UNO URE

Hi,

I would like to download both the latest and version 2.3.0 of the UNO URE.  I cannot either the latest version
or 2.3.0 on http://ownload.openoffice.org.  I can find 0.x and 1.x versions though.

I have tried the link from http://udk.openoffice.org/ specifically
http://download.openoffice.org/ure.html but it appears to be broken.

Can anyone point me in the right direction?

Regards,
Robert
Permalink | Reply | 1 comment |

Gmane