You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

excel output, splitd lines

in Reporting and Analytics for HCM 3 comments

Summary:


Content (please ensure you mask any confidential information):

HI team,

I have a report that one of the field is HTML with new lines,

the problm starts where I want to export it as excel,

the cell of the HTML splitted to many, what i must prevent-

I have tried many solutions-

  1. Keep values in same column to true.
  2. enable row split to false
  3. creating a new layout of excel- but there I cannot convrt the html- because the -html2fo is not works there. and also trying with functions failed from some reason..
  4. more than that I have tried to replace the HTML (REPLACE(REPLACE(TO_CHAR(ft.description), CHR(13)), CHR(10)) description) but the new lines in excel are not shown
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!