Bug 74393 - EDITING: Autofill tooltip should be based on numeric cell if one is present
Summary: EDITING: Autofill tooltip should be based on numeric cell if one is present
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2014-02-02 16:52 UTC by dg1727
Modified: 2017-10-28 18:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description dg1727 2014-02-02 16:52:38 UTC
1.  Create a new document in Calc.  
2.  Put the text "abc" (no quotes) into cell A1 and the number 123 into cell B1.  
3.  Drag over the 2 cells so they are both selected.  An autofill handle appears on cell B1.  
4.  Drag the autofill handle down a row.  Don't release it yet.  
5.  Notice that the tooltip says "abc".  Now you can release the mouse button.  
6.  If the autofill is done on just column B instead of both columns A & B, the tooltip says 124, 125, etc. as the mouse is moved to successive rows.  

The desired behaviour is that the tooltip would say 124, 125, etc. (based on the first numeric cell found in the starting range of the autofill) even when both cells A1 & B1 (in this case) form the starting range of the autofill.  

A user can forget the linear-progression default behaviour (i.e., without the Ctrl key) of autofill and try to autofill "abc 123" expecting to get "abc 123" on all successive rows of the autofill.  The current tooltip does not notify the user that the result will actually be "abc 124" etc..  The requested change would have the tooltip notify the user of this, so preventing the unexpected results which would require an Undo.  

LibreOffice on Ubuntu 13.04.
Comment 1 m.a.riosv 2014-02-02 23:13:14 UTC
Hi dg727,

and what if you have the text in B1 and numbers in A1?, or if both are numbers?
Comment 2 dg1727 2014-02-02 23:19:54 UTC

With text in B1 & numbers in A1, the current behaviour is that the tooltip shows an incrementing number (for column A) as the autofill handle is dragged to successive rows (2, 3, etc.).  This is fine because it indicates, while the mouse button is down, what will happen once the mouse button is released.  

With numbers in both cells, currently the tooltip is based on cell A1.  Again, this indicates that autofill will place incrementing numbers rather than just duplicating the contents of the selected cells.  I have no reason to ask for this to be changed at this time.
Comment 3 m.a.riosv 2014-02-03 00:03:49 UTC
Then better change the status from normal to enhancement
Comment 4 dg1727 2014-02-03 00:04:47 UTC