Created attachment 159466 [details] The affected Calc document I copied a spreadsheet within a Calc document ("Projektion V.3" => "Projektion V.4") and changed the referenced data cells in the copy (V.4) to calculate a more accurate projection from more recent entries in the table of the first spreadsheet ("Tabelle"). The Problem: The Diagrams in V.4 remain identical to the ones in V.3 and don't update. When I try to edit them however, they update as soon as I go into editing mode (by double-clicking them or right-click -> "edit") and show the correct curves for the new values. But as soon as I leave the editing mode (e.g. by clicking somewhere else on the screen) they revert back to the old diagram.
ADDITION: After closing office, restarting the software and opening the document again the diagrams have updated.
Not reproducible for me. I tried to reproduce your problem following these steps: 1/ add a new sheet sheet8 2/ select the whole sheet Projektion V.4 3/ go to sheet8.A1 then ctrl+Shift+V (Paste special) and choose "Paste all"; doing so formula are pasted Here we have the same diagrams in sheet8 as in sheet Projektion V.4 but referring to cells in sheet8. If I do ctrl+V instead of ctrl+Shift+V, diagrams in sheet8 refer to Projektion V.4, not the current sheet. 4/ in sheet Projektion V.3, copy A3:H5 and paste it in sheet8.A3:H5, then the values in sheet8 become identical to one in Projektion V.3, and the diagrams are immediately updated to reproduce the diagrams from sheet Projektion V.3. I did my test with Version : 6.4.4.0.0+ Build ID : f075eaf3e6e4244cb7b92420e4286848bf22ed91 Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; Ubuntu_18.04_x86-64 Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded What happens for you if you do exactly the same steps as me ? Status set to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF
Dear director84, 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
PROVIDE INFO: I am meanwhile using the current version of Libre Office on a new Laptop: Version: 6.4.6.2 Build-ID: 1:6.4.6-0ubuntu0.20.04.1 CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3; Locale: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded The Linux distribution is Mint 20.0 Ulyana, running on an ACER A515-52g. When I submitted the bug it was Ubuntu 19.04, I think, maybe still 18.10. It was running on an M$ Surface Pro 4 tablet with the modified linux-surface kernel for Debian based distributions, adding touch screen support, etc. RESULT OF TEST as instructed in Comment 2: Following your steps exactly (Only added pressing Ctrl+C in step 2, otherwise there is nothing to paste in the new sheet), all the diagrams in sheet8 will still refer to V.4 (I did press Ctrl+Shift+V and selected "paste all")., so changing the table in sheet8, like copy-pasting (using regular Ctrl+V) the values of V.3 A3:H5 to sheet8 A3:H5, will change nothing in the diagrams. THE WAY I DID IT ORIGINALLY, and which I retried then, was to right-click on the tab of table V.4 and chosing "copy/move sheet". In the appearing dialog I chose "put the new sheet in the end" and entered the name "sheet8". Doing it this way, the diagrams refer correctly to the table in sheet8. pasting the values of V.3 A3:H5 to sheet8 A3:H5 now, THE BUG WILL STILL HAPPEN AS DESCRIBED: The diagrams are not updated. But when I double click one of them, to go into editing mode, they are being updated. When I leave editing mode, they revert to the previous state. I did not try now saving, closing and reopening the program. Last time the diagrams would have updated after closing and reloading the Calc document.
[Automated Action] NeedInfo-To-Unconfirmed
Bug 86321 was fixed meanwhile, so could you test with 7.0.6, 7.1.3 or newer?
Dear director84, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp