Date-related formatting Bug in OWC 2003 Spreadsheet control

C

cellBert

Setting a range formula that contains date arithmetic destroys formatting:
1.Insert an OWC spreadsheet control and a button onto a VB 6 project.
2.Set cell A1: 11
3.Set cell B1: 1/1/2006
4.Set cell C1: 1/1/2005
5.Set cell D1: =B1-C1
6. Cell D1 will have correct result of 365, but you will have to format cell
to "General"
7. Write this code to respond to the button-click:
Private Sub Command1_Click()
Dim v
v = Form1.Spreadsheet1.Range("a1:d1").Formula
v(1, 1) = 12
Form1.Spreadsheet1.Range("a1:d1").Formula = v
End Sub
8. Run the project and click the button - the cell you just formatted will
change formatting back to a date format, causing the value in D1 to be wrong.
Real Excel doesn't do this.
Is there an easy workaround? Can there be a fix? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC Spreadsheet events do crash IE6 5
Referencing the values of multiple cells in conditinal formatting. 0
Show value from one cell in another cell if today falls between a date range 5
Chartspace & Excel2003 0
Using icon sets with relative references 0
FYI: Freezepanes sample ASP code for the OWC Spreadsheet 0
type mismatch error in macro in excel 0
Excel formula to list out the info according to criterion 3

Top