[Libreoffice-bugs] [Bug 33708] New: Calc autofill should fill to selection in certain circumstances

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=33708

           Summary: Calc autofill should fill to selection in certain
                    circumstances
           Product: LibreOffice
           Version: LibO 3.3.0 release
          Platform: x86-64 (AMD64)
        OS/Version: Windows (All)
            Status: NEW
          Severity: trivial
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: dturover at student.santarosa.edu


LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4

Expected behaviour:

 1. Type a number into a cell.
 2. Select the cell and the cell to its right.
 3. Double-click the little autofill box at the bottom-right of the selection.
 4. Autofill should fill to the right.

Observed behaviour:

 4. Autofill fills downward, ignoring the selection.

Reproduction requires a text in the cells to the left of the first selected
cell and the next cell in that column.

OR observed behaviour:

 4. Autofill does nothing.

Reproducable if no text to the left. This is especially annoying when it fails
to autofill cells like [1,2,3,,,,,,]


Thoughts: 

When autofill is run on a selected row, it currently seems to assume that the
user intends to fill the selected row downwards.

I propose instead that the autofill fill to the right within the selection in
the case of certain selections where it can be inferred that the user intends
to fill to the right; the problem is in defining the cases where this can be
inferred. Ideas:

* A selection where the rightmost column is empty.
* A selection where autofill would otherwise do nothing.
* A selection in which Calc would have autofilled to the right had the user
started with a selection of the non-blank left column(s) and dragged the
autofill handle to the right to create the selection, instead of selecting the
larger area first and then double-clicking autofill.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.