Thanks to everyone who responded.
Laurie
From: Jean MAURICE jsm.maur...@wanadoo.fr
To: profox@leafe.com
Sent: Tuesday, 4 February 2014, 5:29
Subject: Re: Openoffice
Le 03/02/2014 18:13, Rafael Copquin a écrit :
Hi Jean Maurice
You can send it to me and I
Anyone know if the Openoffice apps (principally WP and spreadsheet) expose an
object model suitable for VFP automation?
TIA.
Laurie
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
On Mon, Feb 3, 2014, at 03:50 PM, Laurie Alvey wrote:
Anyone know if the Openoffice apps (principally WP and spreadsheet)
expose an object model suitable for VFP automation?
If you're actually talking OpenOffice, as opposed to LibreOffice, here's
at least one example:
http://fox.wikis.com
On Mon, Feb 3, 2014, at 03:50 PM, Laurie Alvey wrote:
Anyone know if the Openoffice apps (principally WP and spreadsheet)
expose an object model suitable for VFP automation?
And here's more from the distinguished Mr Roche.
http://www.tedroche.com/Present/2004/VFPOOoAutomation.htm
Dunno
Laurie,
long time ago, I began to buid a library to interface VFP with Open Office. If
you can read simple French, I can send it to you as 'it is'.
I you can't, you'll have to wait some days that I write some english comment.
When I built it, it was OpenOffice 2 (!), I don't know if it still
as 'it is'.
I you can't, you'll have to wait some days that I write some english
comment.
When I built it, it was OpenOffice 2 (!), I don't know if it still
works, but I can give a try this evening ...
The Foxil
[excessive quoting removed by server
On 3 February 2014 16:01, Alan Bourke alanpbou...@fastmail.fm wrote:
On Mon, Feb 3, 2014, at 03:50 PM, Laurie Alvey wrote:
Anyone know if the Openoffice apps (principally WP and spreadsheet)
expose an object model suitable for VFP automation?
If you're actually talking OpenOffice, as opposed
On Mon, 3 Feb 2014 19:18:38 +, Paul Hill paulroberth...@gmail.com wrote:
On 3 February 2014 16:01, Alan Bourke alanpbou...@fastmail.fm wrote:
On Mon, Feb 3, 2014, at 03:50 PM, Laurie Alvey wrote:
Anyone know if the Openoffice apps (principally WP and spreadsheet)
expose an object model
On Mon, Feb 3, 2014 at 2:23 PM, Gianni Turri gianni...@gmail.com wrote:
The Ted Roche sample posted by Alan works in LibreOffice without a hitch.
Wish that were true of all my 10-year-old code!
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body --
Le 03/02/2014 18:13, Rafael Copquin a écrit :
Hi Jean Maurice
You can send it to me and I shall try to translate it, if it is not too long
Rafael Copquin
Hi Rafael,
it's so old I forgot I already put the library on the web. You can download it
here :
Client has sent me a XLSX file. I open it in OpenOffice.org and it just
shows $- in the display of the cell. The cell formula is right though,
(E4*D4).
Why doesn't it show the computed value?
tia,
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
-Original Message-
From: profoxtech-boun...@leafe.com
[mailto:profoxtech-boun...@leafe.com]
On Behalf Of MB Software Solutions,LLC
Sent: Monday, May 03, 2010 9:25 AM
To: profoxt...@leafe.com
Subject: [NF] SUMS not showing values in openoffice spreadsheet
Why doesn't it show
Client has sent me a XLSX file. I open it in OpenOffice.org and it just
shows $- in the display of the cell. The cell formula is right though,
(E4*D4).
Why doesn't it show the computed value?
tia,
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
I need to do the following:
create a cursor from a select statement
instantiate an OpenOffice scal object (this would be equivalent to instantiate
an Excel object)
send all data from the cursor to the OO object
show the resulting sheet to the user
Now, I have seen a few examples by googling
Rafael Copquin wrote:
I need to do the following:
create a cursor from a select statement
instantiate an OpenOffice scal object (this would be equivalent to
instantiate an Excel object)
send all data from the cursor to the OO object
show the resulting sheet to the user
Now, I have
and OpenOffice automation
Rafael Copquin wrote:
I need to do the following:
create a cursor from a select statement
instantiate an OpenOffice scal object (this would be equivalent to
instantiate an Excel object)
send all data from the cursor to the OO object
show the resulting sheet to the user
I'd like to see that as well - it will be interesting to see if it works on
my machine where Excel is the default handler for XLS.
John
John Weller
01380 723235
07976 393631
Smart solution!
Could you post an example, especially of the call to the shellexecute?
Rafael
Rafael Copquin wrote:
Smart solution!
Could you post an example, especially of the call to the shellexecute?
Here's a snippet with that code:
SELECT curOutput
DO CASE
CASE this.nOutputType = 2 only students with
If OpenOffice is not the default application for XLS files, your code
can still be used provided the application knew where the OO
application was installed. Simply change the ShellExecute command to
launch the OO program and pass the file name of the XLS file to it as
a parameter. Although
Steve Ellenoff wrote:
If OpenOffice is not the default application for XLS files, your code
can still be used provided the application knew where the OO
application was installed. Simply change the ShellExecute command to
launch the OO program and pass the file name of the XLS file
Thanks Mike
I know I can always count on you (:-)
Rafael Copquin
- Original Message -
From: MB Software Solutions,LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com
To: profoxt...@leafe.com
Sent: Friday, September 11, 2009 1:47 PM
Subject: Re: vfp and OpenOffice automation
Rafael
I agree.
Rafael Copquin
- Original Message -
From: MB Software Solutions,LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com
To: profoxt...@leafe.com
Sent: Friday, September 11, 2009 2:37 PM
Subject: Re: vfp and OpenOffice automation
Steve Ellenoff wrote:
If OpenOffice
I just got the following code from a local programmer. I tried it and it
works perfectly.
= OpenOfficeElectronicSheet('c:\contable\asientos.xls')
FUNCTION OpenOfficeElectronicSheet
lparameters _cFilePath As String
Dimension args(1)
loOfcMgr = Createobject(com.sun.star.ServiceManager)
One of my clients is about to install OpenOffice in one of his computers. My
question to you guys is whether or not the automation feature of VFP is
compatible with that software.
In other words, shall I be able to use spreadsheets and documents generated by
OpenOffice, through automation
Rafael
Have a look at Tek-Tips
http://www.tek-tips.com/viewthread.cfm?qid=1514000page=2
Andrew Stirling
01250 874580
http://www.calcpay.co.uk
HMRC Accredited UK payroll program
Rafael Copquin wrote:
One of my clients is about to install OpenOffice in one of his computers. My
question
Hi Gang,
Has anyone here any experience of automated mail merge with Open/Star Office?
Currently I support merging from Excel into Word (for mailshots etc)
but I have some customers asking about the possibility of using OO.
--
Paul
___
Post
...@leafe.com] On Behalf
Of Paul Hill
Sent: 09 January 2009 09:50
To: ProFox Email List
Subject: OpenOffice mail merge
Hi Gang,
Has anyone here any experience of automated mail merge with Open/Star
Office?
Currently I support merging from Excel into Word (for mailshots etc)
but I have some customers
: OpenOffice mail merge
Hi Gang,
Has anyone here any experience of automated mail merge with Open/Star
Office?
Currently I support merging from Excel into Word (for mailshots etc)
but I have some customers asking about the possibility of using OO.
--
Paul
[excessive quoting removed by server
January 2009 09:50
To: ProFox Email List
Subject: OpenOffice mail merge
Hi Gang,
Has anyone here any experience of automated mail merge with Open/Star
Office?
Currently I support merging from Excel into Word (for mailshots etc)
but I have some customers asking about the possibility of using OO
Paul
There is something on tec-tips.com
http://www.tek-tips.com/viewthread.cfm?qid=1514000page=1
Andrew Stirling
01250 874580
http://www.calcpay.co.uk
HMRC Accredited UK payroll program
Paul Hill wrote:
Hi Gang,
Has anyone here any experience of automated mail merge with Open/Star
http://download.microsoft.com/download/5/f/4/5f4c83d3-833e-4f11-8cbd-699b0c1
64182/royaltyoemreferencesheet.pdf
As if that was not a strong enough article unto itself, check this out.
This is far more specific re: IBM trying to ouster the MS Office app
offering. Do I hear the tolling of The
Complete with hilarious Notes flame war in the comments. Notes is great
functionally, but any version I ever saw looked cack in the UI
department.
--
Alan Bourke
[EMAIL PROTECTED]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
32 matches
Mail list logo