Issue 85974 - Picture problems - opening from Excel to Calc and vise versa
Summary: Picture problems - opening from Excel to Calc and vise versa
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-02-09 09:22 UTC by blank000
Modified: 2013-01-29 21:41 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description blank000 2008-02-09 09:22:29 UTC
Dear Sir or Madam 

After some time of not using it, i installed OO, but this time in an office of
10 people where we must work together and everyone must be able to open,
properly view and print other peoples work.

So, i started editing a document i created in Excel. All looks fine, margins...
Footers do look different but editing them is no trouble.
Than, after i did half of the job, i switch to sheet that consist of only one
page, it is always just that one page, and everything always fits on it.
But in OO it stretches to one more.

I check margins, printer settings, page format, scale, everything looks OK. Save
document (with "Save"), and open it in Excel. Disaster. Everything is messed up.
Regarding looks, formulas are OK.
It looks like OO A4 page is "smaller" than Excel A4 page. What in Excel fits on
one page in OO goes over one and a half.

Even worse, footers are completely messed up, and fixing them in Excel is pain
in the....

Is there a way to solve these problem so i can use OO - with others that use
Excel beaning able to open my documents without having to change it completely
before using it.

Here is the file in Excel, the same one fixed and saved by OO, and screenshoots
of what is going on on my computer.

I'm hooked to it, again, after using it for just couple of hours. Would be
really sad if i had to give it up Sad

Thanks in advance!
Comment 1 Regina Henschel 2008-02-10 17:21:56 UTC
I have used OOHm4 on WinXP and can confirm the problems.

The picture on page REGISTRACIJA has an original size of height:29.27cm
In Excel it has got the cropping settings:
left: 0.54cm right:0.42cm
and the scaling settings:
height 105% width:93%
This leads to an actual size of height:20.74cm and width:18.17cm

When opened in OOo the picture as got the same cropping settings, but the
scaling is different. height:107%, width:97%
This lead to an actual size of height:31.26cm width:18.92cm, which doesn't fit
on the DIN A4 page.

The other way round the scaling settings are altered too.

Added "Picture" to the summary to focus on the problem and make it better search

Comment 2 oc 2008-04-07 13:28:19 UTC
Hi Sven, one4you