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


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

Open Office automation causes crash after bBrowser invokes

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2011-12-15 00:39 +0100
Last post2012-01-10 16:03 -0700
Articles 11 — 6 participants

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


Contents

  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

#2688 — Open Office automation causes crash after bBrowser invokes

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-12-15 00:39 +0100
SubjectOpen 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]


#2689

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2011-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]


#2690

FromJohn Martens <adsl672100@tiscali.nl>
Date2011-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]


#2696

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-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]


#2700

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2011-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]


#2713

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-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]


#2715

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2011-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]


#2717

From"Willie Moore" <williem@wmconsulting.com>
Date2011-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]


#2720

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-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]


#2721

FromE®!k \\/!$$E® <nospam@nospam.url>
Date2011-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]


#2799

FromOskar Atkinson <Oskar@atk-it.com>
Date2012-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