Apache OpenOffice (AOO) Bugzilla – Issue 15600
Automatic Full Column copy by mouse
Last modified: 2013-08-07 15:15:02 UTC
In Excel, when creating a new column based on some math of an immediately adjacent column you can quickly fill the new column with the new data. For example. Column A has 100 rows of some numbers. You want column B to be the contents of A*A. You doing the following : 1. enter you formula in the first row of the column (B1 -> =A1*A1) 2. Highlight the entry 3. double-click the the little black box on the lower right-hand-corner of the selection. and Excel automatically fills the other 99 rows with the formula. Can we have that in Calc too please?
Hi Bettina, one for you. I think it's a cool feature. Frank
Summary: In Excel, when creating a new column based on some math of an immediately adjacent column you can quickly fill the new column with the new data. For example. Column A has 100 rows of some numbers. You want column B to be the contents of A*A. You doing the following : 1. enter you formula in the first row of the column (B1 -> =A1*A1) 2. Highlight the entry 3. double-click the the little black box on the lower right-hand-corner of the selection. and Excel automatically fills the other 99 rows with the formula. Hello Niklas, it is indeed a nice calc feature. Please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
Same as 12313 (and not something for 2.0). *** This issue has been marked as a duplicate of 12313 ***
closing duplicate.