[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Stéphane Guillou (stragu) changed: What|Removed |Added Blocks||90486, 116661 Resolution|--- |WORKSFORME Status|UNCONFIRMED |RESOLVED --- Comment #13 from Stéphane Guillou (stragu) --- thanks for following up! Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=90486 [Bug 90486] [META] Chart bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=116661 [Bug 116661] [META] Group and Outline bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Colin changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #12 from Colin --- (In reply to Stéphane Guillou (stragu) from comment #11) > Unfortunately, I still can't reproduce. > Could you please see if the issue remains in version 7.4.3? Agreed, Seems to be OK in 7.4.3. I'll change the status to UNCONFIRMED and the kudos goes to you for RESOLVED. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Stéphane Guillou (stragu) changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #11 from Stéphane Guillou (stragu) --- Unfortunately, I still can't reproduce. Could you please see if the issue remains in version 7.4.3? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Colin changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #10 from Colin --- (In reply to Stéphane Guillou (stragu) from comment #9) > I couldn't reproduce either with: > Note that the data series in the bar chart did _not_ have the "Include > values from hidden cells" setting turned on when the file was opened. I had > to do that first. As I originally stated - that's the workaround When the chart is originally created with perhaps 6 rows of data and the parameter is set to include hidden cells and the columns are hidden it works perfectly. When one decides to unhide the columns and add a few rows by editing the data range then it "appears" to work fine - until the columns are hidden. unhide the columns and the elements return Inspect the parameter and it still "appears" to include the hidden cells but that is now a fake because the elements disappear every time the columns are hidden. Once you change the parameter to "NOT" show the hidden cells and hide the cells it properly hides them. THEN unhide the columns Edit the parameter to again include the hidden columns hide the columns and the "hidden" data elements remain - as expected. Ergo the parameter is corrupted by the first editing of extra elements and when one the re-edits the parameter that was never changed (but corrupted) in the first place, the elments magically reappear and remain - But only until one decides to add even more elements. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Stéphane Guillou (stragu) changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #9 from Stéphane Guillou (stragu) --- I couldn't reproduce either with: Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: de-DE (en_AU.UTF-8); UI: en-US Calc: threaded Nor: Version: 7.3.7.2 / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: de-DE (en_AU.UTF-8); UI: en-US Calc: threaded Nor: Version: 7.2.7.2 / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: de-DE (en_AU.UTF-8); UI: en-US Calc: threaded Nor: Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded Note that the data series in the bar chart did _not_ have the "Include values from hidden cells" setting turned on when the file was opened. I had to do that first. What I did: 1. Open attachment 182063 2. Double-click bar chart to go in edit mode 3. Right-click on bars, Format data series > Options tab, tick "Include values from hidden cells" 4. Change chart data ranges to start at row 5 instead of row 4 5. (check that "Include values from hidden cells" is still ticked) 6. Hide column group G to I Results: Bars still shown. Changing the "Include values from hidden cells" settings, and hiding/showing the columns does have the expected effect. Please try a recent version of LibreOffice: 7.3.7 or 7.4.2 and let us know if you can reproduce the issue with the steps above. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #8 from Colin --- (In reply to Colin from comment #7) > (In reply to Stéphane Guillou (stragu) from comment #6) > > Thanks Colin. > > > > > I am finding it hard to test the issue you are describing. > > Could you please: > > > > - Describe the simplest series of precise steps to reproduce the issue, > > starting with which attachment to use > > Hi Stéphane > Oops, forgot to mention that you may wish to focus row 4 by clicking any cell in row 3 and then a down arrow My bad -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Colin changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #7 from Colin --- (In reply to Stéphane Guillou (stragu) from comment #6) > Thanks Colin. > > I am finding it hard to test the issue you are describing. > Could you please: > > - Describe the simplest series of precise steps to reproduce the issue, > starting with which attachment to use Hi Stéphane With the file Chart Error Ensure group G is unhidden Double click the chart to activate the chart editing ribbon Select Data Range for editing Edit the two range values so that they both commence on row 5 as opposed to row 4 Hide Group G The chart elements should now have disappeared Now the image of the two edit panes should help you to realise that the data series parameter (Right click one of the data elements in the chart) to hide or include the hidden cells is being corrupted by the edit process - It presents on screen as checked to include hidden cells but ignores the parameter. changing the flag, saving, accessing the flag changing it back again will force it to behave as expected -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 Stéphane Guillou (stragu) changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||stephane.guillou@libreoffic ||e.org --- Comment #6 from Stéphane Guillou (stragu) --- Thanks Colin. I can't reproduce bug 136816, so don't think it is the same thing. I am finding it hard to test the issue you are describing. Could you please: - Describe the simplest series of precise steps to reproduce the issue, starting with which attachment to use - Test it with version 7.4, downloaded from https://www.libreoffice.org/download/download-libreoffice/, to see if the issue remains Thanks! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #5 from Colin --- Created attachment 182910 --> https://bugs.documentfoundation.org/attachment.cgi?id=182910=edit Image of two edit panes identifying the culprit -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #4 from Colin --- Found the source of the issue (and the workaround pending a fix) If the Data range is edited then saving the edit disables the inclusion of hidden cells but leaves the checkbox indicating that they are included. The simple workaround is:- Edit and save the Range adjustment Hide the columns Unhide the columns Edit -Disable- the inclusion Save the change Edit -Re-enable- the inclusion Save the change Hide the columns It may be that all the hiding and unhiding are superfluous and that simply editing the range and inclusion parameter together are the "workaround". Image attached -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #3 from Colin --- NOTE: Obviously the URL Buttons are pointing to local files and won't work. My apologies - I should have ditched them before attaching them. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #2 from Colin --- Created attachment 182063 --> https://bugs.documentfoundation.org/attachment.cgi?id=182063=edit Sample Error File Why won't the system allow me to add multiple files? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150657] CALC Chart elements disappear when the data columns are hidden
https://bugs.documentfoundation.org/show_bug.cgi?id=150657 --- Comment #1 from Colin --- Created attachment 182062 --> https://bugs.documentfoundation.org/attachment.cgi?id=182062=edit Sample Working Sheet Why won't the system allow me to add multiple files? -- You are receiving this mail because: You are the assignee for the bug.