2. PHPRunner General questions
  3. Multiple Lines For One Record In Excel
This topic is locked

Multiple Lines For One Record In Excel

 		2/27/2013 4:44:46 PM
PHPRunner General questions
S
 slptlp author

I have a Text Area with Basic Rich Text Editor.

When data entry person uses carriage return in text field..this will create in excel export several rows when exported to excel.

So one record in database may result in multiple rows in excel...
Any one know how to correct this problem?
S
 		slptlp author 3/12/2013

I've had the same problem ever since my first purchase of ASPRunner, unable to come up with a fix.
U
 		Ugain 3/13/2013



I have a Text Area with Basic Rich Text Editor.

When data entry person uses carriage return in text field..this will create in excel export several rows when exported to excel.

So one record in database may result in multiple rows in excel...
Any one know how to correct this problem?


From assembly-level programming what is entered by hitting the "enter/return" key of a keyboard is not a single command. The actual entry consists of two (2) consecutive commands: "CR" and "LF" (referred to as "CRLF").
CR=carriage return ... marks the end of the current line

LF=line feed ... makes the cursor go to the beginning of the next line
The "LF" causes the advance to next cell in the spreadsheet.
Instead of just hitting the Return key use "Shift-Return" key combination in the spreadsheet.
Hope this helps,
Ugain