Bug 45758 - FORMATTING: Graphical objects change Z-order when closing then opening spreadsheet (possible FILEOPEN problem).
Summary: FORMATTING: Graphical objects change Z-order when closing then opening spread...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-07 22:38 UTC by DarwinSurvivor
Modified: 2014-02-21 12:12 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
The document that is affected by the bug (19.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-02-07 22:38 UTC, DarwinSurvivor
Details
second edition of test case (19.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-15 06:39 UTC, sasha.libreoffice
Details

Description DarwinSurvivor 2012-02-07 22:38:55 UTC
Created attachment 56736 [details]
The document that is affected by the bug

Problem description: 

Steps to reproduce:
1. Place a text box over a rectagular circle
2. Save the document
3. Close the document
4. Open the document

Current behavior:
The text is now BEHIND the circle.

Expected behavior:
The text should still be ABOVE the circle.

Platform (if different from the browser): 
Ubuntu 11.10 amd64
              
The elements affected in the document are the circles on the right hand side.
Comment 1 Rainer Bielefeld Retired 2012-02-09 21:55:56 UTC
NOT reproducible with "LibreOffice 3.5.0 RC3 German UI/Locale [Build-ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735] on German WIN7 Home Premium (64bit) 
NOT reproducible  "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit) 
Also not with a 3.4.1 based RC.
Neither with reporter's sample nor with own document.

Linux related?
Comment 2 DarwinSurvivor 2012-02-11 02:09:00 UTC
I have also tested the same document in Arch Linux (Ubuntu was the original) and get the same results.

@Rainer Bielefeld When you say it was not reproduceable, which part? Did the order appear correct when opening it in the first place (indicating a read issue), or did they stay correct when opening it the second time (indicating a save issue)?
Comment 3 sasha.libreoffice 2012-05-15 06:39:04 UTC
Created attachment 61681 [details]
second edition of test case
Comment 4 sasha.libreoffice 2012-05-15 06:50:47 UTC
Thanks for bugreport
Steps to reproduce:
0. Opens second attachment. There we see red circle over blue.
1. Select red circle
2. Right click, select from context menu Arrange->Send to back
(red circle disappears behind blue)
3. Save document
4. File->Reload
Expected: document seen as before step 4
Actually: document changed, red circle appears again.

Reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit and in 3.5.2 on Windows 7 32 bit

In msExcel this document opens correctly (red circle hidden behind blue)
Therefore, LibreCalc saves Z-order correctly, but can not open
Comment 5 sasha.libreoffice 2012-05-15 07:23:49 UTC
Resembles this in Writer:
Bug 41006 - Z-order mangled in large documents (FILEOPEN, FILESAVE, FORMATTING)

after saving file in 3.5.3 version, http://odf-validator.rhcloud.com/ outputs this error (attachment saved in 3.3.4 version, need resave):
Calculations1.ods/content.xml[740,182]: Error: element "text:a" is missing "type" attribute

PS: after attempts to simplify document, bug disappears. So, not very easy to simplify document so that bug retains.
Comment 6 Rainer Bielefeld Retired 2012-05-15 08:20:26 UTC
Sometimes [Reproducible] with "second edition of test case" and "LibreOffice 3.5.3.2 (RC2) German UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7 Home Premium (64bit) (following exactly steps in Comment 4), most times not.
Comment 7 Xisco Faulí 2014-02-21 12:12:13 UTC
Second edition tested and it's still present in:
   - Libreoffice 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72
   - Libreoffice 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
   - Libreoffice 4.3.0.0.alpha0+ Build ID: e076b5290e706b8a69abd397a9f255eba6a0cd1a


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.