I am going to develop a spreadsheet program. For now, it will only accept string data into cells, save them to and open them from file.
My question is, what approach should I take to display the cells
Should I use common controls like TextBox for each cell or should I store the contents, size and location of the cell in an object and use GDI to display them
I have this confusion because, either approach has its own advantages and disadvantages.
Using TextBox for each cell becomes practically impossible when the number of cells is very large. But when using GDI, I have to write lots of code to put the editing and other functionality that a common Textbox provides!
Which is the better among the two
If there exists any other approach, I'd sure like to know about it.
Thanks.
My question is, what approach should I take to display the cells
Should I use common controls like TextBox for each cell or should I store the contents, size and location of the cell in an object and use GDI to display them
I have this confusion because, either approach has its own advantages and disadvantages.
Using TextBox for each cell becomes practically impossible when the number of cells is very large. But when using GDI, I have to write lots of code to put the editing and other functionality that a common Textbox provides!
Which is the better among the two
If there exists any other approach, I'd sure like to know about it.
Thanks.
Designing cells for spreadsheet program
Bathisar
Hi. It is not necessary to create a TextBox for each cell. When user clicks on a cell you can create the TextBox at runtime then you let the user input some data and when the user hits enter or the control looses focus you get the data, you print it using GDI and then destroy the TextBox. If you want you can create the TextBox and hide an show it depending which cell the user clicks setting the TextBox Location property.