Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.