Spreadsheet control
-
Hey, I am looking for a spreadsheet component or control for a winform application( like Excel, but cannot use Excel :^) ) I was hoping someone out there could help me out! Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris Maunder -
Hey, I am looking for a spreadsheet component or control for a winform application( like Excel, but cannot use Excel :^) ) I was hoping someone out there could help me out! Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris MaunderThere are more grid controls out there than you can shake a stick at. Some are more like spreadsheets, some not so much. Spec out your requirements first, then see what's available that meets them.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
There are more grid controls out there than you can shake a stick at. Some are more like spreadsheets, some not so much. Spec out your requirements first, then see what's available that meets them.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
Yes I know. What my company wants is almost all features of Excel without actually using Excel, and its driving me up the "wall"! :sigh: Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris Maunder -
There are more grid controls out there than you can shake a stick at. Some are more like spreadsheets, some not so much. Spec out your requirements first, then see what's available that meets them.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
Shog9 wrote: you can shake a stick at Out of curiosity - Why would I want to shake a stick at a grid control? Is this some sort of debugging witchcraft I've not heard of before?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
Shog9 wrote: you can shake a stick at Out of curiosity - Why would I want to shake a stick at a grid control? Is this some sort of debugging witchcraft I've not heard of before?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Colin Angus Mackay wrote: Is this some sort of debugging witchcraft And you probably have not heard of Justin Wilson or his late hunting dog Phideaux. (yes local humor.) :rose: I do not mind getting old. It beats all the other options that can think of.
-
Colin Angus Mackay wrote: Is this some sort of debugging witchcraft And you probably have not heard of Justin Wilson or his late hunting dog Phideaux. (yes local humor.) :rose: I do not mind getting old. It beats all the other options that can think of.
Michael A. Barnhart wrote: And you probably have not heard of Justin Wilson or his late hunting dog Phideaux. That is right - I have not heard of them.
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
Shog9 wrote: you can shake a stick at Out of curiosity - Why would I want to shake a stick at a grid control? Is this some sort of debugging witchcraft I've not heard of before?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Colin Angus Mackay wrote: Is this some sort of debugging witchcraft I've not heard of before? Yeah. The "stick" is your middle finger, see, and you shake it at a grid control after spending 16 hours debugging memory leaks that end up making it nearly useless, but not quite useless enough to justify re-writing your entire app just then.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
Yes I know. What my company wants is almost all features of Excel without actually using Excel, and its driving me up the "wall"! :sigh: Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris MaunderWell, Farpoint's spreadsheet control is advertised on CP. Haven't used it myself though. As you probably already know, it's cheaper to buy Excel than it is to re-implement it... But maybe this'll get you part way there.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
Hey, I am looking for a spreadsheet component or control for a winform application( like Excel, but cannot use Excel :^) ) I was hoping someone out there could help me out! Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris MaunderI'm currently looking into the same thing. In particular, I need a spreadsheet control that can export to Excel (in *.XLS format). Currently, I'm looking into the following: - Farpoint http://www.fpoint.com/netproducts/spreadwin/spreadwin.aspx[^] - SyncFusion http://www.syncfusion.com/Products/product.aspx?p=5[^] I've used the OCX version of Farpoint's grid control before. It worked beautifully. My only beef with it was its horrendous memory usage. However, I haven't tried their WinForms version yet.
-
Hey, I am looking for a spreadsheet component or control for a winform application( like Excel, but cannot use Excel :^) ) I was hoping someone out there could help me out! Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris MaunderTry ComponentOne's VSFlexGrid. I do believe it's advertized here as well. "For that one fraction of a second, you were open to options you would never have considered. That is the exploration that awaits you. Not mapping stars and studying nebula, but charting the unknown possibilities of existence." - Q (Star Trek: The Next Generation) ^ Blog
-
Colin Angus Mackay wrote: Is this some sort of debugging witchcraft I've not heard of before? Yeah. The "stick" is your middle finger, see, and you shake it at a grid control after spending 16 hours debugging memory leaks that end up making it nearly useless, but not quite useless enough to justify re-writing your entire app just then.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
So that's what I've been doing at the end of the day for the last 10 years. Shaking the stick. :) -- My name in Katakana is ヨレゲン. My name in German is Jörgen. I blog too now[^]
-
So that's what I've been doing at the end of the day for the last 10 years. Shaking the stick. :) -- My name in Katakana is ヨレゲン. My name in German is Jörgen. I blog too now[^]
:laugh::laugh::laugh:
Fold With Us! Sie wollen mein Herz am rechten Fleck, doch Seh' ich dann nach unten weg Da schlägt es links
-
Hey, I am looking for a spreadsheet component or control for a winform application( like Excel, but cannot use Excel :^) ) I was hoping someone out there could help me out! Cheers! Looney Tunezez "If you build it.... .....BUGS will come!" -JB
Application.Run(new Form1(this.Dispose())); <--WHAT :wtf::confused::eek:
"Stability. What an interesting concept" - Chris MaunderI've had experience with several spreadsheet controls both COM and .NET based. ComponentOne's spreadsheet component is OK, however, it doesn't support formulas, defined names, nor does it provide a spreadsheet UI right out of the box. You have to mix and match it with one of its grid components to get the UI up and running, however, advanced speadsheet UI's, one's that make extensive use of merged cells, cell spanning, etc... don't go very well. Currently I am using just the spreadsheet component alone, without the UI, for exporting reports to xls format. It's great, fast as hell and lightweight, and it does allow you to load xls files, modify them, and then save them back to xls format. GrapeCity also has a decent spreadsheet control, far more advanced than component one's in terms of UI and formula support. However, it doesn't support defined names, nor can you load an xls file, which sucks. For .NET Farpoint's is by far the best spreadsheet control I've used. It isn't the fastest nor the lightest; however, it has an excellent calculation engine, which allows you to create your own formulas. However, three things I didn't like about the calculation engine is that it just takes one non numeric value for an entire formula to spit out an error value instead of ignoring just that value, unlike excel, which doesn't return an error code. for example, if your formula is the sum of SUM(A1,A2,A3) and A1 has the value "foo" farpoint's calculation engine will spit out an error code while excel will return the sum of A2 and A3. The second thing I didn't like about it is that formulas don't support cross sheet referencing, that is, you can't have a formula in Sheet2 that references a value in Sheet1, which sucks, especially for complex models. Third, although it allows you to create your user defined formulas, you can't load an xls file that contains your user defined formula, probably implemented as a vba function, because any user defined formulas you add to the calculation model prior to loading an xls file get tossed out on load, and if you add the user defined function after you load the file, you have to reset the formula for each and every cell that contains the user defined function. Farpoint's spreadsheet UI is also pretty when compared to that of other spreadsheet UI's, it certainly supports the most features; however, all depending on how your xls file looks like, weird will happen. for example, border handling was bizarre. in excel, one cell's right border is the following cell's left border
-
I've had experience with several spreadsheet controls both COM and .NET based. ComponentOne's spreadsheet component is OK, however, it doesn't support formulas, defined names, nor does it provide a spreadsheet UI right out of the box. You have to mix and match it with one of its grid components to get the UI up and running, however, advanced speadsheet UI's, one's that make extensive use of merged cells, cell spanning, etc... don't go very well. Currently I am using just the spreadsheet component alone, without the UI, for exporting reports to xls format. It's great, fast as hell and lightweight, and it does allow you to load xls files, modify them, and then save them back to xls format. GrapeCity also has a decent spreadsheet control, far more advanced than component one's in terms of UI and formula support. However, it doesn't support defined names, nor can you load an xls file, which sucks. For .NET Farpoint's is by far the best spreadsheet control I've used. It isn't the fastest nor the lightest; however, it has an excellent calculation engine, which allows you to create your own formulas. However, three things I didn't like about the calculation engine is that it just takes one non numeric value for an entire formula to spit out an error value instead of ignoring just that value, unlike excel, which doesn't return an error code. for example, if your formula is the sum of SUM(A1,A2,A3) and A1 has the value "foo" farpoint's calculation engine will spit out an error code while excel will return the sum of A2 and A3. The second thing I didn't like about it is that formulas don't support cross sheet referencing, that is, you can't have a formula in Sheet2 that references a value in Sheet1, which sucks, especially for complex models. Third, although it allows you to create your user defined formulas, you can't load an xls file that contains your user defined formula, probably implemented as a vba function, because any user defined formulas you add to the calculation model prior to loading an xls file get tossed out on load, and if you add the user defined function after you load the file, you have to reset the formula for each and every cell that contains the user defined function. Farpoint's spreadsheet UI is also pretty when compared to that of other spreadsheet UI's, it certainly supports the most features; however, all depending on how your xls file looks like, weird will happen. for example, border handling was bizarre. in excel, one cell's right border is the following cell's left border
Giancarlo Aguilera wrote: However, first, it's COM based, but despite that it's COM based it's still faster than any other .NET component, and I'm talking a .net app. Second, the company went out of business. And third, it's expensive and royalty based. It also has some frustrating resource leaks, at least in the version we use. :mad:
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
Colin Angus Mackay wrote: Is this some sort of debugging witchcraft I've not heard of before? Yeah. The "stick" is your middle finger, see, and you shake it at a grid control after spending 16 hours debugging memory leaks that end up making it nearly useless, but not quite useless enough to justify re-writing your entire app just then.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
Have you ever waved your first at your debugger and cried out with both glee and stress in your voice: "Ha, take that you fucking undefined error!" ? I caught (I think my first) the other day and now I'm paranoid I'll do it when people are around. :-O
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion
-
Well, Farpoint's spreadsheet control is advertised on CP. Haven't used it myself though. As you probably already know, it's cheaper to buy Excel than it is to re-implement it... But maybe this'll get you part way there.
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
What an interesting web site they have. I closed it twice thinking I'd won a free holiday. :suss:
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion
-
What an interesting web site they have. I closed it twice thinking I'd won a free holiday. :suss:
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion
Heh. I want to know who they're trying to sell to, if they think they'll get results with the first bit of text reading "You could win a free..." with nothing resembling product details, or screenshots, or any indication that this is a company selling software components... :rolleyes:
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
Have you ever waved your first at your debugger and cried out with both glee and stress in your voice: "Ha, take that you fucking undefined error!" ? I caught (I think my first) the other day and now I'm paranoid I'll do it when people are around. :-O
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion
My wife interrupted me in the middle of a debugging session the other day. Apparently, i personify the software i work with, and when it's not cooperating i direct at it a fairly constant stream of expletives... and do this aloud... :doh:
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
-
Heh. I want to know who they're trying to sell to, if they think they'll get results with the first bit of text reading "You could win a free..." with nothing resembling product details, or screenshots, or any indication that this is a company selling software components... :rolleyes:
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
Just when I was getting really confused, they confuse me even more! http://www.clubfarpoint.com/FarPointSupportSite/Modules/TheHut/default.aspx[^] Is ClubFarPoint like an 18-30 holiday for .NET Developers?
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion
-
My wife interrupted me in the middle of a debugging session the other day. Apparently, i personify the software i work with, and when it's not cooperating i direct at it a fairly constant stream of expletives... and do this aloud... :doh:
Shog9
I'm not the Jack of Diamonds... I'm not the six of spades. I don't know what you thought; I'm not your astronaut...
I wonder just how common this is? It seems like a logical thing thing to do that when you spend so much time working with and getting to know your code it becomes like a person. I think when you start adding project birthdays to your appointments though it is perhaps time to call for help - or an exorcist.
Ðavid Wulff The Royal Woofle Museum
Audioscrobbler :: dwulffEverybody is entitled to my opinion