Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1702 > unrolled thread

Open Office automation for VO?

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2011-07-19 17:20 +0200
Last post2011-07-20 10:16 +0200
Articles 6 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Open Office automation for VO? D.J.W. van Kooten <public@ic2remove.this.com> - 2011-07-19 17:20 +0200
    Re: Open Office automation for VO? dlzc <dlzc1@cox.net> - 2011-07-19 08:53 -0700
    Re: Open Office automation for VO? Carlos Rocha <carlos.rochaDELETETHIS@doossier.com> - 2011-07-19 20:05 +0100
      Re: Open Office automation for VO? D.J.W. van Kooten <public@ic2remove.this.com> - 2011-07-20 11:14 +0200
        Re: Open Office automation for VO? Herberṫ Puṫz <newsgroupspam@mnet-online.de> - 2011-07-20 12:05 +0200
    Re: Open Office automation for VO? E®!k \\/!$$E® <nospam@nospam.url> - 2011-07-20 10:16 +0200

#1702 — Open Office automation for VO?

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-07-19 17:20 +0200
SubjectOpen Office automation for VO?
Message-ID<pl2b27ptkers6br4i3fjm1ea0ujqg64h2i@4ax.com>
A client of mine is about to buy a larger number of new PC's and they
want to use OpenOffice instead of buying M$ Office licences for every
user. 

I am wondering about the current status of OpenOffice automation. Is
there anybody who currently has got automation to work? Especially the
option to create a spreadsheet from VO would be required.

I remember Carlos was working on it?

Dick

[toc] | [next] | [standalone]


#1704

Fromdlzc <dlzc1@cox.net>
Date2011-07-19 08:53 -0700
Message-ID<f1bf63d6-864d-467a-8dec-b310c00b6925@j9g2000prj.googlegroups.com>
In reply to#1702
Dear D.J.W. van Kooten:

On Jul 19, 8:20 am, D.J.W. van Kooten <pub...@ic2remove.this.com>
wrote:
> A client of mine is about to buy a larger number
> of new PC's and they want to use OpenOffice
> instead of buying M$ Office licences for every
> user.

There has been a change in the "openness" of Open Office.  Ubuntu
(just FYI) no longer is packaged with Open Office, using Libre Office
instead.
http://linux.about.com/b/2011/04/16/oracle-changes-status-of-openoffice-org.htm

This has little to do with your request, just wanted to make sure you
knew.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#1707

FromCarlos Rocha <carlos.rochaDELETETHIS@doossier.com>
Date2011-07-19 20:05 +0100
Message-ID<4e25d776$0$31838$a729d347@news.telepac.pt>
In reply to#1702
Hello Dick,

Lot's of people is using OpenOffice with automation (and the new 
LibreOffice, as David said, that I recomend). Using it is very different 
from using M$Office, but I'm sure it would work for what you want. But 
as I said before, it's not straight forward, you have a lot to learn.

Start here:

http://www.elart.it/vo_openoffice/index_en.php
http://www.oooforum.org/forum/viewforum.phtml?f=9
http://user.services.openoffice.org/en/forum/viewforum.php?f=19&sid=d10b080d5c4c405dacdc0d90ce84f802



> A client of mine is about to buy a larger number of new PC's and they
> want to use OpenOffice instead of buying M$ Office licences for every
> user.
>
> I am wondering about the current status of OpenOffice automation. Is
> there anybody who currently has got automation to work? Especially the
> option to create a spreadsheet from VO would be required.
>
> I remember Carlos was working on it?
>
> Dick

-- 
Carlos Rocha


---
avast! Antivirus: mensagem Enviada limpa.
Base de Dados de virus (VPS): 110719-0, 19-07-2011
Testada a: 19-07-2011 20:05:19
avast! - copyright (c) 1988-2011 AVAST Software.
http://www.avast.com


[toc] | [prev] | [next] | [standalone]


#1711

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-07-20 11:14 +0200
Message-ID<u27d2799ugj9aad8m1bs6mptv1nq2ljmtj@4ax.com>
In reply to#1707
On Tue, 19 Jul 2011 20:05:19 +0100, Carlos Rocha
<carlos.rochaDELETETHIS@doossier.com> wrote:

Hello Carlos,
>
>Lot's of people is using OpenOffice with automation 

What I wonder is: did anyone apply it in VO and willing to share? It
would be nice if we are not re-inventing the wheel one by one.

Dick

[toc] | [prev] | [next] | [standalone]


#1712

FromHerberṫ Puṫz <newsgroupspam@mnet-online.de>
Date2011-07-20 12:05 +0200
Message-ID<q9s4vqw83abg.1b3acqnlona84.dlg@40tude.net>
In reply to#1711
Am Wed, 20 Jul 2011 11:14:59 +0200 schrieb D.J.W. van Kooten:

> 
> What I wonder is: did anyone apply it in VO and willing to share? It
> would be nice if we are not re-inventing the wheel one by one.

Dick,

long time ago :-), I had to fill a calculation-sheet in OO with some data.
Here are some lines of code to use OpenOffice-Calc (using VOCOM)



// Create COM-Object
hRes:=VOCOMCreateObject( "com.sun.star.ServiceManager", @oSCalc)

// Instantiante Calculation-App
oOODoc := oSCalc:createInstance("com.sun.star.frame.Desktop")
aArgs := ArrayNew()
oCalc := oOODoc:loadComponentFromURL("private:factory/scalc", "_blank", 0,
aArgs)

// Read avalaible Formats
oFormat := oCalc:NumberFormats
oLocale := NULL_OBJECT	
nFormat := oFormat:QueryKey( "#.##0,00" , @oLocale, FALSE )

// Read availabel Sheets
oSheets := oCalc:Sheets //alle Sheets auslesen

// Add a Sheet
oSheet := oSheets:InsertNewByName( cSheetName, 1)

// Use a sheet
oSheet := oSheets:GetByIndex( nSheet - 1 )
oSheet:name := cSheetName

// Activate a cell
oCell:=oSheet:GetCellByPosition(0,0)

// Fill a cell with a string
IVarPut( oCell, String2Symbol("string") ,cString)

// Fill a cell with a number
oCell:value := nValue

// Assign a Numberormat to a cell
oCell:numberformat := nFormat

// read columns of the shee		
oColumns := oSheet:Columns

// Autosize Columns
oColumns:GetByIndex(nIndex):OptimalWidth := TRUE


HTH
Herbert

[toc] | [prev] | [next] | [standalone]


#1710

FromE®!k \\/!$$E® <nospam@nospam.url>
Date2011-07-20 10:16 +0200
Message-ID<98nh63F6htU1@mid.individual.net>
In reply to#1702
Hi Dick,

Perhaps you should have a look how to generate a ODS manually. This file can 
be read in both OpenOffice as in MS Office (starting from 2007 SP2)

Erik


"D.J.W. van Kooten"  schreef in bericht 
news:pl2b27ptkers6br4i3fjm1ea0ujqg64h2i@4ax.com...

A client of mine is about to buy a larger number of new PC's and they
want to use OpenOffice instead of buying M$ Office licences for every
user.

I am wondering about the current status of OpenOffice automation. Is
there anybody who currently has got automation to work? Especially the
option to create a spreadsheet from VO would be required.

I remember Carlos was working on it?

Dick 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web