[Libreoffice-bugs] [Bug 48856] New: EDITING: NAME cell references with local scope losing reference after insertion of rows

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Apr 18 07:55:19 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=48856

             Bug #: 48856
           Summary: EDITING: NAME cell references with local scope losing
                    reference after insertion of rows
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 Release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: web17 at go4more.de


Problem description: 

Steps to reproduce:
1. Start with empty spreadsheet file, one sheet ('Sheet1')
2. Enter any value in any cell e.g. value '110' into $B$4
3. Insert-Names-Define
4. Define Name 'field01' for range '$B$4', scope 'sheet1'
5. Enter formula '=field01' into cell C4
6. Enter formula '=$B$4' into cell D4
7. Cells C4 and D4 display value of cell B4
8. Insert new row above row 4
9. Moved cell C5 displays '0' (lost reference to 'field01') = bug
10.Moved cell D5 displays value of cell B5 = correct
11.Delete row above row 4
12.All values are displayed correctly

Current behavior:
NAME references without absolute sheet address are not handled correctly inside
the sheet. If the 'range' (see step 4) is defined 'sheet1.$B$4' instead of
'$B$4', then the NAME reference is correctly moved by inserting rows or lines
into the sheet. But then the NAME reference (scope) is no longer limited to
sheet1 only, but is a GLOBAL scope, which makes duplicating of sheets
impossible.

Expected behavior:
Local scoped NAME references must be handled similar to non-named cell
references.

Platform: Win7

Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101
Firefox/11.0

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list