<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Allow to fill any two numeric fields in Sill Series dialog"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127113">127113</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Allow to fill any two numeric fields in Sill Series dialog
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>difficultyBeginner, easyHack, skillCpp
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mikekaganski@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>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
<a href="https://ask.libreoffice.org/en/question/205810/how-to-fill-cells-with-numbers-in-between-the-numbers/">https://ask.libreoffice.org/en/question/205810/how-to-fill-cells-with-numbers-in-between-the-numbers/</a>
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).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>