Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The behavior you describe does not match my results. I tried several versions (LO 4.4, LO 5.4, AOO 4.1.3) and operating systems (Win10, Ubuntu, Mint). Here are the details:

  1. Source sheet cell B1 contains =A1*2. Paste to sheet 'Oct 17' cell B1 shows =A1*2.
  2. Paste Special (Ctrl+Shift+V) with Link checked shows =$'Sep 17'.$B$1.
  3. Source sheet cell B1 contains ='Sep 17'.A1*2. Paste to sheet 'Oct 17' cell B1 shows ='Oct 17'.A1*2.
  4. Source sheet cell B1 contains =$'Sep 17'.A1*2. Paste to sheet 'Sep 18' cell B1 shows =$'Sep 17'.A1*2.

I looked for a setting that may change this behavior to what you describe but could not find any. Are you sure that what you described is exactly correct? If so, maybe you are using an older version and need to upgrade.