Non Excel Spreadsheet

I would like to find a control that is similar to a spreadsheet that allows me to edit any column. I found out that the listView or whatever it is called only allows you to edit one column. I do not want the users to have to have Excel. I also would prefer a small DLL if it is required. I guess I could design my own, but I think a pre-made control would make life much easier. Thanks.


http://www.visualbasicforum.com/showthread.php?t=222688&highlight=spreadsheet

http://www.google.com/search?q=-Excel+Spreadsheet+vb6&hl=en&lr=&safe=off&rls=GGLG,GGLG:2005-24,GGLG:en&start=10&sa=N

FarPoint Spread (http://www.fpoint.com/products/spread/spread.aspx)

The only problem is that you have to buy it, and it ain't cheap :(
But it can do pretty much everything that Excel can, and comes with its own formula engine.

That is cool, but I am looking for something free. Or at least real cheap. Besides, would I have to pay $500 per copy of my software I sold? I am making $15 software, so I would have to charge $515.00. LOL
FarPoint Spread (http://www.fpoint.com/products/spread/spread.aspx)

The only problem is that you have to buy it, and it ain't cheap :(
But it can do pretty much everything that Excel can, and comes with its own formula engine.

Besides, would I have to pay $500 per copy of my software I sold? I am making $15 software, so I would have to charge $515.00. LOL

from the site:

"Licensing is one copy per developer. There are no additional run-time or royalty fees when used in accordance with the license agreement. If you have 10 developers, you will need to purchase 10 licenses and can deploy to any number of users. Please refer to the license agreement for full details."

Free is better though. Do you know if there are any free solutions? I dont need any features really. I just want a nice easy way for users to edit 2 columns instead of using a text box. I want to give the users just a bit more flexibility in there editing, they do not need formulas or anything really. I only sell about $500 per year of the software anyway, so I really dont want to spend that on a minor feature.

Yeah, I prefer free too :)
I assumed you knew about the MSFlexgrid or MSHFlexgrid components and needed something more, but if a simple table is all you're after, those are more than adequate.

Yup, sorry for being dumb, I have not done much with those controls yet. What is the diffrence between them and do you know the DLLs required for each? Thanks.

Add the control you want as a component to your project. It tells you where the .ocx files are located.
To decide which you want...
http://msdn.microsoft.com/library/en-us/mshflx98/html/vbctlMSFlexGridControl.asp
http://msdn.microsoft.com/library/en-us/mshflx98/html/vbctlMSHFlexGridControl.asp

They seem very similar. Both can do pics and text and sort... The only thing I see diffrent is the Hierarchical stuff. What is this? Is that like a relational database?

For all kind of samples using the MSFlexGrid control have a look at the .. thread.
The hierarchical "stuff" is indeed when dealing with SHAPED sql queries.

How is shaped SQL diffrent from regular SQL? Also I am not familiar with ADO very much. I know it means abstract data object. It sounds like it is similar to .NET where you use Microsoft Jet and connect to a databse with data view and data sets and all that good stuff. I guess I need to do database stuff with VB6 sometime to get a better appreciation.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscshapecommandsingeneral.asp

You may also want to have a look at MS's Office Web Components (OWC). They include a Spreadsheet control that looks and feels quite similar to an Excel worksheet.

Does MS Office Web Component require the clients to have Microsoft Office?
You may also want to have a look at MS's Office Web Components (OWC). They include a Spreadsheet control that looks and feels quite similar to an Excel worksheet.

No, you can download them from MS for free.