uses for OFFSET() (was Re: [libreoffice-users] selecting cells in calc sheet)

I find OFFSET() quite useful whenever I build a table with a running 
balance (for instance where the balance in X10 = X9+W10).  Without the 
OFFSET() function, if I needed to insert a row between rows 9 & 10, the 
new row would not be included in the running balance unless I edited the 
formula.  But if the original X10's formula is "=OFFSET(X10,-1,0)+W10" 
then the new row is automatically included in the running balance.

-- Tim
===========================


On 4/26/2015 9:15 AM, jelly@lang.hm wrote:

> Correction. I ran across an old message from Mr Barker that suggested using the OFFSET() function 
> for something.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted