When inserting a chart using the wizard, an object (what will later become the chart, but is still a white and empty shape at that stage of the wizard) obstruct cell selection on part of the sheet, making it difficult to select cells under this object.
Steps to Reproduce:
1. In Calc, try to Insert > Chart…
2. Click on one of the buttons to select cells range in "Data series" or "Data range" in the wizard.
A white and empty shape is already placed on the sheet that should contain the chart later. This object is placed over a large zone of cells so that if you need to select cells under this object, you just can't do it. You can't even see them.
It should be possible to see and select cells over the whole sheet. Therefore, the object should not be here at this step when using the wizard and should either be created later, or be hidden at this step.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:53.0) Gecko/20100101 Firefox/53.0
Yes it has happened to me as well. I behaves the same in LO 5.3 beta2
Hi Clément, superurbi,
What happens if you first select the whole Data range and
Insert chart next
Select another sheet before Insert chart?
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
(In reply to Jacques Guilleron from comment #2)
> Hi Clément, superurbi,
> What happens if you first select the whole Data range and
> Insert chart next
> Select another sheet before Insert chart?
Sorry, I totally missed the needinfo (offtopic, but it could be wise to enable the needinfo reminder available in Bugzilla).
So, to finally answer your questions, both of what you're proposing are working.
However those are still other ways to do things and depending on the people this is, in my humble opinion, a mere workaround.
This doesn't change the fact the user shouldn't be disturbed by the chart shape to select cells later.
(In reply to Clément L. from comment #4)
> (In reply to Jacques Guilleron from comment #2)
> > Hi Clément, superurbi,
> > What happens if you first select the whole Data range and
> > Insert chart next
> > or
> > Select another sheet before Insert chart?
> > Jacques
> Sorry, I totally missed the needinfo (offtopic, but it could be wise to
> enable the needinfo reminder available in Bugzilla).
> So, to finally answer your questions, both of what you're proposing are
> However those are still other ways to do things and depending on the people
> this is, in my humble opinion, a mere workaround.
> This doesn't change the fact the user shouldn't be disturbed by the chart
> shape to select cells later.
You can also insert the chart and then select the range of data using the Data Ranges dialog
When clicking the 'select data range' button in step 2 of the wizard hides the wizard dialog to not obstruct selection, so in the same way the chart should be hidden to do the same.
Heiko, Stuart: thoughts?
(In reply to Yousuf Philips (jay) from comment #6)
> When clicking the 'select data range' button in step 2 of the wizard hides
> the wizard dialog to not obstruct selection, so in the same way the chart
> should be hidden to do the same.
> Heiko, Stuart: thoughts?
Adding just to be sure: there's data range, but there's also the data series selection.
Created attachment 137399 [details]
Screenshot of step 2 with hidden wizard but dummy chart visible
It's not the wizard that bothers the OP but the chart 'preview' is annoying. We made a proposal to rework the chart wizard some time ago where the preview was integrated into the dialog. That would solve the issue.
(In reply to Heiko Tietze from comment #8)
> We made a proposal to rework the chart wizard some time ago where the
> preview was integrated into the dialog. That would solve the issue.
Heiko, the link seems dead, could you make it available again? I am interested in this, because I had thought that it could only be fixed pragmatically by hiding the Chart Area, but this doesn't sound bad; however, how would the scaling of the chart be dealt with? A chart with appropriate size will often be as big as the dialog or bigger.
This issue is still present in LibreOffice 18.104.22.168.0.
(In reply to Severo Raz from comment #9)
> > https://user-prompt.com/libreoffice-design-session-inserting-a-chart/
> Heiko, the link seems dead, could you make it available again?
Yes, the site has been closed recently. Poked the owner and he promised to give me temporary access so that I can move the content to our new blog. Still pending, though.
"LibreOffice Design Session: Inserting a Chart" is resurrected at https://design.blog.documentfoundation.org/2015/04/16/insertchart/ (hope it hasn't become a zombie)
(In reply to Heiko Tietze from comment #11)
> "LibreOffice Design Session: Inserting a Chart" is resurrected at
> https://design.blog.documentfoundation.org/2015/04/16/insertchart/ (hope it
> hasn't become a zombie)
Thank you for this. This looks good and would definitely solve the problem, from my perspective; Clément L. what do you think?
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
I tested this bug with LO 6.2.4 and it has not been resolved.
This bug is inherited from OOo and I have set the version to match this.
I would add even more drastic proposal – to hide all charts in Calc while range selection is active (or how is called mode when wizard is minimized to a single entry line).
Build ID: 828a45a14a0b954e0e539f5a9a10ca31c81d8f53
CPU threads: 6; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: lv-LV (lv_LV.UTF-8); UI: en-US