[Libreoffice-bugs] [Bug 127113] New: Allow to fill any two numeric fields in Sill Series dialog

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127113
           Summary: Allow to fill any two numeric fields in Sill Series
                    dialog
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: difficultyBeginner, easyHack, skillCpp
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Sheet▸Fill Cells▸Fill Series (at least in linear mode) allows to specify Start
value and Increment (leaving End value empty), and have the thing do its job.
However, if any other combination of filling only two fields is used, it fails:

* if only End value and Increment are filled, it just does nothing for
previously empty selection (the selected cells stay empty);
* if only Start value and End value are filled, it gives an error "Invalid
value" and select the Increment field.

The proposal is to allow filling any two boxes there, since it's possible to
derive the third value from the filled two. E.g., if 5 empty cells in a column
are selected, and in the dialog, Start value is set to 5, and End value to 12,
the result would be 5, 6.75, 8.5, 10.25, 12.

See
https://ask.libreoffice.org/en/question/205810/how-to-fill-cells-with-numbers-in-between-the-numbers/

A code pointer is sc/source/ui/miscdlgs/filldlg.cxx, OKHdl handler of
ScFillSeriesDlg.

One needs to make sure that the dialog remains useful in cases where selection
already contained numbers (and so that data would be used for Start value if
omitted).

-- 
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/20190823/6407d78e/attachment.html>