https://bugs.freedesktop.org/show_bug.cgi?id=75372
Priority: medium
Bug ID: 75372
Assignee: [email protected]
Summary: EDITING: Error with defined names after coping sheets
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
1. Create a Spreadsheet. Any singular cells and a couple of contiguous cells
(tables and table column) are defined name using Insert/Names/Define... Where
as Scope the active sheet is choosed (not global).
Many cells of this sheet contain formulas using these cell names
2. Make a copy this sheet using the Move/Copy Sheet dialog and rename the new
one, if you want
3. Change some reference cell values, in order to test, if the formulas
containing cell names calculate correctly.
Current behavior:
1. Some of the name (not global) defined cells are not copied with the correct
reference in the new sheet. The same occurs for the old one.
A look in the dialog box "Organize Names" (Insert/Names/Organize... => Ctrl+F3)
can confirm the names confusion generated.
2. It seems, the formulas give the correct results. But I have not the time to
check all the values.
3. If you will to activate a certain cell, i.e. defined with name "test", and
you use the Name Box, it could happens, a wrong cell will be activate, due to
the behavior described on point 1.
Expected behavior:
1. The not global defined cell names should be exported in the new sheet with
the cell same reference of the old one, but the sheet name reference, that must
be changed in the new one.
Operating System: openSUSE
Version: 4.1.4.2 release
--
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
