Apache OpenOffice (AOO) Bugzilla – Issue 85974
Picture problems - opening from Excel to Calc and vise versa
Last modified: 2013-01-29 21:41:28 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. http://www.box.net/shared/3o9k4n68s8 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!
I have used OOHm4 on WinXP and can confirm the problems. The picture on page REGISTRACIJA has an original size of height:29.27cm width:20.49cm 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 able.
Hi Sven, one4you