Job Budget: $50 Bids/ Views: 3 / 340

Time Remaining: 4d 0h 60m (ends Aug 05, 2008 02:42 U.S. Eastern Time)


Job Description
1. a Visual Basic 6 test application which accesses Writer and Calc of the newest version of OpenOffice.org 3.0 (Beta 2 at the moment)
2. an OpenOffice 3 Calc template sheet with some OOo-Basic.


The VB application has to use OpenOffice 3 Writer and
- open and close Writer
- open, save and close a Writer document
- save, export or print a document as pdf
- merge a document with data (like address)
- merge a document with data (stored in a Calc File)


The VB application has to use OpenOffice 3 Calc and
- open and close Calc
- open, save and close a Calc sheet
- import and export a tab delimited data base (CrLf as record delimiter) of 10000 records quickly into a template sheet (e.g. pasting from clip board)
- reads, writes and change color of OpenOffice 3 Calc fields


The template sheet has to contain a some OOo-Basic code that
- loads data from a tab delimited database (about 10000 records with 20 fields) when loaded
- react on "Field change", click and right-click by starting a procedure
- starts an external application (Run WriteToTab.exe with parameters)

Links that could help:
http://api.openoffice.org/
http://wiki.services.openoffice.org/wiki/D..._Event_Handlers
http://www.business-spreadsheets.com/vba2oo.asp

Commands to use:
.getCellByPosition
.setPropertyValue("CellBackColor", RGB(0, 0, 255))



With skills in VB6, OpenOffice / OOo Basic and the OpenOffice API this task should need about 10 hours and be completed within one week.
This is a test project to see how development cooperation will work. That's why we offer 50 USD payable after checking the results which contain

- a error-free working compiled VB6 application
- a error-free working template sheet
- the sources of the VB 6 project and the template sheet

The coding and testing will be carried out on our Windows 2003 Servers for controlling purposes and to discuss the results.

more details, go to http://www.mytino.com/jobs/job_details.php?id=1232