Archive for the ‘OpenOffice’ Category

OpenOffice.org Developer Article Contest

Thursday, March 23rd, 2006

OpenOffice.org is running a monthly contest for the best Developer Articles on OpenOffice.org.
Articles on porting, add-on and filter development (e.g. new wizards, Calc functions, chart types, etc.), bug fixing, etc are all welcome.
The best article every month win $750.
Maybe I should write something on PyUNO component development?

See the contest rules for more info

OpenOffice.org 2.0.1 release

Thursday, December 22nd, 2005

OpenOffice.org 2.0.1 has been released

Get it from the Irish OpenOffice.org Mirror

OpenOffice.org 2.o

Thursday, October 20th, 2005

OpenOffice.org 2.0 has been released.
Get it from the Irish Mirror here
Debs are available from here for Debian and Ubuntu Users

The great OpenOffice API hack

Thursday, September 22nd, 2005

OpenOffice’s Dispatch API seems like a great big hack and it is something one tries to avoid using when working with the API but
sometimes the API just won’t do what one would like it do i.e. Copying and Pasting content.
The Dispatch API allows developers to execute slots where there is some function in the office but it is not exposed by the API.

In the code below, the slot “.uno:Copy” is being executed, which is the same functionality in the UI as copy (CTRL-C).

executeSlot( ctx, controller, ".uno:Copy" )

def executeSlot( ctx, controller, islot ):

dispatchHelper = ctx.ServiceManager.createInstanceWithContext( \
"com.sun.star.frame.DispatchHelper", ctx )
frame = controller.getFrame()

dispatchHelper.executeDispatch( frame, islot, "", 0, () )

A nicer way to do copy/paste if the API was capable of it, would be:

textEnum = doc1.Text.createEnumeration()
textCursor = doc2.Text.createTextCursor()

while textEnum.hasMoreElements():

para = textEnum.nextElement()

textCursor.insertRange( textCursor, para, absorb )
textCursor.gotoEnd( False )

In the first example, if one wanted to copy and paste content between documents, they are reliant on the operating system’s clipboard
In the second example, the code is only reliant on OpenOffice but the there is no insertRange() function on textCursors.

Which is a nice solution do you think? :-)

XPCOM <-> UNO Bridge

Tuesday, August 30th, 2005

There is an XPCOM to UNO bridge in OpenOffice CVS.

The full OpenOffice API is available through the bridge to any JavaScript applications.

Have a look at the README if you are interested and follow the “xpcom_uno module” thread on the UDK dev mailing list

There could be a number of interesting applications that would use this bridge.

Thanks to Daniel Boelzle and the udk team for this.

User Defined Attributes in OpenOffice.org

Monday, May 9th, 2005

This is nice bit of code to create user defined attributes as part of properties of services in OpenOffice.org

userAttrs = cell.getPropertyValue( "UserDefinedAttributes" )
myAttr = uno.createUnoStruct( "com.sun.star.xml.AttributeData" )
myAttr.Type = "CDATA"
myAttr.Value = "MyURL"
userAttrs.insertByName( "url", myAttr )

Thanks to DannyB on OOoForums.org for this.

Microsoft using OpenOffice.org

Friday, October 29th, 2004

OpenOffice.org being used for a presentation by Microsoft

If that’s not a great big vindication for OpenOffice.org, I don’t know what it is, :-D

OpenOffice.org 2.o

Wednesday, October 20th, 2004

For all the new features due in OpenOffice.org check out the new features page on the OpenOffice.org marketing website

Maturity of PyUNO

Tuesday, September 28th, 2004

PyUNO came up a few times during OOoCon.
A few people expressed a concern about the maturity of PyUNO, well I want to cast away any shadows of doubt, PyUNO is definitely mature, so mature we use it in a production enviroment, we have approximately 70000 lines of python code that uses PyUNO in the Parliamentary Workbench and we are selling this stuff to governments. So YES PyUNO is mature enough to use in a production environment

Python 2.3.4 in OOo

Thursday, August 12th, 2004

http://www.openoffice.org/issues/show_bug.cgi?id=32901
Caolan to test it on linux

Accented chars in URLs

Tuesday, July 20th, 2004

I was going through this pain for the last while, but I have figured this out:

Character

Firefox

OpenOffice.org

ASCII

Á %C1 %C3%81 0193
á %E1 %C3%A1 0225
É %C9 %C3%89 0201
é %E9 %C3%A9 0233
Í %CD %C3%8D 0205
í %ED %C3%AD 0237
Ó %D3 %C3%93 0211
ó %F3 %C3%B3 0243
Ú %DA %C3%9A 0218
ú %FA %C3%BA 0250

X-Refs in OpenOffice

Thursday, July 15th, 2004

Thanks to Andrew Pitonyak for this.
To update Cross References call document.getTextFields().refresh() Cool :D

loadComponentFromURL Hell

Saturday, July 3rd, 2004

I am in a world of loadComponentFromURL() hell try to load file:///c:/pwb/workspace/déil/EN/Óire/doc.sxw. Accented characters in the URL seem to be blowing it :cry:

Fragmentation

Friday, June 18th, 2004

Daniel Carrera and Shawn McDermott have brought a lot of enthusiasm to the OpenOffice.org project with their CO-Operative Project. But there has been a lot of arguments between projects which has been a drain to people working on it :( and I am not sure or bothered to understand the arguments.

Anyway I am going to help with the writing Dev Primer on the CO-Operative Project as it is a Plone site and other people can edit my documents :D

Dunc’s blog

Thursday, June 10th, 2004

Dunc got a blog
He should get it added to Planet OpenOffice