[libreoffice-users] Calc cell reference unexpected behavior.

2011-08-24 Thread Steve Edmonds
Hi. Noticed an unexpected behavior in calc in regards cell references changing when data is cut and pasted. Not what I expected but others may consider it normal. Goes from LO3.4.1 back to OOO3.2.1 In a new sheet, column A, from A1 enter p,f,p,f,p,f. In column B1 enter formula

Re: [libreoffice-users] Calc cell reference unexpected behavior.

2011-08-24 Thread planas
Steve. Good question, this behavior will catch the unwary because they are using relative reference when they want to use absolute referencing. Often users forget they can use to absolute referencing to control the location the formula uses. On Thu, 2011-08-25 at 09:55 +1200, Steve Edmonds wrote: