Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2688 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2011-12-15 00:39 +0100 |
| Last post | 2012-01-10 16:03 -0700 |
| Articles | 11 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Open Office automation causes crash after bBrowser invokes D.J.W. van Kooten <public@ic2remove.this.com> - 2011-12-15 00:39 +0100
Re: Open Office automation causes crash after bBrowser invokes Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2011-12-15 01:35 +0000
Re: Open Office automation causes crash after bBrowser invokes John Martens <adsl672100@tiscali.nl> - 2011-12-15 07:16 +0100
Re: Open Office automation causes crash after bBrowser invokes D.J.W. van Kooten <public@ic2remove.this.com> - 2011-12-15 20:00 +0100
Re: Open Office automation causes crash after bBrowser invokes Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2011-12-17 00:07 +0000
Re: Open Office automation causes crash after bBrowser invokes D.J.W. van Kooten <public@ic2remove.this.com> - 2011-12-18 20:56 +0100
Re: Open Office automation causes crash after bBrowser invokes Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2011-12-18 20:31 +0000
Re: Open Office automation causes crash after bBrowser invokes "Willie Moore" <williem@wmconsulting.com> - 2011-12-18 18:14 -0600
Re: Open Office automation causes crash after bBrowser invokes D.J.W. van Kooten <public@ic2remove.this.com> - 2011-12-19 09:57 +0100
Re: Open Office automation causes crash after bBrowser invokes E®!k \\/!$$E® <nospam@nospam.url> - 2011-12-19 12:17 +0100
Re: Open Office automation causes crash after bBrowser invokes Oskar Atkinson <Oskar@atk-it.com> - 2012-01-10 16:03 -0700
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-12-15 00:39 +0100 |
| Subject | Open Office automation causes crash after bBrowser invokes |
| Message-ID | <1icie71qrvl4tnvtnedmh2reahdgc9cpuh@4ax.com> |
We are experimenting with OpenOffice. It is possible to fill cells of
the spreadsheet, but after this the some next steps in the program
like building a bBrowser yeild a fatal error referring to
Normaliz.dll.
With the code below we've found out that the loadcomponentFromUrl is
where it goes wrong.
Does anyone know how to prevent this?
objServiceManager:=
OLEAutoObject{"com.sun.star.ServiceManager"}
if objServiceManager:Finit
aArgStore:={}
AAdd(aArgStore, OOProperty(objServiceManager,
"Overwrite",.t.))
aArg := {}
AAdd(aArg, OOProperty(objServiceManager,
"DocumentTitle","ooTest"))
AAdd(aArg, OOProperty(objServiceManager, "AsTemplate"
, .f.))
AAdd(aArg, OOProperty(objServiceManager, "Preview" ,
.f.))
AAdd(aArg, OOProperty(objServiceManager, "Hidden" ,
.f.))
AAdd(aArg, OOProperty(objServiceManager, "ReadOnly" ,
.f.))
oStardesktop:=
objServiceManager:CreateInstance("com.sun.star.frame.Desktop")
oDoc :=
oStardesktop:loadComponentFromURL("private:factory/scalc", "_blank",
0, aArg)
Dick
[toc] | [next] | [standalone]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2011-12-15 01:35 +0000 |
| Message-ID | <jcbiv3$e9r$1@speranza.aioe.org> |
| In reply to | #2688 |
Hi Dick,
Seems correct at first sight, thought I don't work with OO for a long time.
Check this link if you didn't already:
http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html
On 14-12-2011 23:39, D.J.W. van Kooten wrote:
> We are experimenting with OpenOffice. It is possible to fill cells of
> the spreadsheet, but after this the some next steps in the program
> like building a bBrowser yeild a fatal error referring to
> Normaliz.dll.
>
> With the code below we've found out that the loadcomponentFromUrl is
> where it goes wrong.
>
> Does anyone know how to prevent this?
>
> objServiceManager:=
> OLEAutoObject{"com.sun.star.ServiceManager"}
> if objServiceManager:Finit
>
> aArgStore:={}
> AAdd(aArgStore, OOProperty(objServiceManager,
> "Overwrite",.t.))
> aArg := {}
> AAdd(aArg, OOProperty(objServiceManager,
> "DocumentTitle","ooTest"))
> AAdd(aArg, OOProperty(objServiceManager, "AsTemplate"
> , .f.))
> AAdd(aArg, OOProperty(objServiceManager, "Preview" ,
> .f.))
> AAdd(aArg, OOProperty(objServiceManager, "Hidden" ,
> .f.))
> AAdd(aArg, OOProperty(objServiceManager, "ReadOnly" ,
> .f.))
>
> oStardesktop:=
> objServiceManager:CreateInstance("com.sun.star.frame.Desktop")
>
> oDoc :=
> oStardesktop:loadComponentFromURL("private:factory/scalc", "_blank",
> 0, aArg)
>
>
> Dick
--
Carlos Rocha
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 111214-1, 14-12-2011
Tested on: 15-12-2011 01:35:48
avast! - copyright (c) 1988-2011 AVAST Software.
http://www.avast.com
[toc] | [prev] | [next] | [standalone]
| From | John Martens <adsl672100@tiscali.nl> |
|---|---|
| Date | 2011-12-15 07:16 +0100 |
| Message-ID | <4ee990ba$0$14712$5fc3050@news.tiscali.nl> |
| In reply to | #2688 |
Does LibreOffice have the same problem ?
It seems that this OO fork moves quicker than the old OO community
John
Op 15-12-2011 0:39, D.J.W. van Kooten schreef:
> We are experimenting with OpenOffice. It is possible to fill cells of
> the spreadsheet, but after this the some next steps in the program
> like building a bBrowser yeild a fatal error referring to
> Normaliz.dll.
>
> With the code below we've found out that the loadcomponentFromUrl is
> where it goes wrong.
>
> Does anyone know how to prevent this?
>
> objServiceManager:=
> OLEAutoObject{"com.sun.star.ServiceManager"}
> if objServiceManager:Finit
>
> aArgStore:={}
> AAdd(aArgStore, OOProperty(objServiceManager,
> "Overwrite",.t.))
> aArg := {}
> AAdd(aArg, OOProperty(objServiceManager,
> "DocumentTitle","ooTest"))
> AAdd(aArg, OOProperty(objServiceManager, "AsTemplate"
> , .f.))
> AAdd(aArg, OOProperty(objServiceManager, "Preview" ,
> ..f.))
> AAdd(aArg, OOProperty(objServiceManager, "Hidden" ,
> ..f.))
> AAdd(aArg, OOProperty(objServiceManager, "ReadOnly" ,
> ..f.))
>
> oStardesktop:=
> objServiceManager:CreateInstance("com.sun.star.frame.Desktop")
>
> oDoc :=
> oStardesktop:loadComponentFromURL("private:factory/scalc", "_blank",
> 0, aArg)
>
>
> Dick
[toc] | [prev] | [next] | [standalone]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-12-15 20:00 +0100 |
| Message-ID | <g8gke7dobmtpks36t94i5h2a8a6h9vor14@4ax.com> |
| In reply to | #2690 |
On Thu, 15 Dec 2011 07:16:39 +0100, John Martens <adsl672100@tiscali.nl> wrote: Hello John, >Does LibreOffice have the same problem ? >It seems that this OO fork moves quicker than the old OO community > Yes, exactly the same problem, but we solved it - thanks to Frans de Wit. I found a link where someone solved a problem by replacing the Oleautoobject instantiation with a call through the Comsdk. This is not updated since 2.7 and Frans wrote back that it would not really be needed (as the COM functionality is much improved in 2.8) but that it it imperative that any object opened is closed in the same (reverse) order using Axit. We used the function OOProperty which returned a local object oProperty which was passed via the array. Now this function places the object directly in the array so it can be Axit-ed after us. That means that we have OO automation well on it's way. We can already create a spreadsheet, put values and layout in the cells. This is basically being done for a client who ordered 20 PC's. The OEM version is the same price as the PC's so they save 8000 euro by not buying Office but using OO instead. If others are interested and provided we get it working 100% we could consider to create a documented VO toolkit for OO automation for a small fee. Dick
[toc] | [prev] | [next] | [standalone]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2011-12-17 00:07 +0000 |
| Message-ID | <jcgmid$nrk$1@speranza.aioe.org> |
| In reply to | #2696 |
Hi Dick, On 15-12-2011 19:00, D.J.W. van Kooten wrote: > If others are interested and provided we get it working 100% we could > consider to create a documented VO toolkit for OO automation for a > small fee. Why not? If you can put command interception to work I'll be interested for sure. Interesting: http://cor4office.blogspot.com/2011/12/libreoffice-35-faster-on-windows-than.html -- Carlos Rocha --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 111216-0, 16-12-2011 Tested on: 17-12-2011 00:07:57 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-12-18 20:56 +0100 |
| Message-ID | <vahse75kemk3696122ognlthogafogjndf@4ax.com> |
| In reply to | #2700 |
On Sat, 17 Dec 2011 00:07:57 +0000, Carlos Rocha <carlos.rocha@doossier.com.removethis> wrote: Hello Carlos, > >Why not? If you can put command interception to work I'll be interested >for sure. It looks like it; one of our employees is working on it so let's wait and see. > >Interesting: >http://cor4office.blogspot.com/2011/12/libreoffice-35-faster-on-windows-than.html The article basically says that LibreOffice is faster than Excel in some respects. But even when it's faster in all respects some day, the majority (MS says 95% OO says 70% so I would estimate it's 85%) of the PC users keep paying an increasing amount of money for MS's mediocre products. Main reason is the fear that something would be slightly different in what they're used too. It has kept me wondering why MS came away with the ribbon. Dick --- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---
[toc] | [prev] | [next] | [standalone]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2011-12-18 20:31 +0000 |
| Message-ID | <jcliki$429$1@speranza.aioe.org> |
| In reply to | #2713 |
Hi Dick >> Why not? If you can put command interception to work I'll be interested >> for sure. > > It looks like it; one of our employees is working on it so let's wait > and see. Fingers crossed. I have some documentation and a sample using OO Basic that seems to work, but the porting I tried to VB is far from perfect. Let me know if your developer needs it. >> Interesting: >> http://cor4office.blogspot.com/2011/12/libreoffice-35-faster-on-windows-than.html > > The article basically says that LibreOffice is faster than Excel in > some respects. But even when it's faster in all respects some day, the > majority (MS says 95% OO says 70% so I would estimate it's 85%) of > the PC users keep paying an increasing amount of money for MS's > mediocre products. Main reason is the fear that something would be > slightly different in what they're used too. > > It has kept me wondering why MS came away with the ribbon. MS actually is a looser in every front but OS and Office (browsers war, web search, mobile stuff). Google is the clear winner. As a global company they will stay in the top places only until a certain line limit is crossed, wherever that line is. -- Carlos Rocha --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 111217-2, 17-12-2011 Tested on: 18-12-2011 20:31:34 avast! - copyright (c) 1988-2011 AVAST Software. http://www.avast.com
[toc] | [prev] | [next] | [standalone]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-12-18 18:14 -0600 |
| Message-ID | <jclvlu$15j$1@speranza.aioe.org> |
| In reply to | #2713 |
Dick, Personally, I like the ribbon control. It is easy to program and I like the way it looks. Regards, Willie Vulcan VIP
[toc] | [prev] | [next] | [standalone]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-12-19 09:57 +0100 |
| Message-ID | <aoute7t63029ifp3a3ehl19odi8ao5c298@4ax.com> |
| In reply to | #2717 |
On Sun, 18 Dec 2011 18:14:54 -0600, "Willie Moore" <williem@wmconsulting.com> wrote: Hello Willie, > >Personally, I like the ribbon control. It is easy to program and I like the >way it looks. > We've been over this before. I can certainly imagine people like the ribbon while others prefer the menus. The arrogance of MS is that they did not leave the user a choice, like e.g.Winzip does: I can use Winzip's menu's in which I find my way much faster and directly switch the ribbon of. It's typical for MS; also the fact that they replaced the much better concept of the Quick start menu by the crippled Pin to taskbar. It can all be restored in W7, but with more effort an average PC user is able to do. So it makes me wonder why people keep buying MS stuff with changed (and less efficient) interfaces while in general most people seem very reluctaant to use anything new when it's even slighltly different. Dick --- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---
[toc] | [prev] | [next] | [standalone]
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Date | 2011-12-19 12:17 +0100 |
| Message-ID | <9l8kqlFp0tU1@mid.individual.net> |
| In reply to | #2688 |
Dick,
Just an idea: why not use the ODF format?
This is a format that can be used with both Open Office and MS Office 2007
SP1 and higher. So it does not limit you to a specific texteditor, you just
generate (or modify) a XML file.
Erik
"D.J.W. van Kooten" schreef in bericht
news:1icie71qrvl4tnvtnedmh2reahdgc9cpuh@4ax.com...
We are experimenting with OpenOffice. It is possible to fill cells of
the spreadsheet, but after this the some next steps in the program
like building a bBrowser yeild a fatal error referring to
Normaliz.dll.
With the code below we've found out that the loadcomponentFromUrl is
where it goes wrong.
Does anyone know how to prevent this?
objServiceManager:=
OLEAutoObject{"com.sun.star.ServiceManager"}
if objServiceManager:Finit
aArgStore:={}
AAdd(aArgStore, OOProperty(objServiceManager,
"Overwrite",.t.))
aArg := {}
AAdd(aArg, OOProperty(objServiceManager,
"DocumentTitle","ooTest"))
AAdd(aArg, OOProperty(objServiceManager, "AsTemplate"
, .f.))
AAdd(aArg, OOProperty(objServiceManager, "Preview" ,
.f.))
AAdd(aArg, OOProperty(objServiceManager, "Hidden" ,
.f.))
AAdd(aArg, OOProperty(objServiceManager, "ReadOnly" ,
.f.))
oStardesktop:=
objServiceManager:CreateInstance("com.sun.star.frame.Desktop")
oDoc :=
oStardesktop:loadComponentFromURL("private:factory/scalc", "_blank",
0, aArg)
Dick
[toc] | [prev] | [next] | [standalone]
| From | Oskar Atkinson <Oskar@atk-it.com> |
|---|---|
| Date | 2012-01-10 16:03 -0700 |
| Message-ID | <9sgpg7lluq2lthq16sd6iaer1sqr70b9j8@4ax.com> |
| In reply to | #2688 |
Dick,
how is it gonig with the OO stuff ?
Thanks
Oskar
On Thu, 15 Dec 2011 00:39:10 +0100, D.J.W. van Kooten <public@ic2remove.this.com> wrote:
>We are experimenting with OpenOffice. It is possible to fill cells of
>the spreadsheet, but after this the some next steps in the program
>like building a bBrowser yeild a fatal error referring to
>Normaliz.dll.
>
>With the code below we've found out that the loadcomponentFromUrl is
>where it goes wrong.
>
>Does anyone know how to prevent this?
>
> objServiceManager:=
>OLEAutoObject{"com.sun.star.ServiceManager"}
> if objServiceManager:Finit
>
> aArgStore:={}
> AAdd(aArgStore, OOProperty(objServiceManager,
>"Overwrite",.t.))
> aArg := {}
> AAdd(aArg, OOProperty(objServiceManager,
>"DocumentTitle","ooTest"))
> AAdd(aArg, OOProperty(objServiceManager, "AsTemplate"
>, .f.))
> AAdd(aArg, OOProperty(objServiceManager, "Preview" ,
>.f.))
> AAdd(aArg, OOProperty(objServiceManager, "Hidden" ,
>.f.))
> AAdd(aArg, OOProperty(objServiceManager, "ReadOnly" ,
>.f.))
>
> oStardesktop:=
>objServiceManager:CreateInstance("com.sun.star.frame.Desktop")
>
> oDoc :=
>oStardesktop:loadComponentFromURL("private:factory/scalc", "_blank",
>0, aArg)
>
>
>Dick
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web