Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||OOo format not transferring when opening excel files|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||REOPENED ---||QA Contact:|
|Priority:||P3||CC:||issues, kamataki, kpalagin, y-catch|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description pabickwermert 2006-12-20 17:36:43 UTC
When I open a excel file I have for making labels, the fields do not print the same.(alignment not the same) Even the print area has changed.(does not include the last line.) I am using the same computer with the same printer. My excel file can be located at www.its-my.info/test_label.xls Thank you for the help. I would like to only use openoffice, but until I can get my spreadsheets to print correctly, I can not do that. Have a Merry Christmas!
Comment 2 kpalagin 2006-12-23 19:36:14 UTC
Confirming with OO 2.1 on WinXP - document in Calc does not fit on one page. Fits onto one page in competing spreadsheet.
Comment 3 frank 2007-01-16 14:22:08 UTC
Hi Daniel, please comment on this one an close if nothing can be done. Seems to be a problem with measurement units, isn't it? Frank
Comment 4 daniel.rentz 2007-01-24 12:19:02 UTC
This issue is related to issue 70505 workaround: in Excel, go to the "File" menu, select "Page Setup", and in the "Page" tabpage, select "Fit to" 1x1 page. This setting is imported into Calc and will print the entire spreadsheet to one page. *** This issue has been marked as a duplicate of 70505 ***
Comment 5 daniel.rentz 2007-01-24 12:20:02 UTC
double > closed
Comment 6 pabickwermert 2007-01-24 16:37:53 UTC
Well, I have to say, that did fix the problem of printing on more than one page. But it caused another problem. Now the width does not print correctly so the numbers to not print on the labels correctly. Before, it printed correctly width wise, and not length wise. Now it is the opposite. It starts in the correct place (on the top left) and on the bottom left, it ends on the label correctly. However, from left to right, the alignment has been altered. (it does not make it to the last label) Actually, it is noticable about the third label from the left that the position has been shifted. Thanks for the help and have a great day! I will submit a new attachment for your review.