Hope all are doing well.
I running with below problem here. please let me know if anyone have
workaround on this.
I am generating excel spreadsheet using XML representation for cells
and rows in ROR. now within content of a cell i need to enter new line
character (means need to put line break) between some content. i have
searched at various places for this and found that for adding line
break (Alt + Enter), its required to embed between any
and then i tried to put between the content of a cell but it
got interpreted as in the excel sheet. if i save the excelsheet
as xml spreadsheet and check the content in wordpad its showing
in the cell content.
for an example i tried as given below.
xml.Row ‘ss:StyleID’ => ‘s65’ do
xml.Cell ‘ss:StyleID’ => ‘s70’ do
xml.Data “test” + " " + “test 3”, ‘ss:Type’ =>
So here i was expecting data test and test 3 need to be separated by
line break but in the excel sheet it is showing as test test 3 and
saving and opening as xml shpreadsheet it is showing as
test test 3
Apart from that i tried to puts"\n",
etc tags but it is putting
space for this characters.
Please let me know if anyone has any solution on this.
Thanks in advance.