Bug 78069

Summary:	Add easy extenders for chart ranges ...
Product:	LibreOffice	Reporter:	Michael Meeks <michael.meeks>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	robinson.libreoffice
Priority:	medium	Keywords:	difficultyInteresting, easyHack, skillCpp, topicCleanup
Version:	4.2.0.0.alpha0+ Master
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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>

chart2/source/controller/dialogs/tp_RangeChooser.cxx

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)
[NinjaEdit]