Higher selected cells fills with #NUM, how to delete that error and just leave blank cell
Let me use my crystal ball. (Well, it just happens that I came across the problem, and so know it.)
Steps:
- In Calc, select A1:A20.
-
Sheet▸Fill Cells▸Fill Series... -
Start value:1;End value:5;Increment:1 OK
This will produce 1-5 in A1:A5; and A6:A20 will be #NUM!.
Solution
This is fixed in tdf#126577, and the rest of the cells will be empty in version 6.4.
@anon73440385: what would be a real purpose/use case of this “feature”? It’s quite natural for user to e.g. select “large enough” range (even the whole column) and fill it with desired amount of numbers. What would be a reason to demand user to count cells when selecting?
Oh - sorry 
answer may be flagged correct, works ok in 7.0.0.0.a0+
Hello,
if you don’t show the formula producing the overflow, nobody will be able to provide a good solution - From LibreOffice Help - Error Codes:
503 #NUM! | Invalid floating point operation | A calculation results in an overflow of the defined value range.
So the only general advices:
- Adapt your formula to not produce an overflow –or
- Remove the formula from the affected cells
If you intend to get more detailed answer, please enhance your question with details of the formula (or the action taken) to produce the overflow (please use edit for that purpose).