HELP - assigning multi-line value to a single cell

P

Pearl

Using the owc spreadsheet component with ASP server-side, I'm trying
to assign a value to a single cell, such that the value is split into
2 lines in the cell. For example in VBScript:

<%
Set o = Server.CreateObject("OWC.Spreadsheet")
o.Cells(1, 1).Value = "line1" & Chr(10) & "line2"
....
%>

But after exporting and saving to an xls file, when I view the
spreadsheet, "line2" appears on the next cell below, instead of
contained within Cell A1 (Cell A1: line1, Cell A2: line2)

I tried using Chr(13) and Chr(13) & Chr(10) instead but it gets the
same result.

Is this a defined behavior. If so, how do I assign a multi-line value
into a single cell???

P.S. With Excel VBA this is not a problem.
 

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

Top