I have one spreadsheet file, which was fine until recently. Now I cannot copy the formula down to the next row. All I get is …
#VALUE!
#VALUE!
The formula is correct. I have checked it many times. I have other account files and they all work normally.
As the file had reached 4999 rows, I thought maybe that was the limit. I reduced the spreadsheet to a few hundred rows, but still get the same error.
I have just uninstalled LibraOffice and re-installed. Still the same problem.
No way to answer this “I have everything correct, but it doesn’t want to work!!!111” without even formula itself (which is “correct, I have checked”) - I don’t even say about additional data like values of cells the formula refers to - and of course, it would be a daydreaming to speak about the file itself, which would make life of people trying to help too easy.
If you want help, please edit your question and attach the offending file.
If it contains personal or confidential data you can remove it using the guidelines given here.