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.mohrh...@googlemail.com> wrote: > Hey Nicklas, > > 2012/11/22 Nicklas Widlund Bjurman <lordmetr...@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 _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
