Description: I believe this is a reversion of FIXED Bug 136816 When the data columns for a bar chart are hidden then the chart elements disappear BUT it only occurred after I edited an existing chart to include what have become the top and bottom rows. Even deleting the chart and recreating it with the inclusion of the new top and bottom rows causes the error. Interestingly the original file which had been saved prior to any amending still performs perfectly. The new version includes the inserted symbols in G4, G15 & G16 Steps to Reproduce: Two files attached Open both and compare the effect when hiding the column G Group Actual Results: Top chart goes on the "missing" list Expected Results: Top chart should stop playing truant Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.3.5.2 (x64) / LibreOffice Community Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 182062 [details] Sample Working Sheet Why won't the system allow me to add multiple files?
Created attachment 182063 [details] Sample Error File Why won't the system allow me to add multiple files?
NOTE: Obviously the URL Buttons are pointing to local files and won't work. My apologies - I should have ditched them before attaching them.
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
Created attachment 182910 [details] Image of two edit panes identifying the culprit
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!
(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
(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
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 [details] 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.
(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.
Unfortunately, I still can't reproduce. Could you please see if the issue remains in version 7.4.3?
(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.
thanks for following up!