Hi All,

've been trying to use the MS Office Spreadsheet 9.0 Activex control in 

the following situation.



COM+ components communicate with the database and return data in the form 

of XML string to ASP.

Here, xslt's are used to transform the XML into HTML.

Now this HTML is fed as the value of PARAM "HTMLData" to the OWC Activex 

control.



U might wonder as to why this ballyhoo is needed.

Reason is:

the data I got to show has to be filtered columnwise on the client-side.

MS Office Spreadsheet 9.0 offers the facility of usual "autofilter" as in 

MS Excel.

That does the filtering of individual columns just as I need it.



Now my problem is:

I can control the layout of data in the spreadsheet columns and can even 

Freeze a particular row. But I can't make a certain column to autowrap the 

data as in MSEXcel.

So long fields are simply hidden beyond the normal width of the cell.

Also, I can't allow resizability of columns by the User b'coz of certain 

layout issues.



In all, "WRAP TEXT" is what I desperately need. - First.



Second - Font, weight, alignment of each cell, as i gather from the Design 

Time Property Toolbox for the Activex Control, are decided by the class it 

assigns to each class ie.



<TD class=wc4DEC083>xyz</TD>



Can anyone tell me how to find specific classes for a certain 

font/alignment, etc.??



Hope anybody out there can shed some light on any of these two points.

Thanx in advance,

Arijit.