Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
double blank lines in cells
Our software generates reports by exporting data to xml, and then
transforming it by xsl into an "excel-readable" format. When there are longer texts to be displayed in one cell, word wraps in the original text appear double in the excel cell, for example when line1 line2 is the original text, in excel it appears as line1 line2 How do I get rid of the blank line? We tried every code for word wraps/line feeds we could think of, like "\n", "chr(10)", "... and so on, but nothing works. Can anyone help? Thanks, Björn Göhringer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
double blank lines in cells
Hi
Based on my test, the XML recognize as a carriage return. Here is a sample snippet. <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25" <Row ss:AutoFitHeight="0" ss:Height="28.5" <Cell ss:StyleID="s21"<Data ss:Type="String"bb fasdf</Data</Cell </Row </Table Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
double blank lines in cells
Did you try reducing the cell's height? When a word is wrapped in cell, the height is increased to display the value. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=47937 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank lines in text cells | Excel Discussion (Misc queries) | |||
blank lines in text cells | New Users to Excel | |||
Enter various number of blank lines in cells | New Users to Excel | |||
grid lines printing with blank cells | Excel Discussion (Misc queries) | |||
Blank lines in cells | Excel Discussion (Misc queries) |