Apache OpenOffice (AOO) Bugzilla – Issue 107203
autoincrement in strings doesn't work with Fill Series dialog
Last modified: 2014-01-13 11:53:57 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.
Created attachment 66340 [details] extension of autoincrement for strings
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.
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
Confirmed with AOO410m1(Build:9750) - Rev. 1552994 Rev.1552994 Win 7