Just as lots of you have already had to deal with, my Excel app broke when my company moved to from Office 2000 to Office 2007 and the FlexGrid control went away.
So I've been fighting with the Spreadsheet control this week, trying to get it to act like FlexGrid, and I have some questions and things to confirm that I figure/hope you all have already dealt with and overcome.
1) I want exactly six columns in my grid. I figured out how to set the number of rows in the grid by setting the viewable range to $1:$31, but I haven't seen anything about setting the number of columns. Has anyone encountered a way to do it?
2) Along those same lines, I found the property that I can set for the spreadsheet that protects it and doesn't permit "At runtime, insert rows." But even though I have that unchecked, I'm able to right-click and insert a row. How do I lock the number of rows and columns without locking the entire sheet? (Users need to be able to edit the data on the grid.) Even better, is there a way to disable the right-click on the table?
3) My column labels are way too long, and I'd like them to wrap. From what I've found, this isn't possible in the spreadsheet control. Has anyone found a workaround? (I'm thinking that I'm going to have to appropriate multiple lines for the header and manually split it apart and populate different cells with pieces of the header.)
I've forgotten the other questions I was going to ask, but maybe they'll come back.
Who's had success using the spreadsheet control in place of Flexgrid, and who's found something else that you like better?
Chuck
So I've been fighting with the Spreadsheet control this week, trying to get it to act like FlexGrid, and I have some questions and things to confirm that I figure/hope you all have already dealt with and overcome.
1) I want exactly six columns in my grid. I figured out how to set the number of rows in the grid by setting the viewable range to $1:$31, but I haven't seen anything about setting the number of columns. Has anyone encountered a way to do it?
2) Along those same lines, I found the property that I can set for the spreadsheet that protects it and doesn't permit "At runtime, insert rows." But even though I have that unchecked, I'm able to right-click and insert a row. How do I lock the number of rows and columns without locking the entire sheet? (Users need to be able to edit the data on the grid.) Even better, is there a way to disable the right-click on the table?
3) My column labels are way too long, and I'd like them to wrap. From what I've found, this isn't possible in the spreadsheet control. Has anyone found a workaround? (I'm thinking that I'm going to have to appropriate multiple lines for the header and manually split it apart and populate different cells with pieces of the header.)
I've forgotten the other questions I was going to ask, but maybe they'll come back.
Who's had success using the spreadsheet control in place of Flexgrid, and who's found something else that you like better?
Chuck