M
MHubbard
Hi,
I have a couple of simple questions about using the OWC 11
(or OWC 10) spreadsheet control in a Windows form that I
am hoping someone would be able to help me with. (I am
running VB.net on Office 2003 Beta, and am a VB.net
newbie).
1) I have a Windows form with a spreadsheet component on
it. When I am in design mode, I am unable to edit the
cell contents (values or formulas) on the spreadsheet
control. I use the Spreadsheet Property Toolbox to try to
plug in values or equations in the Calculations section,
but these seem to be dis-abled. Am I doing something
wrong, or is this not allowed either with VB.net or OWC
11?
2) I would like to be able to show the standard Excel
worksheet tabs for multiple sheets within the same
workbook (spreadsheet component) on the form. I need to be
able to do this, because the users require the ability to
create formulas based on values on other sheets within the
same workbook. I understand how to toggle back and forth
using the Sheet selector, but this does not allow me to
enter values from another sheet into a formula.
For example, I would like to be able to click on cell A1
on Sheet1 and type in: =10*52* , and then click on cell B2
on Sheet2, so that the resulting formula would be:
=10*52*Sheet2!B2. Is this possible with the OWC 11 (or 10)
version of the spreadsheet component?
Thank you in advance for any answers you can provide!
I have a couple of simple questions about using the OWC 11
(or OWC 10) spreadsheet control in a Windows form that I
am hoping someone would be able to help me with. (I am
running VB.net on Office 2003 Beta, and am a VB.net
newbie).
1) I have a Windows form with a spreadsheet component on
it. When I am in design mode, I am unable to edit the
cell contents (values or formulas) on the spreadsheet
control. I use the Spreadsheet Property Toolbox to try to
plug in values or equations in the Calculations section,
but these seem to be dis-abled. Am I doing something
wrong, or is this not allowed either with VB.net or OWC
11?
2) I would like to be able to show the standard Excel
worksheet tabs for multiple sheets within the same
workbook (spreadsheet component) on the form. I need to be
able to do this, because the users require the ability to
create formulas based on values on other sheets within the
same workbook. I understand how to toggle back and forth
using the Sheet selector, but this does not allow me to
enter values from another sheet into a formula.
For example, I would like to be able to click on cell A1
on Sheet1 and type in: =10*52* , and then click on cell B2
on Sheet2, so that the resulting formula would be:
=10*52*Sheet2!B2. Is this possible with the OWC 11 (or 10)
version of the spreadsheet component?
Thank you in advance for any answers you can provide!