Created attachment 81140 [details] Diagram to use to reproduce the bug (see instructions in initial post) If a LibreOffice Drawing (.odg) is imported into a spreadsheet as an OLE object, and the drawing has multiple layers, then the layers are imported in the wrong positions, i.e., they are not aligned as they should be. The result is that layers which should overlap in a certain way are shown in different seemingly-random positions. Steps to Reproduce: 1. Download the attached bug_diagram.odg 2. Open bug_diagram.odg. Observe that the diagram has content in three layers (Drawing, VGrid and HGrid) and how they overlap. The VGrid and HGrid layers contain the blue background grid lines and the rest is in Drawing. 3. Create a new spreadsheet Put cursor in A1 Insert->OLE Object Check "Create from file" Click Search... and navigate to bug_diagram.odg Check "Link to file", then OK Result: The diagram appears with layer "Drawing" not aligned with the VGrid and HGrid layers. The relative positions are seemingly random. Expected Result: Layers should be alined. The drawing should look the same as it does when editing it separately. NOTE: Tested on daily build Version: 4.1.0.0.beta2+ Build ID: 55689d877d1f216efce2d05448442b088aec980 TinderBox: Linux-x86_64@31-Release-Configuration-RHEL5-Baseline, Branch:libreoffice-4-1, Time: 2013-06-13_08:39:37 Operating System: Ubuntu Version: 4.1.0.0.beta2
Created attachment 81141 [details] Screenshot showing dis-aligned layers
The drawing is also truncated (part of it is not visible). Probably related to the first layer being displayed in the wrong position.
Hello Jim, I have not a Linux OS, but I tried your steps and got the same result like you. But by Select all > Copy and Paste in A1, I got it. Do that work for you too? Jacques Guilleron
Confirming that copy-and-paste preserves layer alignment on Linux also. Note that copy-and-paste isn't quite equivalent to OLE importing with linking, because with linking it is easy to update if the imported drawing is changed.
Hi Jim, You are quite right and somebody has eared you. Verified this morning with master LO 4.2.0.0.alpha0+ Build ID: ce0383d2950d3b0da2c457c8a406c1229de53571 (2013-06-22) & Windows 7 Home Premium OLE object is linked and Layers are correctly aligned. I join a view of the new behaviour. Regards, Jacques
Created attachment 81906 [details] OLE object opened in Calc
Hi Jacques, Your screenshot shows the drawing in edit mode, not as it appears in the spreadsheet. I see the same results (correct display when in edit mode), but for me the layers become incorrectly aligned after exiting edit mode, i.e., when viewing the OLE-linked drawing as it appears in the spreadsheet. Would you please repeat your test and view the OLE-linked drawing in the spreadsheet? Double-clicking the drawing will enter edit mode; if you are in edit mode, please click somewhere else in the spreadsheet to de-select the drawing and exit edit mode. Then, if you would, please make another screen-shot showing the drawing as it appears in the spreadsheet (not in edit mode). -Jim
Created attachment 81914 [details] As it appears when just embedded
Hi Jim, I tried three times to edit. When I exit this mode, the layers are correctly aligned and such as in previous edtiing. Regards, Jacques
Thanks. So it looks like the bug is not there in 4.2. Does anyone know if pre-built Linux .debs built from 4.2 code are available, or is compiling git source the only way at the moment?
Windows XP SP3 Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155 Works wrong. Version: 4.2.0.0.alpha0+ Build ID: 6f86d931b4266d00fec75c0124ac9fc3026a4f1b TinderBox: Win-x86@6, Branch:master, Time: 2013-07-02_23:36:17 Works fine. Deb package are create for 4.0 and 4.1 branch, but aren't for 4.2.
I reproduce the problem with Version: 4.2.0.0.alpha0+ (Build ID: d7d37d2101ce468e6ae2e1fd711cd7df321a5378) and Version: 4.1.1.0.0+ (Build ID: 6089121ebd075bb6422d33d6bff69dff2e88efb) under Ubuntu 12.04 x86-64 with Gnome-shell. Best regards. JBF
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT *Update the version field *Reply via email (please reply directly on the bug tracker) *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-01
WFM - Problem does not appear any longer in 4.4 trunk builds.