Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 317993

Summary: Header/Footer in Master Page is not properly mapped with Excel Header/Footer
Product: z_Archived Reporter: jean.dat
Component: BIRTAssignee: Birt-Converter-inbox <Birt-Converter-inbox>
Status: NEW --- QA Contact: Xiaoying Gu <bluesoldier>
Severity: normal    
Priority: P3 CC: bluesoldier, doshiro, jean.dat, jouyang, scaracas
Version: 2.5.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
output excel file
none
report design created with 2.5.2 release
none
Right Excel Output Example
none
Right Excel Output Example rptdesign
none
Screenshot of opening with french version xls none

Description jean.dat CLA 2010-06-25 10:02:59 EDT 
Build Identifier: 

If you place a grid (1x3 as required) in your master page header with a text value in each cell, all cell values appeared in the cenral zone of your excel header. Same for footer.

I'm using Excel 2003 (french PC).

BIRT generate : 

<Header x:Data="&amp;Lsome text&amp;Csome text&amp;Rsome text"/>
<Footer x:Data="&amp;Lsome text&amp;Csome text&amp;Rsome text"/>

BUT Excel generate : 

<Header x:Data="&amp;Esome text&amp;Csome text&amp;Dsome text"/>
<Footer x:Data="&amp;Esome text&amp;Csome text&amp;Dsome text"/>

Differences are excel codes :

&L -> &E ;
&C still &C ;
&R -> &D ;

Reproducible: Always

Steps to Reproduce:
1. Place a grid with 1 row and 3 columns in your master page header ;
2. Put some text in each cell ;
3. Export as XLS ;
Comment 1 Xiaoying Gu CLA 2010-08-02 02:55:09 EDT 
Hi,

I can not reproduce this in 2.5.2/2.6.0 release build.

Please see my attached example report and output excel file.
All three text item in the masterpage header were left alignment. Am I misunderstanding the issue?
Comment 2 Xiaoying Gu CLA 2010-08-02 02:55:56 EDT 
Created attachment 175686 [details]
output excel file
Comment 3 Xiaoying Gu CLA 2010-08-02 03:06:29 EDT 
Created attachment 175687 [details]
report design created with 2.5.2 release
Comment 4 jean.dat CLA 2010-08-02 05:24:59 EDT 
Hi,

Yes there is a misunderstanding. I don't want to insert my master page header and footer in the sheet. I want it to be mapped with excel header and footer.

In attachment, an example.
Comment 5 jean.dat CLA 2010-08-02 05:26:55 EDT 
Created attachment 175695 [details]
Right Excel Output Example
Comment 6 jean.dat CLA 2010-08-02 05:28:21 EDT 
Created attachment 175696 [details]
Right Excel Output Example rptdesign
Comment 7 Xiaoying Gu CLA 2010-08-04 00:56:19 EDT 
Is your Excel 2003 french version?

The excel header of your attached example works fine in in Excel 2003 of english version.
The generated xml source by BIRT are same as we operate directly in Excel 2003 (English version)
<Header x:Data="&amp;Lsome text&amp;Csome text&amp;Rsome text"/>
<Footer x:Data="&amp;Lsome text&amp;Csome text&amp;Rsome text"/>

Do you have a chance to open the excel BIRT generated in an English version of Excel to verify if this is a Excel version issie?
Comment 8 jean.dat CLA 2010-08-11 12:10:08 EDT 
Sorry but I have not any Excel version in English in my company but if your test is good, it could explain the issue.

This is really a problem if we need to know which version of Excel is installed on our customers PC.
Comment 9 Xiaoying Gu CLA 2010-10-13 05:19:15 EDT 
We have tested on French localized Windows with French version of Excel.
It looks ok.
Please check the attached screen shot.
Comment 10 Xiaoying Gu CLA 2010-10-13 05:20:51 EDT 
Created attachment 180747 [details]
Screenshot of opening with french version xls