Issue 72823

Summary: OOo format not transferring when opening excel files
Product: Calc Reporter: pabickwermert <pabickwermert>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: REOPENED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kamataki, kpalagin, y-catch
Version: OOo 2.0.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Excel label file
none
Label file none

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 1 pabickwermert 2006-12-20 17:38:14 UTC
Created attachment 41609 [details]
Excel label file
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.
Comment 7 pabickwermert 2007-01-24 16:39:05 UTC
Created attachment 42426 [details]
Label file