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]

Re: can anybody suggest a grid control ??


"Aussie Rules" <AussieRules@no spam.nospamwrot e in message
news:uOhpoKn7HH A.4304@TK2MSFTN GP03.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)]

Re: can anybody suggest a grid control ??

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

>
>"Aussie Rules" <AussieRules@no spam.nospamwrot e in message
>news:uOhpoKn7H HA.4304@TK2MSFT NGP03.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

https://www.devexpress.com

--
Jan Hyde

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

[Mr. Arnold]

Re: can anybody suggest a grid control ??


"Jan Hyde (VB MVP)" <StellaDrinker@ REMOVE.ME.uboot .comwrote in message
news:a7gqd31apb ioou8ds34veh99q empl2jfos@4ax.c om...

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

>>
>>"Aussie Rules" <AussieRules@no spam.nospamwrot e in message
>>news:uOhpoKn7 HHA.4304@TK2MSF TNGP03.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
>>calculation s
>>>
>>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
>

https://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)]

Re: can anybody suggest a grid control ??

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

>
>"Jan Hyde (VB MVP)" <StellaDrinker@ REMOVE.ME.uboot .comwrote in message
>news:a7gqd31ap bioou8ds34veh99 qempl2jfos@4ax. com...

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

>>>
>>>"Aussie Rules" <AussieRules@no spam.nospamwrot e in message
>>>news:uOhpoKn 7HHA.4304@TK2MS FTNGP03.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
>>>calculatio ns
>>>>
>>>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
>>>complicate d 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@gmail.com]

Re: can anybody suggest a grid control ??

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.Sheet s(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.OpenE xcel("c:\excelF ile.xls")
Save an Excel File - FpSpread1.SaveE xcel("c:\excelF ile.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/FarPointSupportSite/Modules/Download/trials.aspx?pcode=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

https://www.FarPointSpread.com

[Linda Liu [MSFT]]

RE: can anybody suggest a grid control ??

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