[Libreoffice] [REVIEW] fix for fdo#39850 and fdo#39820: update range names and database ranges in formula cells

[Eike Rathke]

Hi Markus,

With your latest commit 74070a021389534b9e791980bd33ede45be9fd81 copying
to another sheet within the same document to me doesn't work as
expected:

On Sheet1 on cell B3 define a sheet local range name AAA for that cell
($Sheet1.$B$3). In cell B3 enter value 1, in cell B4 enter formula =AAA
result is 1. Copy cells B3 and B4 to clipboard and paste on Sheet2 at
position C4. Change C4 to 2, C5 remains with result 1. Open the name
dialog and see now a global name AAA pointing to $Sheet1.$B$3
(additionally to AAA local to Sheet1).

I'd expect a name AAA local to Sheet2 pointing to $Sheet2.$C$4 and the
formula in Sheet2.C5 using that name and the result should be 2.

In a dbgutil build the shell displays
Error: FormulaToken::SetIndex: virtual dummy called From File /lo/core/formula/source/core/api/token.cxx at Line 212

Apparently the FormulaToken used is not a FormulaIndexToken.

Behavior is the same when copying to another document.

  Eike

-- 
 PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
 Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20110817/e2b33cc1/attachment-0001.pgp>