Ask Your Question
0

Copy paste formula pasting previous result, any idea?

asked 2019-11-15 13:31:21 +0100

minissimo gravatar image

updated 2019-11-15 13:36:58 +0100

robleyd gravatar image

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)

edit retag flag offensive close merge delete

Comments

The 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.

robleyd gravatar imagerobleyd ( 2019-11-15 13:40:34 +0100 )edit

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.

Opaque gravatar imageOpaque ( 2019-11-15 13:49:52 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2019-11-15 20:11:54 +0100

ve3oat gravatar image

Don't use a simple paste operation. Use Paste Special and select Only Formulas.

edit flag offensive delete link more

Comments

1

If 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.

erAck gravatar imageerAck ( 2019-11-18 18:27:51 +0100 )edit
0

answered 2019-11-18 17:11:06 +0100

minissimo gravatar image

updated 2019-11-18 17:14:42 +0100

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.

edit flag offensive delete link more

Comments

Please 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.

Opaque gravatar imageOpaque ( 2019-11-18 17:18:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-15 13:31:21 +0100

Seen: 74 times

Last updated: Nov 18