Bug 237488 - Excel emitter splits html data in several rows
Summary: Excel emitter splits html data in several rows
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.2   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: Future   Edit
Assignee: JingwenShen CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords: plan
: 255772 336680 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-06-17 12:06 EDT by Nicolas Thuillier CLA
Modified: 2011-05-24 22:29 EDT (History)
12 users (show)

See Also:


Attachments
Example (4.01 KB, application/octet-stream)
2008-06-17 12:06 EDT, Nicolas Thuillier CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Thuillier CLA 2008-06-17 12:06:26 EDT
Created attachment 105179 [details]
Example

Build ID: 2.2.2

Steps To Reproduce:
Steps To Reproduce:
1. Open a new report
2. Insert a text box
3. Add the text: Here is <b>a test</b> that is not working <font color="red"> at </font> all
4. Select HTML
5. View report as XLS
-> the one line text is splitted to several rows:
Here is 
a test
 that is not working 
at
 all

More information:
Same behavior for 2.2.2 and 2.3
Comment 1 Gang Liu CLA 2008-06-25 23:24:11 EDT
We should put the inline elements into the same row.
Need investigate the solution
Comment 2 Jun Ouyang CLA 2008-07-03 01:34:26 EDT
I propose to add a composite text content to represent the content generated from a complex text item, in which the text may be divided into several text content according to fonts or styles.

A composite text content consists of several real(simple and same as original text content) text contents.

Most emitters and other modules can regard a composite text content as several simple text contents and just ignore the composite text content itself. While excel emitter can merge the text contents in a composite text content to a single text content and output it in one cell.
Comment 3 Wenfeng Li CLA 2008-08-21 17:24:42 EDT
(In reply to comment #2)
> I propose to add a composite text content to represent the content generated
> from a complex text item, in which the text may be divided into several text
> content according to fonts or styles.
> A composite text content consists of several real(simple and same as original
> text content) text contents.
> Most emitters and other modules can regard a composite text content as several
> simple text contents and just ignore the composite text content itself. While
> excel emitter can merge the text contents in a composite text content to a
> single text content and output it in one cell.

Not sure I understand the proposal.   How does a user select text vs. composite text when he/she design a reports?  IN what situation select which text?
Comment 4 Wenfeng Li CLA 2008-08-21 17:27:19 EDT
(In reply to comment #1)
> We should put the inline elements into the same row.
> Need investigate the solution

Do we parse the HTML and format the text using Excel's formatting properties?  Or can we output the HTML as it is to a Excel cell?

Suggest we work on this as part of the Excel emitter enhancement to support charts and formula.
Comment 5 Jun Ouyang CLA 2008-08-21 21:43:54 EDT
> Not sure I understand the proposal.   How does a user select text vs. composite
> text when he/she design a reports?  IN what situation select which text?

My proposal is for implementation of engine layout. What I mean is, when engine executes the text item, it creates a composite text content for the html text with serveral styles. So that emitters can distinct if the text contents are from a single or multiple html text entries.

I didn't mean to add a composite text item.
Comment 6 Jandor Bian CLA 2009-01-11 20:24:32 EST
*** Bug 255772 has been marked as a duplicate of this bug. ***
Comment 7 Xiaoying Gu CLA 2011-05-24 22:29:58 EDT
*** Bug 336680 has been marked as a duplicate of this bug. ***