How would i go about programming an excel like worksheet??
-
I generally mean the cell like structure.. Is this jsut a panel with a grid on it and mouse events to track which cell the user mouse is over??
kranius wrote:
I generally mean the cell like structure.. Is this jsut a panel with a grid on it and mouse events to track which cell the user mouse is over??
Perhaps a DataGridView would be a place to start. Just a suggestion. I'm sure there are an infinite number of ways to solve the problem, but I'd likely start there. Good Luck
“You can't teach people to be lazy - either they have it, or they don't.” -Dagwood Bumbstead
-
I generally mean the cell like structure.. Is this jsut a panel with a grid on it and mouse events to track which cell the user mouse is over??
In terms of data structures how about: An array may be a structure that works as you can reference the row and column directly just like a spreadsheet.
You always pass failure on the way to success.
-
I generally mean the cell like structure.. Is this jsut a panel with a grid on it and mouse events to track which cell the user mouse is over??
Before you think about how you are going to represent the data visually, you would be well advised to consider how it is represented in code. Would you store your information in a 2D array, or some other structure? Hint - the 2D version is very, very innefficient. Now, on the surface it would seem that you would be well advised to use a 2D structure because that mimics the layout of the cells very well, but as soon as your cell sizes grows to any distance then the memory consumption will go right through the roof. You can simulate the 2D structure with an algorithm such as a sparse-array which is much more memory efficient.
Deja View - the feeling that you've seen this post before.
-
Before you think about how you are going to represent the data visually, you would be well advised to consider how it is represented in code. Would you store your information in a 2D array, or some other structure? Hint - the 2D version is very, very innefficient. Now, on the surface it would seem that you would be well advised to use a 2D structure because that mimics the layout of the cells very well, but as soon as your cell sizes grows to any distance then the memory consumption will go right through the roof. You can simulate the 2D structure with an algorithm such as a sparse-array which is much more memory efficient.
Deja View - the feeling that you've seen this post before.