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 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
-
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...
-
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...
is there any other way to debug? :~
Fold With Us! Sie wollen mein Herz am rechten Fleck, doch Seh' ich dann nach unten weg Da schlägt es links
-
Try 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
vsFlexGrid is nothing more than a flexible grid. It will not do what you want it to do (formulas, etc) The closest that I am aware of is farpoint spread (as mentioned in previous postings) the website however is: http://www.fpoint.com/[^] gl David
-
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 been using the SyncFusion Essential Suite (including the grid) for a couple of years now (see http://www.syncfusion.com). I'm quite pleased with the capabilities of the grid; you can do anything with it. The support from Syncfusion is excellent. The only drawback is the cost. I bought the Full Source code version back when the suite first came out and have renewed my subscription twice. The component that exports to excel is ExcelRW; it can be used independantly from the grid control. One of the demos that they ship includes a spreadheet app that looks exactly like Excel. If you have the $$ and 30 days then you should try it; there is 30-day money back guarantee. -Roy
-
Donno... "The Hut" sounds just a bit ominous... :~
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 could say the same thing about "Club" :suss: Steve
-
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
It's actually a pretty good control. FarPoint - the company - has been in business making spread controls for many, many years since the advent of OLE controls. I've evaluated their .NET component at a previous job and it has great compatibility with Excel and exhibits many of the basic functions of Excel. The more advanced functions are left up to you to implement if necessary, but does boast many great features. I don't care one way or another but just giving some feedback so you don't waste a good option based on some marketing gimmick on their web site. :) This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog]
-
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 MaunderWell, i tried "evaluating" FarPoint , ComponentOne, Syncfusion spreadsheet controls. I am leaning...towards FarPoint, seemingly the best suited for my app needs, hopefully it goes well. Again, it all depends on what "powers that be" decide to go with. Thanks for all your help, folks! 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