Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1702 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2011-07-19 17:20 +0200 |
| Last post | 2011-07-20 10:16 +0200 |
| Articles | 6 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-07-19 17:20 +0200 |
| Subject | Open 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-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]
| From | Carlos Rocha <carlos.rochaDELETETHIS@doossier.com> |
|---|---|
| Date | 2011-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-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]
| From | Herberṫ Puṫz <newsgroupspam@mnet-online.de> |
|---|---|
| Date | 2011-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]
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Date | 2011-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