[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 Fran changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 Óvári changed: What|Removed |Added OS|Linux (All) |All --- Comment #6 from Óvári --- (In reply to Fran from comment #5) > I experience the same problem described in this bug in macOS. Thank you, have changed Hardware to ALL. Can you please update the status from UNCONFIRMED to NEW? Thank you once again. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 --- Comment #5 from Fran --- (In reply to Óvári from comment #3) > Thank you for your feedback as do not have Windows to see what the behavior > is there. > > The behavior seen on Linux Mint is: > For LO7.5, if I copy the cell, the formula is pasted. > For LO7.6, if I copy the cell, the value is pasted. > > Maybe this is a GNU/Linux only bug? > > Thank you I experience the same problem described in this bug in macOS. In previous versions, when I pasted a formula it was updated with references to cells in the row where the formula was pasted, not the original raw formula. i.e. in row 1, cell B the formula '=*0.8' was converted to '=*0.8' when the cell was pasted in row 2, cell B. This is actually the behavior expected if you were using Calc instead of a Table in Writer. Since I upgraded to 7.6.0.3, the current behavior is to paste the formula 'as is', so I get '=*0.8' when the cell is pasted elsewhere. This breaks my expectation to work with tables with formulas as described in the previous example. Reproducing the steps mentioned in the Description with the attached document, what I observe is not a "Paste value" result, but a "Paste literal formula", which results in the cell containing the '2', as it was the original value given by the copied formula. It seems the formula is being pasted, but the *raw* formula referreing to the original cells. I hope this helps to understand what is going on here. Thank you -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 --- Comment #4 from Ezinne --- Not reproducible on: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e7496f41562b75ea9732ca48f9aa0c07b69e424f CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 --- Comment #3 from Óvári --- Thank you for your feedback as do not have Windows to see what the behavior is there. The behavior seen on Linux Mint is: For LO7.5, if I copy the cell, the formula is pasted. For LO7.6, if I copy the cell, the value is pasted. Maybe this is a GNU/Linux only bug? Thank you -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- If I copy only the value by select it, the value is pasted, if I copy the cell, the formula is pasted. That looks the right behavior for me. Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156905] [Regression] Copy and paste formula, now paste value
https://bugs.documentfoundation.org/show_bug.cgi?id=156905 --- Comment #1 from Óvári --- Created attachment 189140 --> https://bugs.documentfoundation.org/attachment.cgi?id=189140&action=edit Table with formulae in first and last columns not working -- You are receiving this mail because: You are the assignee for the bug.