<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_VERIFIED bz_closed" title="VERIFIED FIXED - EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=86321#c126">Comment # 126</a> on <a class="bz_bug_link bz_status_VERIFIED bz_closed" title="VERIFIED FIXED - EDITING, FORMATTING: diagram didn't automatic update when change variable (steps in comment 28)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=86321">bug 86321</a> from <a class="email" href="mailto:vlb1@vlbnu.nl" title="VLB <vlb1@vlbnu.nl>"> VLB</a> <pre>> Can you please use these steps? > Step 1. Close actual work with Libreoffice (Writer or Calc)or restart > computer. > Step 2. (Important to follow) Start Calc but do not open any other file. > Step 3. Open only the attachment, only file Ligger V2.6 <a href="https://bugs.documentfoundation.org/attachment.cgi?id=114246" name="attach_114246" title="Latest Issue graphic">attachment 114246</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=114246&action=edit" title="Latest Issue graphic">[details]</a> > [details] > Step 4. Go to sheet invoer. > Step 5. Use mouse to Select H19 to L19. Those cells now highlighted. > Step 6. Use keyboard (important) delete key to empty those cell values. > Step 7. Observe column EB; most cells EB50 to EB148 change to WAAR. > Step 8. Observe chart at M66; the traces change to sawtooth. > Step 8. Use mouse (important) toolbar "back arrow" to "Undo:delete". > Step 9. Observe column EB; the cells do not go back to original state. > Step 10. Observe chart at M66; one line (for DT data) does not go back. > > [At this stage, something complex is occurring in the memory; please don't > touch any cell or chart or data range; please just observe and compare to > help me help you]. > > Step 11. Close Libreoffice (close the program) and do not save the file. > Step 12. Start Libreoffice and open only the attachment, only file Ligger > V2.6 > Step 13. Go to cell AM38. Function is ==IF((L_7>0),Mh/Mh_freq,"") > Step 14. Change the function to =IF((L_7>0),Mh/Mh_freq,""), remove double== > Step 15. Immediately save the file as "Ligger V2.6 test repair by VLB.ods" > Step 16. Close Libreoffice (close the program) > Step 17. Start Libreoffice and open the new test repair file. > Step 18. Please test using Step 4 to Step 10. > > [At this stage, on this computer here, column EB and the chart M66 and all > data on every sheet respond correctly about all functions :). It would be > great if you could use the file intensely. Also, please let me know if E12 > action is still a problem or resolved for you. I can do more. > > Step 19. (Important). Click Calc>Help>About>Version information button. > Please right-click paste on your response here (or in email). Please attach > here or email the "test repair by VLB" file from your PC. What you see or > don't see (in columns and charts) depends on that information. > Version: 7.1.3.2 (x64) / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: nl-NL Calc: CL I have gone through the steps and can indicate my findings: In steps 8 and 9, the value will go back in column EB for me. At step 10 I see 1 line that does not go back in a sawtooth. After performing step 18, the graph in step 10 is displayed correctly. I added the saved file as an attechment.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>