|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Q: Excel filesHi 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. Show quoteHide quote "G .Net" <nodamnspam@email.com> wrote in message news:NrWdnbxRccG3P2fZRVnyiA@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? > 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. Show quoteHide quote "Scott M." <s-mar@nospam.nospam> wrote in message news:e7Gih11zGHA.4648@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" <nodamnspam@email.com> wrote in message > news:NrWdnbxRccG3P2fZRVnyiA@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? >> > > What control are you using?
Show quoteHide quote "G .Net" <nodamnspam@email.com> wrote in message news:yd2dnWImTrCQbWfZnZ2dnUVZ8tCdnZ2d@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-mar@nospam.nospam> wrote in message > news:e7Gih11zGHA.4648@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" <nodamnspam@email.com> wrote in message >> news:NrWdnbxRccG3P2fZRVnyiA@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? >>> >> >> > > 
Other interesting topics
Diff between 'n-tier' vs 'distributed architecture' vs. 'multi-layered programming'?
Please, can anyone convert the following dot net snippet to pascal Validating emails VB .NET FTP Read Javascript Messagebox content from webclient get create table script for a SQL Server object Convert Access Table to Text File using VB VB2005 EXPRESS how to make vb.net application startup application Why this warning in IDE? |
|||||||||||||||||||||||
