Bug 41863 - FILEOPEN: Ellipse drawing shape anchored to cell shown much too small
Summary: FILEOPEN: Ellipse drawing shape anchored to cell shown much too small
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: target:3.5.0
Keywords: regression
Depends on:
Reported: 2011-10-17 03:08 UTC by steveb
Modified: 2012-01-21 00:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample Document (7.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-21 00:00 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description steveb 2011-10-17 03:08:49 UTC
The position and size of ellipses added onto a worksheet, and anchored to a cell, are not preserved in saved files.
Saving the file and re-opening shows the ellipse compressed into the size of a single cell.

Expected Result:
The ellipse should stay as it was placed.

Steps to Reproduce:
- Open a new spreadsheet
- From the drawing toolbar, select Ellipse (4th button) and place an ellipse
  onto Sheet1. Set the size to span several cells in both directions.
- Set the ellipse to Anchor "To Cell"
- Save and close the spreadsheet
- Re-open the spreadsheet
- The ellipse will now be shown just a little bigger than the anchor cell

- Ellipses added and anchored "To Page" do not have this problem
- Ellipses added using the "Basic Shapes", "Ellipse" drawing toolbar button do
  not have this problem
- Problem seen on both kubuntu 11.10 amd64 and WinXP 32-bit
Comment 1 Fahad Al-Saidi 2011-10-29 03:30:14 UTC
confirmed in 
LO 3.4.3 OOO340m1 (Build:302)
mepis 11
Linux mepis1 2.6.36-1-mepis-smpc Arabic UI
Comment 2 tester8 2011-11-12 03:46:24 UTC
NOT reproduced with

LO 3.4.4
Ubuntu 10.04.3 x86
Linux 2.6.32-35-generic Russian UI

steveb, Fahad Al-Saidi
Can you please test with 3.4.4?
Comment 3 steveb 2011-11-13 02:05:56 UTC
The problem is still present.

System 1:
  LibreOffice 3.4.4 OOO340m1 (Build:402)
  kubuntu 11.10
  Linux 3.0.0-12-generic SMP x86_64

System 2:
  LibreOffice 3.4.4 OOO340m1 (Build:402)
  Windows XP SP3 32-bit
Comment 4 Rainer Bielefeld Retired 2012-01-20 23:58:21 UTC
[Reproducible] with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" on German WIN7 Home Premium (64bit) 

No longer reproducible with "LibreOffice 3.5.0 RC1 German UI/Locale [Build-ID: b6c8ba5-8c0b455-0b5e650-d7f0dd3-b100c87] on German WIN7 Home Premium (64bit)  

It seems to have been a FILEOPEN problem, sample345.ods what has been saved from 3.4.5 shows an ellipse covering A1:C5, but same document opened with 3.4.5 shows an ellipse not much bigger than A1, see attached sample document.

"LibreOffice Portable 3.3.0  - WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:6) tag libreoffice-]" also did not show the problem, so that was a regression.

Currently only reproduced with WIN
Comment 5 Rainer Bielefeld Retired 2012-01-21 00:00:33 UTC
Created attachment 55892 [details]
Sample Document

Opened with 3.4 only cell size ellipse, with 3.3 and 3.5 A1:C5
Comment 6 Rainer Bielefeld Retired 2012-01-21 00:01:03 UTC
OS All due to Comment 1