In an existing sheet, create a chart, then try to edit the data range by selecting it from the sheet.
Try to select 2 non-contiguous columns, ex. column A & C without selecting column B.
Selection is considered finished when mouse button is depressed, even if I keep the 'Ctrl' key pressed, the only way to select non contiguous data is either to enter it by hand or create a newchert from scratch.
I could not reproduce on LO126.96.36.199 WinVista32bit.
I can select multiple non-contiguous columns by holding down Ctrl and clicking the column headings individually.
A few additional elements, my first descritpion was quite unclear:
The problem occurs on existing charts, when trying to edit the data range.
Trying to select several non contiguous cell blocks doesn't work, once the mouse button is depressed, calc fills the data range and won't accept any other selection.
I also tried to click on the column headings, it has no effect at all.
Occurs on LO188.8.131.52 Win XP & 184.108.40.206 WinXP.
I see what you mean.
I tried doing the same thing in Excel 2007 and it does let you select multiple regions.
I don't know if this is a bug in the current LibreOffice or if this would be considered an enhancement. It may be working "as designed".
Well, it's annoying enough that several users reported it to me.
Maybe the feature needs enhancement to be more user friendly.
Do you know if this used to work on previous versions of LibreOffice? e.g. 3.5 ??
This may be related to bug 55697 ("impossible to define data ranges beyond actual filled cells").
I can confirm this in LO 220.127.116.11, Ubuntu 12.10.
It is a problem as it is something that is possible when creating a new chart but not when editing its data range later on. It makes it inconsistent.
When sorting rows, the data range of the chart doesn't follow automatically the reorganised cells, which means the data ranges have to be edited by hand, or the user has to start again from scratch.
This highly disrupts the workflow.
Created attachment 83210 [details]
PDF showing the Bug
This bug is still present in Libre Office 4.1.
When I try to create a new graph, in the graphic assistant wizard it is impossible to select non-contiguous cells. When selecting the data interval, when I stop pressing the mouse button it stops the selection regardless of keeping Ctrl button pressed.
It is disruptive and impacts productivity a lot when trying to prepare graphics that have lots of repeated data and where you want to select relevant data in non-contiguous cells. The PDF I sent shows an example of such a use case.
Considering that working with Calc is essential for many people I would say this is important.
I changed this ticket back to NEW (I don't know why it was changed from NEW back to NEEDINFO in the first place; all the information required is here)
Confirming. This bug is present on 3.4.1 and 4.x.
It is a very annoying bug, my colleagues has documents full of graphs and editing all of these is a very pain.
Yes, a really annoying bug... I have got used to type the "formula range" in it's corresponding field instead of selecting the range with the mouse.
Yes i can see how this would be annoying to users modifying an existing chart.
I would propose that it doesnt auto expand from the data range floating dialog until the user presses the 'expand' button, as that is the purpose of the button.
(In reply to Jay Philips from comment #13)
> Yes i can see how this would be annoying to users modifying an existing
> I would propose that it doesnt auto expand from the data range floating
> dialog until the user presses the 'expand' button, as that is the purpose of
> the button.
I agree, though there's one more issue regarding the title of this bug:
1) From the edit mode of a chart which already have series, right click -> modify data
2) Try to modify any series, pressing the corresponding button
3) The "select range" window appears, and it has the text corresponding to the actual range already selected.
4) Try to select the range to append, pressing Control + selecting this new range with the mouse.
Original range is deleted, and the selected range is the only one
The range selected while pressing Ctrl is appended to the original range.
1) With the "select range" window opened, deselect the actual range
a2) Manually, add a "comma" at the end of the range.
3) Proceed selecting (no Ctrl key pressed is necessary).
If the floating dialog didnt auto expand, i'd assume that ctrl + select would automatically work, but i guess the dev who takes this on would have to confirm that.
Migrating Whiteboard tags to Keywords: (needsDevEval)
@Cor, @Stuart, @Heiko: What's your take on this and my suggested solution in comment 13?
@Eike: Any input on this issue?
(In reply to Yousuf (Jay) Philips from comment #17)
> @Cor, @Stuart, @Heiko: What's your take on this and my suggested solution in
> comment 13?
Fine - don't use that often, but do remember it's annoying in the current state.
Yes, a UI holding off expansion until all selections are added and the button is selected makes sense.
This problem appears to be unresolved after four and a half years since it was first reported! I have tested LibreOffice Calc v18.104.22.168 on Linux Mint 17.3 64-bit, and v22.214.171.124 on Windows 7 Professional 64-bit. At the risk of redundancy, allow me to detail the steps to reproduce the condition:
1.) Double-click a chart to edit it.
2.) Right-click the chart and select Data Ranges...
3.) On the Data Series tab, click the minimize icon next to the Categories field.
4.) Select any cell, and the "Select Range for Categories: Area" dialogue automatically expands to the main "Data Ranges" dialogue, preventing any further selection.
In order to add more cells to the range, the minimize button must be clicked again, the cursor moved to the end of the line to deselect its current content, a semi-colon added (or a comma, in my case), and the next desired cell selected. Rinse and repeat...
Is it difficult to remove the line of code that forces the selection dialogue to expand on lifting the mouse button? Manually adding a delimiter on selection, instead of its automatic addition, as performed by other spreadsheet programs, is not a major issue, but navigating the entire multi-click process for every cell required is extremely laborious on large spreadsheets.
Finally (this should probably be submitted on it's own bug report), there is no way to exit the chart editing dialogue without the chart being updated with the new selection. It doesn't matter whether the OK, Cancel or Close (X) button is clicked, or the dialogue is closed by means of the Escape key, the newly selected, potentially erroneous data range appears on the chart. And, there is no undo function that reverses the mess!
(In reply to Gavin D from comment #20)
> Is it difficult to remove the line of code that forces the selection
> dialogue to expand on lifting the mouse button?
Maybe, maybe not. Feel free to take a look: https://wiki.documentfoundation.org/Development
So this bug, which I reported as still present in 2013, that is classified as High Major in importance is still not resolved?
Seriously, how hard can this be? Just change the line of code that determines that you end the selection when lifting the mouse button to when you lift the Ctrl button.
I don't have programming background, and it might be more difficult than this, but the likelihood is that it's not.
This is a ridiculous bug that really impacts how common users might use the Chart wizard, if the data to build a chart is in non-contiguous cells. And STILL it's not fixed?
For Christ's sake, I finished a PhD in the time I reported this bug.
(In reply to Pedro from comment #22)
> So this bug, which I reported as still present in 2013, that is classified
> as High Major in importance is still not resolved?
Thanks for pointing to this error.
It is a normal bug. Already present from OOo times. With a simple work around: type the range. And I think that not a majority of LibreOffice users is affected ;)
I do not intend to annoy you, but we all need to be realistic in terms of expectations.
Oh, I use a different work around: I just use Excel.
If you think I'm going to be scrolling up and down and noting down which cells I have to write down, you are sorely mistaken.
If I have to fight the UI of Calc to work, I'll just use another piece of software that works as intended. And it is a sorry excuse to tell someone to work another way instead of reviewing a bug that as you said, is present since the Open Office days.
That's a freaking joke of an answer and it would've been better if you hadn't said anything.
Feel free to use Excel. It is excellent software. We won't mind.
Pedro et al., may I remind you of Bugzilla’s etiquette, § “No obligation”?
I suggest a "want fix". The range chooser is exactly for the purpose of having simple structured source date. Advanced cases can be solved in the data series tab/dialog.
In the simple case, where the x-values are in the left most column and several y- data series are in not adjacent columns but in the same rows as the x-values, the selection with Ctrl-key works in range chooser.
(In reply to Regina Henschel from comment #27)
> In the simple case, where the x-values are in the left most column and
> several y- data series are in not adjacent columns but in the same rows as
> the x-values, the selection with Ctrl-key works in range chooser.
Sorry but it doesn't: pressing Ctrl key doesn't stop the behavior described. Instead after selecting one cell and release the mouse click, the selection dialog is closed.
One must then:
1) press the selection dialog button again
2) unselect the previous data range in order to avoid overwrite
3) press Ctrl key to select the new cell and select. Alternatively, one could also insert a comma after the selection range and then select the nre cell
4) repeat the procedure for as many cells should be selected.
The idea is behind this is allow the user to select as many ranges as desired and come back the data series dialog only after pressing the corresponding button instead of after the release of the mouse click.
Otherwise... Why is the button that finish the selection in the data series selection dialog?
(In reply to Francisco from comment #28)
> Sorry but it doesn't: pressing Ctrl key doesn't stop the behavior described.
> Instead after selecting one cell and release the mouse click, the selection
> dialog is closed.
You are right for an existing chart. To add something you have to deselect the field, add a semicolon at the end of the line, and then select the next part.
Finish selection not on mouse up but with click on the expand/shrink button might work better.
Well, since this bug is still in 6.2 I decided to follow a different approach:
I care about getting this fixed, so I'm offering USD 20 via FreedomSponsors to the first person who fix it.
Offer link: /issue/841/chart-impossible-to-choose-non-contiguous-range-when-editing-data-range-with-use-of-the-expand-button
You can also join me and throw in a few bucks there and we'll get it fixed faster :)
If you fix this issue (see my acceptance criteria there) please use that site to request your payment.
I'll pay a meal to the kind hearted dev that fixes this. :D
*** Bug 122012 has been marked as a duplicate of this bug. ***
*** Bug 122007 has been marked as a duplicate of this bug. ***