Bugzilla – Full Text Bug Listing
| Summary: | Excel: Grid does not fit on page. Extra column generated. | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Dirk Gabler <dirk.gabler> | ||||||||||||||||||||||
| Component: | BIRT | Assignee: | Ruo Yin <ruo.yin> | ||||||||||||||||||||||
| Status: | VERIFIED INVALID | QA Contact: | Xiaoying Gu <bluesoldier> | ||||||||||||||||||||||
| Severity: | normal | ||||||||||||||||||||||||
| Priority: | P3 | CC: | bluesoldier, dirk.gabler, jouyang | ||||||||||||||||||||||
| Version: | unspecified | ||||||||||||||||||||||||
| Target Milestone: | 3.7.0 M7 | ||||||||||||||||||||||||
| Hardware: | PC | ||||||||||||||||||||||||
| OS: | Windows XP | ||||||||||||||||||||||||
| Whiteboard: | Obsolete | ||||||||||||||||||||||||
| Attachments: |
|
||||||||||||||||||||||||
|
Description
Dirk Gabler
Created attachment 190530 [details]
ReportDesign to show non fitting grid
This report design contains a grid with 3 columns which should fit on one page.
In Excel it results in 2 pages.
The exported excel XML file also contains one extra column.
Created attachment 190537 [details]
Result-XLS
Hi Dirk, I can not reproduce this issue in the 2.6.2 release build, buildid:<2.6.2.v20110219-1842>. It seems that this bugs was fixed in the official release available few days later. Hi, I did use the official 2.6.2 release! I've just downloaded several packages (birt-report-designer-all-in-one-2_6_2.zip, birt-rcp-report-designer-2_6_2.zip) again and tried it again. Same result. If I create new reports with this official version, the build-id shown is always "Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523>" If you create a new report design, what version is shown in the rptdesign-XML? Is there any newer version you have which is not provided as download? Can you please send me your XLS-result, so that I can see if it looks better? What is the difference in your XLS-result to mine (attached)? How many pages do you get if you open the Result-XLS attached? Thanks in advance, Dirk I downloaded the 2.6.2 release All-In-One package from: http://download.eclipse.org/birt/downloads/build.php?build=R-R1-2_6_2-201102191842 (chose the Asian [China] Actuate Shanghai (http) mirror) After created a blank report in the all-in-one, the build id was shown as: Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110219-1842> The output xls file was attached. Created attachment 190736 [details]
created by 2.6.2 release
Ok, for some reason the downloadable packages on the german mirror are different ones, but the birt-version seems to be the same: Mine: Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Yours: Eclipse BIRT Designer Version 2.6.2.r262_v20110209 I do not think that there are differences in the versions but will try the shanghai-download also. What version of Excel did you try? If I open your XLS output I still have the same problem. Can you please open the file in Excel, do a page preview and make sure that all fits on one page? See my new attachement how it looks like for me. Thanks in advance, Dirk Created attachment 190738 [details]
Excel-Screenshot of first page (2 pages result)
I opened the XLS file I uploaded both in excel 2003 and excel 2007, both works fine in print preview. 3 columns were drawn on the 1st page and only 1 page was generated. Please see my screenshot. BTW, the build id <2.6.2.v20110219-1842> indicates the actual build time of that build. So if your id was <2.6.2.v20110214-1523>, it might be an interim build. I'm not sure why the German mirror did not sync the correct one? Actually there was no 2.6.2.v20110214-1523 build on the Eclipse main download site now. Created attachment 190740 [details]
Screenshot of the XLS print preview
Hi, can you please send me your rptdesign-file after you have opened it and saved it with your Birt-Version. I would like to check, if there are any other differences. What exakt version of Excel 2003 did you use on what version of windows? Thanks in advance, Dirk (In reply to comment #11) > Hi, > > can you please send me your rptdesign-file after you have opened it and saved > it with your Birt-Version. I would like to check, if there are any other > differences. > > What exakt version of Excel 2003 did you use on what version of windows? > > Thanks in advance, > Dirk Dirk, I open the report you attached directly in the eclipse and did not make any change, so the save button is not available. I was using Windows 7, jdk1.6 to run the all-in-one. Can you check the plugins folder that xls emitter plugin version is: org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar? Yes, the plugin-folder contains: org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar I'm also using JDK1.6 but on a Windows XP with Excel 2003 (SP3) It looks like I have to go back to my patched 2.6.1-Version. right? Ok, I finally succeed OK, I finally can produce this issue with office2003 + windows XP + jdk 1.6. The output xls file has 2 pages. But this time the 3 columns of first row appears on the first page, the 2nd page should be caused by the 2nd row. In the generated xls file, the second row has 4 columns, actually it should be 3. Note that the exported xls still print fine in office 2007 version. Created attachment 191098 [details]
screenshot of office 2003 on xp
OK, we are coming closer to the problem. Can you please try the rptdesign (A4-Test_1row_3columns.rptdesign) attached and let me know how it looks on your XP. If you look in the resulting XML (XLS) you will see, that 4 columns are generated (as I mentioned in my original post): <Worksheet ss:Name="Report"> <ss:Table> <ss:Column ss:Width="113.28" ss:AutoFitWidth="0"/> <ss:Column ss:Width="198.528" ss:AutoFitWidth="0"/> <ss:Column ss:Width="226.688" ss:AutoFitWidth="0"/> <ss:Column ss:Width="19.328" ss:AutoFitWidth="0"/> Cheers, Dirk Created attachment 191102 [details]
1 row, 3 columns
Created attachment 191724 [details] print_preview of 1row The new generated xls file has the same xml as you pasted in comment 17(4 columns). But in excel print preview, it shows only 1 page. Created attachment 193650 [details]
Birt Designer to excel
Created attachment 193651 [details]
widthAdjusted.jpg
1. The xml shows four columns because the report is using fixed layout so the last column is add here to fill the page width. However only the first 3 columns have data so the last column won't appear in print preview. The last column won't appear if report design is set to "auto layout" but the result is the same. 2. Excel has adjusted column width in print preview, page layout view and actual printing according the default font used. This can be verified using page layout view in excel 2007 (excel 2003 doesn't provide such function). As shown in Designer_to_excel.jpg, we preserved exact column width for each cell compared to designer under 96 dpi. In excel 2007, select "view" on menu then "Page Layout", the first column width becomes 162 pixels - 4.29 cm instead of 151 pixels - 4 cm (refer to widthAdjusted.jpg) for default font "Calibri 11" and that's why the three columns can't fit in one row. You can see these numbers by holding left mouse button down on column separator. If excel's default font is changed to "Arial 12", in page layout view you'll find the first column becomes 150 pixels - 3.97 cm. You can change excel default font by clicking the office button on top left corner -> excel options -> "popular" tab -> on the left "when creating new workbooks" use this font. (In reply to comment #22) Great answer, thank you! I came to the similar conclusion that the default font in excel confuses me :-) I've changed my way of desiging and using pixel-values in the designer now. Verified |