Description: I have a colomn with a sum cell. If I copy that one and paste to another spreadsheet, Libreoffice paste the formula and not the result. Steps to Reproduce: Spreadsheet A cell A1 = 1 cell A2 = 2 cell A3 = 3 cell A4 = sum(A1:A3) --> Result = 6 Copy cell A4 Open Spreasheet B cell A1 right clic - "special paste" - "special paste" - link ok Actual Results: In cell A1 there will be !RIF Expected Results: In cell A1 I should see 6 Reproducible: Always User Profile Reset: No Additional Info: This does not happened if you paste link to the same document Versione: 6.0.3.2 Build ID: 1:6.0.3~rc2-0ubuntu0.16.04.1~lo2 Thread CPU: 4; SO: Linux 4.4; Resa interfaccia: predefinito; VCL: kde4; Versione locale: it-IT (it_IT.UTF-8); Calc: group User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/65.0.3325.181 Chrome/65.0.3325.181 Safari/537.36
The problem there is only if the source document is new
I can reproduce/confirm this on LibreOffice 6.1.0.0 alpha1 on Windows 10 x64. Versió: 6.1.0.0.alpha1 (x64) ID de la construcció: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab Fils de CPU: 4; SO: Windows 10.0; Renderitzador de la IU: GL; Configuració local: ca-ES-valencia (ca_ES); Calc: group I attach a screenshot of this problem.
Created attachment 141865 [details] Failure to past a link made by steps done at the bug description
I can't reproduce it in Version: 6.1.0.0.alpha1+ Build ID: 213f12be2cab2106dde4a0e859faaa8259627c1a CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group
Well, I've just given it another thought and this is the expected behaviour... The formula you're copying is summing the values of the 3 cells above it ( A1, A2 and A3 ), if you paste it to A1, it gives a REF error because A-2, A-1 and A0 don't exist. Instead, if you paste the formula to A3 or another cell, it will work correctly. Closing as RESOLVED NOTABUG
Excuse me Xisco. The problem there isn't if you do paste, but if you do "special paste" and select "link paste". I don't know if these function words are correct because I am using italian version. I think that this bug should be open again. I didn't try it with bet version 6.1. Thank you
(In reply to Sergio bh from comment #6) > Excuse me Xisco. > The problem there isn't if you do paste, but if you do "special paste" and > select "link paste". > I don't know if these function words are correct because I am using italian > version. > I think that this bug should be open again. > I didn't try it with bet version 6.1. > Thank you Hello Sergio, Yes, I used special paste. So, if you paste the formula in A1, what do you expect it to show?
I am sorry, but my english is very poor. I expect to see the result of A4 of first sheet (6). That you said is if I do "paste" on second sheet and not if I make "paste special/paste special" and then click on "link" under option section. Thank you
If the reporter means in two different spreadsheets then i can reproduce. If the link is in the same spreadsheet between two sheets then there is no problem. Version: 6.1.0.0.alpha1+ Build ID: ab17afd9beeb2a2cef3e7b67a6acd2581d78b823 CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
(In reply to Sergio bh from comment #8) > I am sorry, but my english is very poor. > I expect to see the result of A4 of first sheet (6). > That you said is if I do "paste" on second sheet and not if I make "paste > special/paste special" and then click on "link" under option section. > Thank you Is the Formula checkbox enabled in the Paste Special dialog?
(In reply to Xavier Van Wijmeersch from comment #9) > If the reporter means in two different spreadsheets then i can reproduce. > If the link is in the same spreadsheet between two sheets then there is no > problem. > > Version: 6.1.0.0.alpha1+ > Build ID: ab17afd9beeb2a2cef3e7b67a6acd2581d78b823 > CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; > Locale: nl-BE (en_US.UTF-8); Calc: group Yes. I try to explain in my first post with my poor english.
(In reply to Sergio bh from comment #11) > (In reply to Xavier Van Wijmeersch from comment #9) > > If the reporter means in two different spreadsheets then i can reproduce. > > If the link is in the same spreadsheet between two sheets then there is no > > problem. > > > > Version: 6.1.0.0.alpha1+ > > Build ID: ab17afd9beeb2a2cef3e7b67a6acd2581d78b823 > > CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; > > Locale: nl-BE (en_US.UTF-8); Calc: group > > Yes. > I try to explain in my first post with my poor english. When you choose "link", all other option are unavailable.
I retested it and its not a bug. In comment9 i say i can reproduce it, but i forgot to save the file at that moment. So the link could not be mate. Its a normal behavior that when choosing the link option in past special the rest is gray out. Can be closed as notabug If you are not agree you can reopen it as unconfirmed Version: 6.0.5.0.0+ Build ID: 2019109e20dc522dd3bd6a730bf639efc2c00309 CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.1.0.0.alpha1+ Build ID: 95620da00dc53a061c3b093510e46a7c0b3163c6 CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
I can be agree you that this is not a bug. I aspected me a different result like other office suite. Thank you for your time. Sergio