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/Documentation/DevGuide/Basic/Adding_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
