Spreadsheets in QuickWin Dialogs

[onkelhotte]

Hi there,

I want to implement a spreadsheet in a QuickWin Dialog. In a list box only onecolumn can be stored.

Aftera whileI found an ActiveX control "Microsoft Office Spreadsheet 10.0 Object" but I dont know how to fill in data in a spreadsheet. I dont even see it in the dialog. Has anybody experience with spreadsheets in QuickWin?

cu,

Markus

[Jugoslav_Dujic]

See this thread for an example using free BabyGrid control. The missing zip is attached below.

Hope this helps.

Jugosav

[Intel_C_Intel]

Have you considered using the AvGrid control? This is the same control that is used in the Array Viewer grid view.

John

[sumitm]

John,

I had a question. I use the AVGRID control for the CVF version. Is it possible in the new IVF version to select the cells with a mouse and "right click" copy. The CVF version does not allow that.

I am interested to know if IVFallows that.

Thanks

[Intel_C_Intel]

The IVF version doesn't have that feature either. I'llwork onimplementing copy&paste in a future release.

John

[onkelhotte]

Thanks for your advice with avgrid, but where can I find it? I searched for avgrid in the CVF Help, but it didnt found one single entry.

When I start the Array Visualizer, I see that grid on the top of the page, but how can I implement that grid on a dialog?

Markus

[sumitm]

Markus,

You can create a dialog box resource and then right click and insert active X control. Select AvisGrid Control. You will be able to do if you have CVF pro or IVF std.

You would also need the attached module inserted in your project. It can be automatically generated also.

Also look into the Animwin32 sample files in the Array Visualizer CD

Hope this helps.

Sumit

[Intel_C_Intel]

Also, if you are a CVF user you need the Pro Edition.

With IVF, the AV controls can be used with the Standard edition, but I think there are still some issues with control usage & Fortran in the current release. These should be resolved once IVF 8.1 comes out.

John

[onkelhotte]

First I want to thank you for your help.

The only problem I have is now, that the grid has to accept Strings as well, but within the Array Viewer I can only create .agl Files with ints and reals. I think that is impossible, right?

So I have to use the BabyGrid Class, but my boss doesnt like 3rd Party Code in our programs :-/

Markus

Message Edited by OnkelHotte on 07-13-2004 12:54 AM

[Intel_C_Intel]

Right, the CVF grid doesn't support strings. Strings are supported in the IVF grid though. Let me know if you upgrade to IVF and I'll create an example to illustrate how to pass a string array to an AV Grid.

John