[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