Apache OpenOffice (AOO) Bugzilla – Issue 11381
Excel document proportions are not the right size in Calc
Last modified: 2013-08-07 15:15:02 UTC
Hi, I have a simple Excel document, that is not read well by OpenOffice Calc. On screen it looks almost the same, but when I print it I can see that it does not see the right row size. In Excel the document fit's on 1 page, OpenOffice needs 2. When viewing the page preview, it also needs 2 pages.
Could you attach the sample Excel file using the "Create a new attachment". Thanks.
Created attachment 4656 [details] Example Excel document
Sorry for the delay in responding. yes, I can confirm that this is an issue. It appears that we default to turning on both Header and Footer. Simply turning these off in File -> Page Preview -> Print Format -> Header/Footer will allow this to be printed on one page. I will check if we are ignoring this on the import.
marking as started
Nice workaround, I'm now able to print the whole table, BUT the small text at the bottom, "Deze staat kun je vinden onder Maatwerk\Wso en heet Urenstaat.xls" is still printed on a second page. This text is completely unimportant, but it indicates that this is not a problem with a header and a footer, but realy is an problem with proportions. The printed table is a bit bigger that printed with Excel. In OOo the rowheight is 0,47cm, while in Excel the rowheight seems to be 20 ( 20 what? Hell I don't know, I only know M$ dislikes using standards for about anything! ;-) )
Yes, I agree. Removing the Header and Footer is not enough. You would also need to set the 'Fit Printout on number of pages' to 1 in the File -> Page Preview -> Page Format -> Sheet -> Scale. Excel measures Row Height in points where 1 point is 20 twips and a twip is 1/1440 of an inch i.e. 72 points per inch or approx 28.35 per cm. I will investigate this a little further to see where we are losing the compatability.
issue 10828 explains why we are losing compatability between the header and footer. The proposed fix there will address this. So that leaves just one line of text at the bottom of the sheet.
It looks like that we correctly import all the other page settings now that we have fixed the header/footer problems in issue 10828. Thus the excel importer is working correctly and the difference in 1 line may be due to how Excel and Calc differ in their interpretation of the settings. The other possibililty is that there is a very very slight difference in the the optimal height of the rows. I would like to suggest that we close this as we have a very good method to ensure page compatability between Excel and Calc, by specifying the 'fit to page' setting.
marking as closed as per previous comment
As mentioned on the qa dev list on March 5th I will close all resolved duplicate issues. Please see this posting for details. First step in IssueZilla is unfortunately to set them to verified.
As mentioned on the qa dev list on March 5th I will close all resolved <wontfix/duplicate/worksforme/invalid> issues. Please see this posting for details.