| Summary: | Changing the range of a chart makes the chart to dissapear | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | chrisdecorte |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | xiscofauli |
| Priority: | medium | ||
| Version: | 7.0.0.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | error calc | ||
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) Dear chrisdecorte, 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: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO 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! Warm Regards, QA Team MassPing-NeedInfo-Ping Dimitris Kallipolitis just gave a very likely solution for the problem: I have found a solution to this problem: Go to Tools->Options->LibreOffice→Advanced→Open Expert Configuration→ Search for ‘cache’→ Change org.openoffice.Office.Common→Cache→Drawing Engine (OLE_Objects) to e.g. 40 (default value 20). This value should be greater than your maximum number of charts in any spreadsheet that you use. A lower value causes some charts not to be updated when spreadsheet data is updated. It's a cache issue. Verified with: Version: 7.1.2.2 / LibreOffice Community Build ID: 10(Build:2) OS: Linux 5.8; UI render: default; VCL: gtk3 Ubuntu package version: 1:7.1.2~rc2-0ubuntu0.20.04.1~lo3 Calc: threaded So, I think, the error can be closed. Setting to RESOLVED WORKSFORME since the commit fixing this issue hasn't been identified. |
Created attachment 166289 [details] error calc Another error with Charts in Calc: I have a sheet in a separate page from my data. When I click on the chart and then select "edit", then "data ranges", then I change the range from: $data.$DX$500:$DZ$706,$first.$A$1,$data.$GW$500:$GX$706 to: $data.$DX$500:$DZ$717,$first.$A$1,$data.$GW$500:$GX$717 then in the tab "data series", I also change all the Y values accordingly from: $data.$DX$500:$DX$706 to: $data.$DX$500:$DX$717 the chart seems to have adapted itself to the changes. However, when I press "OK", everything in the chart area disappears ...