Bug reproduce steps: - create 2 calc documents : 'source' and 'link' - open them - doc 'source' : in cell A1 enter 'AAAA'. Copy the cell. - doc 'link' : paste special in A1 with 'Link' box checked. - save the 2 docs (don't close them) - doc 'source' : in cell A1 enter 'BBBB' (don't save) - doc 'link' : update (CTRL-SHIFT-F9). In A1 'AAAA' becomes 'BBBB' as it should. - doc 'source' : in cell A1 enter 'CCCC' then save and CLOSE this doc. - doc 'link' : update (CTRL-SHIFT-F9). In A1 'BBBB' becomes … 'AAAA' !!! - if you close and reopen 'link' and accept to update the links, then A1 contains the correct value ('CCCC'). I've tested this on: - LibreOffice 4.4.1.2 – windows 8.1 64b - LibreOffice 4.0.6.2 – windows 8.1 64b - LibreOffice 3.6.5.2 – windows 7 64b - LibreOffice 3.5.4.2 – debian linux 7.7
Reproducible with LO 4.4.1.2, Win 8.1
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.7 or 5.3.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170522
(In reply to ville_blois from comment #0) > Bug reproduce steps: > > - create 2 calc documents : 'source' and 'link' > - open them > - doc 'source' : in cell A1 enter 'AAAA'. Copy the cell. > - doc 'link' : paste special in A1 with 'Link' box checked. > - save the 2 docs (don't close them) > - doc 'source' : in cell A1 enter 'BBBB' (don't save) > - doc 'link' : update (CTRL-SHIFT-F9). In A1 'AAAA' becomes 'BBBB' as it > should. I think that only works since the data from source is available in the programs memory. See https://bugs.documentfoundation.org/show_bug.cgi?id=114998#c11 > - doc 'source' : in cell A1 enter 'CCCC' then save and CLOSE this doc. > - doc 'link' : update (CTRL-SHIFT-F9). In A1 'BBBB' becomes … 'AAAA' !!! That is odd. > - if you close and reopen 'link' and accept to update the links, then A1 > contains the correct value ('CCCC'). That is expected. Again see https://bugs.documentfoundation.org/show_bug.cgi?id=114998#c11
still tje same in Version: 6.3.0.0.alpha0+ Build ID: a798926550ab3ea8613f28a7be2672ebe9e7dfbe CPU threads: 4; OS: Linux 4.15; UI render: GL; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-24_03:53:22 Locale: nl-NL (nl_NL.UTF-8); UI-Language: en-US Calc: threaded
I can only update links with both documents open.
Dear ville_blois, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This bug has NOT been fixed. In Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 20; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Two Sheets Data and Display Display contains multiple sheets with graphs and dozens of named ranges and formulae. Data contains multiples sheet with graphs and tables with hundreds of formulae Display contains link ='file:///N:/Share/I../xxxxxxxxxxxxxxx/Weather/OR-LA-220.ods'#$'2025'.D4 to Display Both sheets are opened by automation every day. Entries cannot be entered in Data. F2 does not work. Edit > Cell Edit Mode must be clicked. New value is entered. Formula in Display is gone and the value entered in Data now appears in the cell. Display was opened first with no delay. This date Data now opens first w 5 second delay to Display. Please do not ask for sample files. When someone is going to look at this request the files via secure and private communication.
Created attachment 198609 [details] cell content
I had an unsaved workbook open Simple calcs 13 col x 29 rows, half empty Original B16 content: =HiV / AdjRng * AdjStep Two more workbooks were opened via automation several hours later. B16 is now: =HiV / AdjRng * AdjStep'file:///N:/Share/Ian/2530WillowCrest/Weather/OR-LA-220.ods'#$'2025'.D2407:4'file:///N:/Share/Ian/2530WillowCrest/Weather/Florence_Rain.ods'#$Analysis.B115 Opening Florence_Rain.ods is not editable with the cursor in B16 in untitled.ods Opening OR-LA-220.ods is not editable with the cursor in B16 in untitled.ods Removing the 'file:///N:/Share/Ian/2530WillowCrest/Weather/OR-LA-220.ods'#$'2025'.D2407:4'file:///N:/Share/Ian/2530WillowCrest/Weather/Florence_Rain.ods'#$Analysis.B115 from untitled:B16 and hitting ESC in OR-LA-220.ods returns operation to normal.