https://bugs.freedesktop.org/show_bug.cgi?id=81629
Priority: medium
Bug ID: 81629
Assignee: [email protected]
Summary: Named cell ranges corruption
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Named ranges of cells get easily corrupted.
To replicate:
1) Open LO Calc with a new spreadsheet
2) Using menus, go to Insert->Names->Manage
3) Press 'Add' in Manage Names dialog box
4) In Name field, enter anything you want
5) In Range field, enter 'Sheet1.A$1:A$1048576' (exactly, without quotes)
6) Press 'Add' in Define Name dialog box
7) Press 'Add' in Manage Names dialog box
8) In Name field, enter anything you want
9) In Range field, enter 'Sheet1.B$1:B$1048576' (exactly, without quotes)
10) Press 'Add' in Define Name dialog box
11) Press 'Add' in Manage Names dialog box
12) In Name field, enter 'Problems' (without quotes)
13) In Range field, enter 'Sheet1.C$1:C$1048576' (exactly, without quotes)
14) Press 'Add' in Define Name dialog box
15) Press 'OK' in Manage Names dialog box
16) Select cell B1
17) Ignoring the logic of the function, enter =IF(Problems>0,A2-TODAY(),"x")
18) Using menus, go to Insert->Names->Manage
19) Notice that the ranges you previously defined have been corrupted and are
now pointing to different cells than you specified in steps 2-15
Happens every time.
If functions depend on the range names, all cells depending on those range
names in the all related spreadsheets will be erroneous.
Time spent isolating this bug: 6 hours.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
