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