Description: When I copy-special (link option) empty cells from one sheet to another, I do not get a link to the original cells, but completely empty cells, with no links. If a cell in the original sheet is emptied, then the cell linked to it shows the value '0'. Steps to Reproduce: 1.create sheet A containing some filled and some empty cells 2.create sheet B 3.copy the content of sheet A 4. paste it into sheet B with 'paste special' selecting 'link' option and 'paste all' selected 5. in sheet B the cells that contained something in sheet A will be correctly linked to their origin; cells that were empty in sheet A contain nothing in sheet B (while I'd expect them to contain a link to the corresponding cell in sheet A). This is annoying because you want ALL changes in sheet A (including filling empty cells) to be reflected in sheet B. 6. Delete the content of a non-empty cell in sheet A, that was correctly linked in sheet B. Now the corresponding cell in sheet B still contains the link to the original cell in sheet A, but it contains a value of 0. This is quite worrisome because empty is not the same as 0; i.e., after the change the cell will be empty in sheet A and contain '0' in sheet B. Actual Results: see steps to reproduce Expected Results: see steps to reproduce Reproducible: Always User Profile Reset: No Additional Info: The bug was first noticed in 2010 in the OO forum (very clear explanation), with a message in 2018 confirming it in Libreoffice as well. https://bz.apache.org/ooo/show_bug.cgi?id=109556
First doing a reference in an empty file A1 is empty A2=A1 shows '0' It is how spreadsheets works. Paste as links only creates a reference to the original cell. But in help https://help.libreoffice.org/24.2/en-US/text/shared/01/02070000.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/pastespecial/dialog-action_area1#bm_id31541011 " Link Inserts the cell range as a link, so that changes made to the cells in the source file are updated in the target file. To ensure that changes made to empty cells in the source file are updated in the target file, ensure that the "Paste All" option is also selected. You can also link sheets within the same spreadsheet. When you link to other files, a DDE link is automatically created. A DDE link is inserted as a matrix formula and can only be modified as a whole. " With 'Paste all' marked doesn't link the empty cells either, and no version of LibreOffice neither Aoo works so. Or an error in help or a bug.
Dear gabriele, 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