Issue 70505

Summary: The sheet layouted one page with Excel overflow with calc
Product: Calc Reporter: y-catch
Component: open-importAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, kamataki, solarisciel, tora3
Version: OOo 2.0.4   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Screen shot : The sheet layouted size A1 with Excel
none
Screen shot : Page preview layouted size A1 with Excel
none
Screen shot : The sheet imported from excel to calc
none
Screen shot : Page preview imported from excel to calc
none
Sample file: the sheet layouted size A1 with excel none

Description y-catch 2006-10-17 08:02:41 UTC
Scenario:
1.Fill a cell A57 with text with Microsoft Excel
2.[File]-[Page Preview]
3.The cell A57 is on the border of page!!
4.Save the file
5.Open the file with Calc
6.[File]-[Page Preview]
7.The cell A57 is in the 2nd page!!

Problem:
The sheet layouted one page with Excel overflow with calc.

Expectation:
The sheet importetd from Excel should layout same size in the Page preview and
Print.
Size A1 with excel is Size A1 with calc.
Comment 1 y-catch 2006-10-17 08:04:37 UTC
Created attachment 39801 [details]
Screen shot : The sheet layouted size A1 with Excel
Comment 2 y-catch 2006-10-17 08:05:43 UTC
Created attachment 39802 [details]
Screen shot : Page preview layouted size A1 with Excel
Comment 3 y-catch 2006-10-17 08:07:01 UTC
Created attachment 39803 [details]
Screen shot : The sheet imported from excel to calc
Comment 4 y-catch 2006-10-17 08:08:14 UTC
Created attachment 39804 [details]
Screen shot : Page preview imported from excel to calc
Comment 5 y-catch 2006-10-17 08:09:11 UTC
Created attachment 39805 [details]
Sample file: the sheet layouted size A1 with excel
Comment 6 frank 2006-10-17 15:57:06 UTC
Hi Daniel,

please have a look at this one. As we've found out it seems to be a problem with
fontmetrics and related.

Frank
Comment 7 y-catch 2006-10-18 08:27:48 UTC
Size A1 -> Size A4
as Paper format

regards,
Comment 8 daniel.rentz 2006-11-22 15:31:10 UTC
started
Comment 9 daniel.rentz 2007-01-24 12:19:01 UTC
*** Issue 72823 has been marked as a duplicate of this issue. ***
Comment 10 pabickwermert 2007-01-24 16:35:28 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 attach a new file for your review.
Comment 11 pabickwermert 2007-01-24 16:36:01 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 attach a new file for your review.