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!!!
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
