Bug 126577

Description:
I understand this is not exactly a bug, but this is something that is wrong, mistakenly programmed or not taken on account.

When using the "Fill Cells" option to complete a certain series of numbers you are obliged to select the exact amount of cells you want to be filled in. I'm using the following option: 

Sheet -> Fill Cells -> Series, Direction "down" and type "linear". I choose the initial value of 0, the final value of 3.1416, increment of 0.0001.
 
What this does is to fill only the cells I have selected before going to the Sheet menu. 

For example:
-. If I have selected only one cell, the menu Sheet -> Fill Cells -> Series is disabled. 
-. If I choose for example three cells, and do the above procedure, only those three cells are completed. 
-. If I select the entire column, the serie is completed untill the final value, but the subsequent cells are filled with "#NUM!". 

I understand the first two cases, they make sense in some way, but the last one is absolutely useless. You can't even go to the last value. Why would someone want to fill more than a million cells with "#NUM!"? 

If you only have a few values, or even some hundreds, you can do it by hand, just writting the first two values and then grabbing the black square on the corner of the cell. But if you have thousands of values to be filled in, it takes a lot of time. If you have to manually select all of them to this tool to work, then, this is useless.





Steps to Reproduce:
1. Select an entire column or more cells than the ones that want to be filled (for example, select 15 cells in a column).
2. Go to Sheet -> Fill Cells -> Series.
3. Select the options "Down" and "Linear".
4. Complete the initial, final and increment values. For example 1, 10 and 1, respectively.
5. Then click the accept button.


Actual Results:
If the above steps have been followed, the result will be: 
-. Ten cells filled with the values from 1 to 10.
-. Five cells have the value "#NUM!".

If more cells were selected, then more of them will have the value "#NUM!". If less cells than the final value were selected, then only those selected will have been filled (not having reached the expected final value).

Expected Results:
Only ten cells filled with the values from 1 to 10.
The rest of the cells have to be left empty.


Reproducible: Always


User Profile Reset: No



Additional Info: