Apache OpenOffice (AOO) Bugzilla – Issue 72823
OOo format not transferring when opening excel files
Last modified: 2013-02-07 22:03:26 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!
Created attachment 41609 [details] Excel label file
Confirming with OO 2.1 on WinXP - document in Calc does not fit on one page. Fits onto one page in competing spreadsheet.
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
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 ***
double > closed
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.
Created attachment 42426 [details] Label file