Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 18 Nov 2019 18:27:51 +0100Copy paste formula pasting previous result, any idea?https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (`=D8*1000/E8`) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (`=D9*1000/E9`) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)Fri, 15 Nov 2019 13:31:21 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/Comment by robleyd for <p>Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (<code>=D8*1000/E8</code>) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (<code>=D9*1000/E9</code>) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217353#post-id-217353The asterisk is used for markup to create italics so you need to show your formulae as preformatted text; use the `101010` icon.
Please ***don't*** use an answer for something that clearly isn't an answer - add a comment to your question or edit the question as appropriate.Fri, 15 Nov 2019 13:40:34 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217353#post-id-217353Comment by Opaque for <p>Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (<code>=D8*1000/E8</code>) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (<code>=D9*1000/E9</code>) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217356#post-id-217356> Any ideas?
yes - skip LibreOffice version 6.3.0.4 and update. From my perspective a buggy release not worth to further investigate any problems, which may be fixed in more recent releases.Fri, 15 Nov 2019 13:49:52 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217356#post-id-217356Answer by minissimo for <p>Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (<code>=D8*1000/E8</code>) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (<code>=D9*1000/E9</code>) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217792#post-id-217792Hi and thank you for the answers.
For ve3oat, good to remind it, and actually I do so, using Ctrl+Shift+V in order to select an unformatted output / and or a specific item to paste.
To Opaque, I did upgrade to the latest version but I am not sur the older version was the reason. No definitive opinion, but I rather lean towards some corrupt/strangely formated data I have been pasting formerly.
My turnaound before upgrading to the newer LO version has been to open a new spreadsheet, paste data and do my calculations in it, and then copy paste the data in the older spreadsheet, and it worked.Mon, 18 Nov 2019 17:11:06 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217792#post-id-217792Comment by Opaque for <p>Hi and thank you for the answers.
For ve3oat, good to remind it, and actually I do so, using Ctrl+Shift+V in order to select an unformatted output / and or a specific item to paste.
To Opaque, I did upgrade to the latest version but I am not sur the older version was the reason. No definitive opinion, but I rather lean towards some corrupt/strangely formated data I have been pasting formerly.
My turnaound before upgrading to the newer LO version has been to open a new spreadsheet, paste data and do my calculations in it, and then copy paste the data in the older spreadsheet, and it worked.</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217794#post-id-217794Please do not post answers on this site, if you actually don't answer a question (you own in this case). Use *add a comment* instead in such cases. Thanks in advance.Mon, 18 Nov 2019 17:18:09 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217794#post-id-217794Answer by minissimo for <p>Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (<code>=D8*1000/E8</code>) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (<code>=D9*1000/E9</code>) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217348#post-id-217348Between D8 and 1000 (or D9 and 1000) there is obviously a multiply sign, but it is not showing in my published question.Fri, 15 Nov 2019 13:33:50 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217348#post-id-217348Answer by ve3oat for <p>Hi,
After importing an unformated file, I want to get the product of two columns with a basic formula (<code>=D8*1000/E8</code>) and Calc provides a correct result (say 31).
But when trying to copy/paste the same formula in the following rows, Calc shows the result of the first row (31) though the formula has been adapted to the new row (<code>=D9*1000/E9</code>) and the result should be diverse: If I write (as opposed to copy/paste) the formula in the following row instead, the correct result (say 9) is showing.
The spreadsheet contains 6 sheets, Calc was doing fine in the first five sheets (with the same formula) but not in the last one.
Any ideas?
OS=Windows 10
Libre Office Version : 6.3.0.4 (x64)</p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217423#post-id-217423Don't use a simple paste operation. Use Paste Special and select Only Formulas. Fri, 15 Nov 2019 20:11:54 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?answer=217423#post-id-217423Comment by erAck for <p>Don't use a simple paste operation. Use Paste Special and select Only Formulas. </p>
https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217805#post-id-217805If that really helped it would be bug though, copy&paste of entire cells including a formula with adapting relative references and giving correct result after should work and not need any Paste Special.Mon, 18 Nov 2019 18:27:51 +0100https://ask.libreoffice.org/en/question/217346/copy-paste-formula-pasting-previous-result-any-idea/?comment=217805#post-id-217805