Issue 107203

Summary: autoincrement in strings doesn't work with Fill Series dialog
Product: Calc Reporter: dtardon <dtardon>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, kvpkmohan
Version: DEV300m65   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: PATCH Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
extension of autoincrement for strings none

Description dtardon 2009-11-25 12:34:02 UTC 
i.e. when one wants to create a series like

a1
a2
a3
...

, the only way to do it is to write the first two values, select the cells and
drag them down or to go to Edit->Fill->Series... and select the (default)
AutoFill series type there. To create a series entirely by using the dialog is
only possible for numeric series.

The attached patch extends the dialog and the autoincrement logic to handle
strings too, in (hopefully) the same way as it handles numbers. So it's
possible, for example, to create a series

a1
a2
...
a7
a8

by Edit->Fill->Series..., selecting type Linear and setting Start value to a1,
End value to a8 and increment to 1.
Comment 1 dtardon 2009-11-25 12:35:05 UTC 
Created attachment 66340 [details]
extension of autoincrement for strings
Comment 2 kvpkmohan 2012-05-01 11:04:45 UTC 
as dtardon mentioned,
auto increment should be applicable not just to numbers , but strings as well.

One change, here,

enter a1, a2, into cells,
drag it down..
Edit->Fill->Series..., selecting type Linear and setting Start value to a1,
End value to "*" and increment to 1.

Here  * is specified as end value, it generates numbers till the last row user drags.
Comment 3 Rob Weir 2013-03-11 15:03:42 UTC 
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:  dev@openoffice.apache.org

Thanks!

-Rob
Comment 4 Edwin Sharp 2014-01-13 11:53:57 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1552994
Rev.1552994
Win 7