Q: Excel files

[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?

[Scott M.]

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.


"G .Net" <no********@email.comwrote in message
news:Nr********************@pipex.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?

[G .Net]

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.
"Scott M." <s-***@nospam.nospamwrote in message
news:e7**************@TK2MSFTNGP04.phx.gbl...

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.


"G .Net" <no********@email.comwrote in message
news:Nr********************@pipex.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?

[Scott M.]

What control are you using?
"G .Net" <no********@email.comwrote in message
news:yd******************************@pipex.net...

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.
"Scott M." <s-***@nospam.nospamwrote in message
news:e7**************@TK2MSFTNGP04.phx.gbl...

>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.


"G .Net" <no********@email.comwrote in message
news:Nr********************@pipex.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?