Issue 70505 - The sheet layouted one page with Excel overflow with calc
Summary: The sheet layouted one page with Excel overflow with calc
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-17 08:02 UTC by y-catch
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Screen shot : The sheet layouted size A1 with Excel (53.09 KB, image/png)
2006-10-17 08:04 UTC, y-catch
no flags Details
Screen shot : Page preview layouted size A1 with Excel (17.87 KB, image/png)
2006-10-17 08:05 UTC, y-catch
no flags Details
Screen shot : The sheet imported from excel to calc (41.72 KB, image/png)
2006-10-17 08:07 UTC, y-catch
no flags Details
Screen shot : Page preview imported from excel to calc (30.89 KB, image/png)
2006-10-17 08:08 UTC, y-catch
no flags Details
Sample file: the sheet layouted size A1 with excel (15.00 KB, application/vnd.ms-excel)
2006-10-17 08:09 UTC, y-catch
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.