Q: Excel files

  • Thread starter Thread starter G .Net
  • Start date Start date
G

G .Net

Hi All

I'm using the Microsoft Office Spreadsheet component to view an Excel file
in an application that I've written. However, there are two things that are
puzzling me:

(1) I don't seem to be able to set it so it isn't re-sizeable. Using the
"locked" property doesn't do anything.

(2) The spreadsheet is not read-only. How can I do this?

Hope somebody can help. Otherwise, can anybody suggest another way for me to
simply view an Excel file from within a VB.net application?
 
1. The locked property does not determine if a row or column is resizable,
for that you want to protect the worksheet.
2. The locked property doese dertermine if a cell can be altered BUT in
order for the locked property to work (all cells in a worksheet are locked
by default), you must also protect the worksheet.
 
Hi Scott

Sorry, I didn't explain myself clearly regarding the size change. What I
actually meant was the size of the actual spreadsheet itself i.e. there is
always a re-size "shape" >> in the bottom right of the control. I want to
prevent the user from being able to re-size the spreadsheet.
 
What control are you using?


G .Net said:
Hi Scott

Sorry, I didn't explain myself clearly regarding the size change. What I
actually meant was the size of the actual spreadsheet itself i.e. there is
always a re-size "shape" >> in the bottom right of the control. I want to
prevent the user from being able to re-size the spreadsheet.
Click to expand...
 
Back
Top