Description: When copying and pasting cells which contain formulas between two sheets of the same document, the values are inserted literally, instead of pasting the formulas with references to the original sheet, as expected. By default, references should be used instead of literal values. Steps to Reproduce: 1. Create some calculations using formulas and cell references within sheet #1 2. Create sheet #2 in the same document and copy the cells from sheet #1 3. Double click the pasted cells and observe the values are literal numbers -- the formulas are gone Actual Results: Formulas are lost and literal values are inserted Expected Results: Formulas are inserted, with automatically updated cell references pointing to sheet #1 in the same document. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Hi thank you for reporting but when you want to past formula to another sheet, you will need the past special option and you click formula and this will copy your formula to sheet #2 and update automatic the values in that sheet
Spoke to soon sorry my bad Reopened because past/paste special give #ref error in Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.4.5.0.0+ Build ID: a61f45499856aad9910d82af1312a163504c15c2 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.0.0.1.0+ Build ID: e16ef4a7d2f56a22dc05f8d05cf27d828d9d231b CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group and Version: 6.1.0.0.alpha0+ Build ID: 26be5f21cebfe9acad088a1086f97eebdb437b7c CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Created attachment 138638 [details] Sample file for test purposes Attached a sample file with one sheet with formulas. Creating a second sheet and copying formulas from sheet1 to sheet2, works fine for me.
Version: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
(In reply to m.a.riosv from comment #3) > Created attachment 138638 [details] > Sample file for test purposes > > Attached a sample file with one sheet with formulas. > Creating a second sheet and copying formulas from sheet1 to sheet2, works > fine for me. Yep, paste special - formulas works for me. Sam: please comment. Arch Linux 64-bit Version: 6.1.0.0.alpha0+ Build ID: c6a23023150c164a19236139fa413d43006ce21c CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on February 11th 2018
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20180903
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20181009