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)
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.
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.
Don’t use a simple paste operation. Use Paste Special and select Only Formulas.
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.
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.
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.