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