Re: Wish to contribute but do not know my way around

I noticed the increase/decrease behavior in Microsoft Excel 2007. To
replicate the feature:

* Write the function SUM(A1:A30) in A31
* Select both A30 and A31.
* Move the selection down or up.
* As moved A30 will increase/decrease with the number of rows moved.

Best regards
Nicklas W Bjurman

On Thu, Nov 22, 2012 at 9:24 AM, Markus Mohrhard
<markus.mohrhard@googlemail.com> wrote:
> Hey Nicklas,
>
> 2012/11/22 Nicklas Widlund Bjurman <lordmetroid@gmail.com>:
> > I wish to enhance the spreadsheet copying/moving formula intelligence
> > so that when a function for example SUM(A$1:A30) is moved it will
> > increase/decrease A30 with the number of rows moved.
>
> I'm not sure if that is such a good idea. I checked both with Excel
> and Gnumeric and they both behave the same way as Calc. Since this
> seems to be the default behavior in all major spreadsheet programs I
> think we should stick with it.
>
> > I would really appreciate if there were someone who could point me in
> > the right source file direction.
>
> However the code for updating cell references is at
> http://opengrok.libreoffice.org/xref/core/sc/source/core/data/cell2.cxx#833
> with the URM_MOVE case.
>
> Regards,
> Markus