Download it now!
Bug 47593 - : Ranges in charts - conditional formatting - spreadsheet protection
Summary: : Ranges in charts - conditional formatting - spreadsheet protection
Status: RESOLVED DUPLICATE of bug 55697
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
3.5.1 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2012-03-20 09:07 UTC by Pfuschi
Modified: 2013-05-06 15:43 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

heating oil prices irregularly taken from websites of vendors (55.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-20 09:07 UTC, Pfuschi

Note You need to log in before you can comment on or make changes to this bug.
Description Pfuschi 2012-03-20 09:07:59 UTC
Created attachment 58765 [details]
heating oil prices irregularly taken from websites of vendors

Problem description: 
An old problem with charts in CALC did newly arrive with LibreOffice 3.5.x: the data range and the series ranges cannot be freely adjusted. This happened before and drove me mad about OpenOffice and (here I'm not sure) LibreOffice, so I had to stay with my 2000 version of MSOffice for charts (by using Windows XP in VirtualBox). It is okay with version 3.4.4, as I just did retest.
Mac OS X 10.6.8 (10K549) updated today on MacBook Pro 17” mid 2009.

I' m frequently using x-y charts to show statistics along time. I had prepared a file with a chart for which I had defined a range for data entry. Today - it seemed - this range got used up and I wanted do extend it for the months to come. At this point I also noticed that this was a line chart instead of an x-y chart. I changed the chart type and tried to extend the range. Whatever I entered for ranges it was immediately reduced to the range already filled with data. I added a few more data lines and again I could extend the range up to these new lines, but not further.
I got the original file back (thanks to Steve Jobs and his Time Machine!), opened it with LO v3.4.4, changed chart type to x-y, and moved data and series ranges freely up and down. I opened the newly prepared file with the extended ranges with v3.5.0 and v3.5.1 and found the ranges reduced to the filled cells. I deleted some rows of data – the ranges stayed where they were, even after saving the file. But after closing and reopening the file the ranges were reduced to the now smaller range of filled data.

By the way: I would be glad, if the problem with conditional formats not moving with the cells they were defined for could be solved, as I' m using these quite frequently. I just got to notice, that there is an additional problem: when the spreadsheet is selected to be protected, the conditional formatting (and other colour formatting) turn inactive.

Many thanks anyway for the great work.

Steps to reproduce:
1. ....
2. ....
3. ....

Current behavior:

Expected behavior:

Platform (if different from the browser): 
Browser: Opera/9.80 (Macintosh; Intel Mac OS X 10.6.8; U; de) Presto/2.10.229 Version/11.61
Comment 1 Markus Mohrhard 2012-03-20 10:50:43 UTC
Can you please separate these bug reports and for the chart one write a clear description what is happening, what you expected and a detailed step by step instruction how to reproduce.
Comment 2 Pfuschi 2012-03-20 16:29:24 UTC
A. Chart ranges
1. Usually opened file with LibO 3.4.4, doubleclicked chart and changed data and series ranges freely. This is, how it should behave.
2. Opened unchanged file with new LibO 3.5.0 or 3.5.1, doubleclicked chart and tried to change data and series ranges. It was not possible to enter any range beyond cells filled with data; i.e. the range is immediately (while entering) reset to range of filled cells. When entering additional data, the ranges can be extended up to filled cells (but no further). When removing data, the ranges extend beyond filled cells, even when file is saved. But upon closing and reopening the file the ranges are reset to the extent of filled cells. This is not as it should behave, as for presenting new entered data in the chart the ranges have to be adjusted manually upon each data entry.

Remark: this same problem occured in earlier versions of OpenOffice (and LibO?) and even worse, the menu point 'data ranges ...' was sometime greyed and not usable. Excel (2000) would behave correctly with the same files.

B. Conditional formatting
see Bug 37987 and hopefully it will be solved soon.

C. Background colour
Any background colour is not shown on screen in a protected sheet (but is shown in page preview and PDF output). Maybe I'm going to open a new bug for this minor defect.
Comment 3 Michael Crouch 2012-11-12 18:18:51 UTC
Bug A seems to be a duplicate of Bug 55697.
Comment 4 Markus Mohrhard 2013-05-06 15:43:38 UTC

*** This bug has been marked as a duplicate of bug 55697 ***