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


Groups > comp.lang.clipper.visual-objects > #7034

Re: Spreadsheet-component for use in VO without Excel

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Spreadsheet-component for use in VO without Excel
Date 2014-07-08 14:18 -0500
Organization Aioe.org NNTP Server
Message-ID <lphg6u$ru0$1@speranza.aioe.org> (permalink)
References <02b2d200-51a4-4e0d-b1ac-786f5a71283a@googlegroups.com> <lp9c7u$ck2$1@news.albasani.net> <a20c124a-73d4-4cd6-beee-97e110c9710b@googlegroups.com>

Show all headers | View raw


Thomas,

When you do your createembeding on the OCX, are you including the license 
key?

#define OCX_LICENSE_KEY := "Insert Key Here"
oDCmyOcx := MyOX{self,-1,point{},Dimension{} }
oDCmyOCX:CreateEmbedding("myProgID goes here",OCX_LICENSE_KEY)

Regards,
Willie
Vulcan VIP

"th_grebe"  wrote in message 
news:a20c124a-73d4-4cd6-beee-97e110c9710b@googlegroups.com...

Hi Francesco,

thanks for your support. But what i'm lookig for is not a component to read 
and write from and to excel-files. I have to implement 
spreadsheet-functionalities into my application. The user gets a spreadsheet 
(in a control-container) which is filled with some (steadily changing) data. 
He can use the sheet to define productspecific calculation and fill some 
defined cells with his results . The results will be read by my program. So 
once the user has defined his calculation i can apply this sheet with using 
actual data every day.

I tried FarPoint Spread 8 by ComponentOne but got stuck.
I can place the OCX-Control on my dialog-window an in the window-painter 
everything seems to work. The Spread-OCX issues a message-dialog like other 
OCX-controls do, as long as they are not licensed (trial-version!)
But after compiling the program (even being still in VO development 
environment) i get an error saying that the FPLICENSE.TXT-File can't be 
found.

Bo Jordan (of ComponentOne-support) answered:

"Hello Thomas Grebe,

It sounds like Visual Object supports third-party controls, but not licensed 
third-party controls.  To use Spread, the environment needs to support the 
IClassFactory2 interface for licensed controls (that's how VB and other 
environments get the license and embed it in the EXE).

The behavior described sounds like you are using the Spread in an Office 
application (like Excel or Word) using Visual Basic for Applications to 
script controls on VBA forms -- VBA doesn't support the IClassFactory2 
interface, so licensed controls are always in "design mode" when used that 
way (so it works fine on the developer's machine, and any other licensed 
developer's machine, but not on other people's machines).

I did a quick look here to check if Visual Object mentions licensed ActiveX 
controls, and I don't see that anywhere.  It says Visual Objects can make 
ActiveX controls though, so it looks like it supports making them, but not 
making licensed controls with Visual Objects.  If there's a way to make 
licensed controls in Visual Objects (i.e. make an ActiveX that used 
IClassFactory2 licensing), then it would probably work to use such 
third-party licensed controls (and if it doesn't support making licensed 
controls in Visual Objects, I would expect that no third-party licensed 
contols can work in compiled EXEs)"


Could this really be the problem and if so, is there any workaround?

My knowledge about this OCX-stuff is quite poor. I use OCX-controls, but 
those controls provide specific methods to unlock them by passing 
license-data to function-calls.

Had anybody got that FarPoint-OCX to work in an VO-program?

Again, thanks in advance for any support.

Thomas





Am Samstag, 5. Juli 2014 19:21:50 UTC+2 schrieb Francesco F.:
> Hi Thomas,
>
> look in NG for thread:
>
> "Create Excel File without Ms. Excel inside" in date June 07, 2009
>
>
>
> HTH,
>
> Francesco
>
>
>
>
>
> Il 05/07/2014 15:31, th_grebe ha scritto:
>
> > Has anybody out there made any experience implementing a 
> > spread-sheet-control on a dialog-window without having MS-Excel 
> > installed?
>
> > Are there any VO-compatible ActiveX / OCX - components?
>
> >
>
> > tia
>
> >
>
> > Thomas
>
> > 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Spreadsheet-component for use in VO without Excel th_grebe <th_grebe@t-online.de> - 2014-07-05 06:31 -0700
  Re: Spreadsheet-component for use in VO without Excel "Francesco F." <francescangeli.f.remove@remove.gmail.com> - 2014-07-05 19:21 +0200
    Re: Spreadsheet-component for use in VO without Excel th_grebe <th_grebe@t-online.de> - 2014-07-05 19:28 -0700
      Re: Spreadsheet-component for use in VO without Excel "Willie Moore" <williem@wmconsulting.com> - 2014-07-08 14:18 -0500
  Re: Spreadsheet-component for use in VO without Excel "Francesco F." <francescangeli.f.remove@remove.gmail.com> - 2014-07-05 19:42 +0200

csiph-web