How to configuration the spreadsheet in XP Web Component

[barbara_dave]

Hi All,

I have a VB.NET application using OWC 9.0 on XP Operation System to
display data in a spreadsheet. Now I want to upgrade OWC 9.0 to XP web
component on VISTA. Some of the code doesn't work for XP web
component. I can't find the sample or help file for this, could
someone help me? the following is the old code working for OWC 9.0:

mysheet.ActiveSheet.ViewableRange = "A1:" & Col_Header(colNum) &
(rowNum)

mysheet.ActiveSheet.Range("A1:" & Col_Header(colNum) &
rowNum).HAlignment = OWC.SheetHAlignEnum.ssHAlignRight

mysheet.ActiveSheet.Range("A2").FreezePanes(4) 'ssFreezeTop

Please tell me how to change this code to work for OWC10, Thanks a
lot!

Also I found the number of the column width is much more different in
OWC10 than OWC9, for example:

mysheet.ActiveSheet.Range("A1:A" & (rowNum)).ColumnWidth = 37

the above code displays very big width of columns. I have to change 37
to 5 to match the old format. Is this correct?

Thanks again for the help!!!

 

[jtz]

there is some differece between owc 10 and owc 9
OWC9 HAlignment
OWC10 HorizontalAlignment
owc 9 mysheet.ActiveSheet.Range("A2").FreezePanes(4)
owc 10
mysheet.ActiveSheet.Range("A3").select
mysheet.ActiveSheet.freezePanes=true
and the columnWidth in owc10 is char Width not pixel width,you can convert a
owc9 columnWidth into owc10 colunmWidth by the fomula
if columnOfOwc9Width>=3 then
columnWidthOfOwc10=(columnWidthOfOwc9-3)/8
else
columnWidthOfOwc10=0
end if