Bug 317993 - Header/Footer in Master Page is not properly mapped with Excel Header/Footer
Summary: Header/Footer in Master Page is not properly mapped with Excel Header/Footer
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.5.2   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-Converter-inbox CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-25 10:02 EDT by jean.dat CLA
Modified: 2010-10-13 05:20 EDT (History)
5 users (show)

See Also:

Attachments
output excel file (1.99 KB, application/vnd.ms-excel)
2010-08-02 02:55 EDT, Xiaoying Gu CLA 		no flags Details
report design created with 2.5.2 release (3.76 KB, text/xml)
2010-08-02 03:06 EDT, Xiaoying Gu CLA 		no flags Details
Right Excel Output Example (1.23 KB, application/xml)
2010-08-02 05:26 EDT, jean.dat CLA 		no flags Details
Right Excel Output Example rptdesign (17.94 KB, application/xml)
2010-08-02 05:28 EDT, jean.dat CLA 		no flags Details
Screenshot of opening with french version xls (23.77 KB, image/x-png)
2010-10-13 05:20 EDT, Xiaoying Gu CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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