[Libreoffice-bugs] [Bug 126577] New: Fill Cells Series #NUM!

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126577

            Bug ID: 126577
           Summary: Fill Cells Series #NUM!
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sebastianfcn at gmail.com

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190728/0bd0fcd3/attachment.html>