Q: Excel files

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • G .Net
    #1

    Q: Excel files

    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?


    Tags: None
    • Scott M.
      #2
      Re: Excel files

      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@ema il.comwrote in message
      news:NrWdnbxRcc G3P2fZRVnyiA@pi pex.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?
      >

        Comment

        • G .Net
          #3
          Re: Excel files

          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.nosp amwrote in message
          news:e7Gih11zGH A.4648@TK2MSFTN GP04.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@ema il.comwrote in message
          news:NrWdnbxRcc G3P2fZRVnyiA@pi pex.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?
          >>
          >
          >

            Comment

            • Scott M.
              #4
              Re: Excel files

              What control are you using?


              "G .Net" <nodamnspam@ema il.comwrote in message
              news:yd2dnWImTr CQbWfZnZ2dnUVZ8 tCdnZ2d@pipex.n et...
              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.nosp amwrote in message
              news:e7Gih11zGH A.4648@TK2MSFTN GP04.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@ema il.comwrote in message
              >news:NrWdnbxRc cG3P2fZRVnyiA@p ipex.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?
              >>>
              >>
              >>
              >
              >

                Comment

                Previous template Next
                Working...