1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Test Project VB & OO

Discussion in 'Jobs And Career Discussion' started by edward123, Jul 23, 2008.

  1. edward123

    edward123 New Member

    Joined:
    Jun 3, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page