Find Jobs
Hire Freelancers

POC of LibreOffice Excel compatible OLE server

$30-250 USD

Cancelled
Posted about 11 years ago

$30-250 USD

Paid on delivery
Applications can call various MS Excel functions through standard technique called OLE, to prove that it is possible to replace MS Excel with LibreOffice in context of applications using OLE Excel interface it is required to develop a proof-of-concept. Functionality. POC has to: 1. Be an OLE service in Windows XP or Windows 7. 2. Be registered in OS as «[login to view URL]». 3. Provide OLE MS Excel 2007/2010 interface in boundaries required to work to the VBS-script provided in Appendix. 4. OLE Excel requests has to be translated to equivalent API calls of LibreOffice UNO API: VB-script → POC OLE server → LibreOffice UNO API. 5. Results of OLE calls (statues codes, returning data if there are any), has to be passed back to VBS script, as it native OLE Excel does. Additional requirements. POC: 1. Can be written on any programming language, but must not require any of licensed run-time library. 2. Has to work in Windows XP Prof SP3 x32/x64, Windows 7 Prof x32/x64. 3. Version of LibreOffice > 4.0.1.2 or newer. Functionality check. On a computer, where MS Office (MS Excel) has never been installed we install LibreOffice. We install and register POC OLE server (can be done manually following instructions from a developer). Run LibreOffice as UNO server. Run test script. Script has to open LibreOffice Calc, create new spreadsheet file and in the first row, third column it has to insert test string 'Test', or any other value we setup in our test script. Useful links. 1. LibreOffice UNO API [login to view URL] Appendix. Test script: 'Excel example Private Sub cmdExcel_Click() Dim intCol Dim intRow Dim oXL Dim oBook Dim oSheet Dim oRange intCol = 3 intRow = 1 'Load Excel and create the object Set oXL = CreateObject("[login to view URL]") 'Turn off alert messages. [login to view URL] = False 'Load a new workbook and create the workbook object. Set oBook = [login to view URL] 'Create the worksheet object. Set oSheet = [login to view URL](1) 'Enter a value in a cell. [login to view URL](intRow, intCol).Value = "Test" 'Display the Excel session. [login to view URL] = True End Sub cmdExcel_Click
Project ID: 4406595

About the project

6 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $237 USD for this job
User Avatar
I can help implement this POC.
$300 USD in 3 days
5.0 (18 reviews)
4.7
4.7
User Avatar
Please check pmb. Thanks!
$140 USD in 3 days
4.8 (5 reviews)
4.1
4.1
User Avatar
Greetings, I have experience in OLE interfacing MS Office and Open/Libre Office, please check inbox for a simple demo.
$210 USD in 7 days
5.0 (2 reviews)
3.2
3.2
User Avatar
I can help
$300 USD in 3 days
5.0 (3 reviews)
2.3
2.3
User Avatar
Hello, I can do this.
$440 USD in 30 days
5.0 (2 reviews)
2.2
2.2
User Avatar
Dear sir Please let me know your full spec.
$154 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of RUSSIAN FEDERATION
Chelyabinsk, Russian Federation
5.0
1
Payment method verified
Member since Sep 12, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.