OWC10 -Lose formatting while settig csvdata

[Krishna]

Hi,

I have been upgrading an application from OWC9 to OWC10.
1)I observe that when I set the csvdata in in OWCXP I lose
spreadsheet formatting. This was not the case in OWC9. Is
there a simple way to keep the formatting.

2) Also csvdata in OWC10 completely replaces any previous
data in the spreadsheet. In OWC9 it would not replace unaffected
cells. Is there a way to keep the data of unaffected cells?

Ex If the sheet has data 9, 8, 7, 6
In 9.0 if I give vbcr10, 11 it gives
9, 8, 7, 6
10, 11

In 10.0 it gives
blank 1st line
10, 11

Thanks,
Krishna

 

[Alvin Bruney [MVP]]

Since CSVDATA contains no formatting instructions, this functionality isn't
possible or I am not aware of a way to accomplish what you require. You may
try changing the format to HTML or XML. These formats contain formatting
instructions so that you can target cells explicitly

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc