can anybody suggest a grid control ??

[Aussie Rules]

Hi,

I am looking for a grid (winform) that I can use in my application that can
do the following...

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic
calculations

Total Rows - Self calculating total rows (col and row locations). This would
work for when the grid is bound or unbound

Save/export to excel.

Save/load from a access or SQL database.

Thanks

[Mr. Arnold]

"Aussie Rules" <Au*********@nospam.nospamwrote in message
news:uO**************@TK2MSFTNGP03.phx.gbl...

Hi,

I am looking for a grid (winform) that I can use in my application that
can do the following...

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic
calculations

Total Rows - Self calculating total rows (col and row locations). This
would work for when the grid is bound or unbound

Save/export to excel.

Save/load from a access or SQL database.

I used the Farpoint Spreadsheet VB 6 COM component back in 1999-2000 on very
complicated accounting solutions. Hopefully, they still have a trial ware
full featured .Net component like they had for VB 6 that you can try. Or you
could InterOp the COM solution into .Net.

Http://www.fpoint.com/

[Jan Hyde (VB MVP)]

"Mr. Arnold" <MR. Ar****@Arnold.com>'s wild thoughts were
released on Mon, 3 Sep 2007 18:38:25 -0400 bearing the
following fruit:

>
"Aussie Rules" <Au*********@nospam.nospamwrote in message
news:uO**************@TK2MSFTNGP03.phx.gbl...

>Hi,

I am looking for a grid (winform) that I can use in my application that
can do the following...

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic
calculations

Total Rows - Self calculating total rows (col and row locations). This
would work for when the grid is bound or unbound

Save/export to excel.

Save/load from a access or SQL database.

I used the Farpoint Spreadsheet VB 6 COM component back in 1999-2000 on very
complicated accounting solutions. Hopefully, they still have a trial ware
full featured .Net component like they had for VB 6 that you can try. Or you
could InterOp the COM solution into .Net.

Http://www.fpoint.com/

I can second that recommendation. Not sure about built in
calculations as I've never had the need.

My other favorite grid control is by devexpress

www.devexpress.com

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

[Mr. Arnold]

"Jan Hyde (VB MVP)" <St***********@REMOVE.ME.uboot.comwrote in message
news:a7********************************@4ax.com...

"Mr. Arnold" <MR. Ar****@Arnold.com>'s wild thoughts were
released on Mon, 3 Sep 2007 18:38:25 -0400 bearing the
following fruit:

>>
"Aussie Rules" <Au*********@nospam.nospamwrote in message
news:uO**************@TK2MSFTNGP03.phx.gbl...

>>Hi,

I am looking for a grid (winform) that I can use in my application that
can do the following...

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic
calculations

Total Rows - Self calculating total rows (col and row locations). This
would work for when the grid is bound or unbound

Save/export to excel.

Save/load from a access or SQL database.

I used the Farpoint Spreadsheet VB 6 COM component back in 1999-2000 on
very
complicated accounting solutions. Hopefully, they still have a trial ware
full featured .Net component like they had for VB 6 that you can try. Or
you
could InterOp the COM solution into .Net.

Http://www.fpoint.com/

I can second that recommendation. Not sure about built in
calculations as I've never had the need.

My other favorite grid control is by devexpress

www.devexpress.com

Yes I did demo Devexpress back in 2004, and I liked that one as well. The
Farpoint Spread Sheet was simply fabulous, which the MS solutions at the
time just couldn't provide the horsepower that was needed to make the
applications sing and impress the end-user base.

[Jan Hyde (VB MVP)]

"Mr. Arnold" <MR. Ar****@Arnold.com>'s wild thoughts were
released on Tue, 4 Sep 2007 16:06:50 -0400 bearing the
following fruit:

>
"Jan Hyde (VB MVP)" <St***********@REMOVE.ME.uboot.comwrote in message
news:a7********************************@4ax.com.. .

>"Mr. Arnold" <MR. Ar****@Arnold.com>'s wild thoughts were
released on Mon, 3 Sep 2007 18:38:25 -0400 bearing the
following fruit:

>>>
"Aussie Rules" <Au*********@nospam.nospamwrote in message
news:uO**************@TK2MSFTNGP03.phx.gbl...
Hi,

I am looking for a grid (winform) that I can use in my application that
can do the following...

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic
calculations

Total Rows - Self calculating total rows (col and row locations). This
would work for when the grid is bound or unbound

Save/export to excel.

Save/load from a access or SQL database.
I used the Farpoint Spreadsheet VB 6 COM component back in 1999-2000 on
very
complicated accounting solutions. Hopefully, they still have a trial ware
full featured .Net component like they had for VB 6 that you can try. Or
you
could InterOp the COM solution into .Net.

Http://www.fpoint.com/

I can second that recommendation. Not sure about built in
calculations as I've never had the need.

My other favorite grid control is by devexpress

www.devexpress.com

Yes I did demo Devexpress back in 2004, and I liked that one as well. The
Farpoint Spread Sheet was simply fabulous, which the MS solutions at the
time just couldn't provide the horsepower that was needed to make the
applications sing and impress the end-user base.

Devexpress has done a lot since 2004, might be worth
checking back. I'm sure either farpoint or devexpress will
impress and IMO well worth the money.
--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

[williamsonhouse]

Hi Aussie,

Further to what was mentioned, we (FarPoint) do offer a specific .NET
spreadsheet component, Spread for Windows Forms. Here's the link for
the main product page - http://www.fpoint.com/netproducts/sp...spreadwin.aspx.
It does do all that you listed

Cell Calculation.. Like excel does (=sum(cell1 + cell2)) and other basic calculations

Spread for Windows Forms supports well over 300 functions, including
SUM. Here's the page that lists all the supported functions -
http://www.fpoint.com/netproducts/sp...s/default.aspx.
Setting up the formula is very straightforward. This sets up a formula
in cell A1. Spread takes care of the rest:
FpSpread1.Sheets(0).Cells(0, 0).Formula = "SUM(C1:C4)

Save/export to excel.

We read and write native Excel BIFF8 files (Excel 97 and above):
Open an Excel File - FpSpread1.OpenExcel("c:\excelFile.xls")
Save an Excel File - FpSpread1.SaveExcel("c:\excelFile.xls")

Save/load from a access or SQL database.

You can use Spread in bound mode or unbound mode

Following is the link to download a fully-functional 30-day trial:
http://www.clubfarpoint.com/FarPoint...code=spreadwin

If you have any questions, please feel free to make use of our support
forums. They are very quick to answer any questions that you may have:
http://www.clubfarpoint.com/Forums/forums/default.aspx

As an FYI, we do still actively support our VB6 version, Spread 7.

And thanks Jan and Mr. Arnold for the recommendation :)

- Donald
FarPoint Technologies
www.FarPointSpread.com

[Linda Liu [MSFT]]

Hi Aussie,

How about the problem now?

If you need our further assistance, please feel free to let us know.

Thank you for using our MSDN Managed Newsgroup Support Service!

Sincerely,
Linda Liu
Microsoft Online Community Support