Bug 78069 - Add easy extenders for chart ranges ...
Summary: Add easy extenders for chart ranges ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: Other All
: medium normal
Assignee: Not Assigned
Keywords: difficultyInteresting, easyHack, skillCpp, topicCleanup
Depends on:
Reported: 2014-04-29 09:08 UTC by Michael Meeks
Modified: 2015-12-16 00:24 UTC (History)
1 user (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 Michael Meeks 2014-04-29 09:08:06 UTC
One rather annoying feature of charts is that they crop the range of charted cells to the area containing data. This means as you insert new rows you have to edit each chart to add new rows.

When you have a range that is dis-contiguous, you have to edit several times in a long string to expand the range.

It would be rather lovely if there was some "add row" and "add column" button / icon that would extend each of these selected areas:

Double click on a chart (of some data in a sheet - from a couple of ranges) to activate it, then Right click, and select 'Data Ranges'; that hits this dialog:

chart2/uiconfig/ui/tp_RangeChooser.ui:            <property name="label" translatable="yes">Data Range</property>


It would be fantastic to have two extra buttons in there (on the right?) with some pretty UI icons to extend all the ranges down and or right =) [ I suspect the common use-cases ].

Thanks !
Comment 1 Markus Mohrhard 2014-04-29 09:30:51 UTC
This has been fixed recently as part of bug 70609. Right now it is limited to ranges with more than 10k cells and we plan to switch to dynamic shrinking (therefore when we fetch data we build the intersection data range with the chart range and use that) which will fix it even for larger ranges. That is tracked as bug 55697.

I'm not sure if this expand range feature is still necessary.
Comment 2 Michael Meeks 2014-04-29 09:54:53 UTC
Oooh - nice =) glad to see that fixed. I imagine shrinking to the size containing actual data is rather important inside the chart itself ;-) but hopefully we can load/save/preserve a much larger range that can subsequently be filled with data =)

if so; marking this closed...
Comment 3 Robinson Tryon (qubit) 2015-12-16 00:24:51 UTC
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp TopicCleanup)