Bug 47584 - When adding data, Calc should suggest extending the data range to include it in the chart
Summary: When adding data, Calc should suggest extending the data range to include it ...
Status: RESOLVED DUPLICATE of bug 42196
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Hardware: Other All
: low enhancement
Assignee: Not Assigned
: 146399 (view as bug list)
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
Reported: 2012-03-20 06:55 UTC by Thomas Bertels
Modified: 2022-12-16 19:12 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Bertels 2012-03-20 06:55:00 UTC
Steps to reproduce:

Open Calc
Create a new Spreadsheet (File -> New -> Spreadsheet)

Enter the following data:
- In cell A1: 1
- In cell A2: 2
- In Cell A3: 3

Select cells A1:A3 and insert a column chart (Insert -> Chart... -> Finish)

Click on cell A4 and enter: 4

Expected result:
Calc should ask us if we want to extend the chart data range to include the new data (cell A4) in the chart.

This could be done with floating pop-up. There should be a Yes and a No button and a checkbox to do it each time without asking.
A drop-down list should added to the chart option to be able to change the default behavior.
Comment 1 Not Assigned 2012-05-01 08:29:55 UTC Comment hidden (obsolete)
Comment 2 Andras Timar 2012-05-01 11:31:01 UTC
(In reply to comment #1)
> Andras Timar committed a patch related to this issue.
No, it was for bug #47548. Sorry for the noise.
Comment 3 sasha.libreoffice 2012-06-14 01:00:47 UTC
Thanks for new idea
This bugreport describes idea how to solve problem, described in Bug 42196
Comment 4 Joel Madero 2012-07-02 21:41:05 UTC
I have mixed feelings about this one. I think that a pop up message every time could get really annoying. Another solution could be possible though, going to open this up to the devs to see if other solutions can be suggested.
Comment 5 Joel Madero 2012-07-02 21:46:26 UTC
Actually I have a different solution. I think better solution is that you can select entire column(s) and then chart auto adjusts to new entries in the column. This way it's automated instead of having some dialog come up every time you add a new entry.
Comment 6 Thomas Bertels 2012-07-03 00:07:54 UTC
I was thinking about something: why not use a floating icon next to the cells where we added some data, a la Office 2010? Would there be a patent about that?
Comment 7 m_a_riosv 2021-12-24 09:48:56 UTC
*** Bug 146399 has been marked as a duplicate of this bug. ***
Comment 8 Stéphane Guillou (stragu) 2022-12-16 19:12:47 UTC

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