https://bugs.documentfoundation.org/show_bug.cgi?id=91211
Bug ID: 91211
Summary: EDITING: Copy of a spreadsheet containing references
to cells in an other sheet doesn't work properly
Product: LibreOffice
Version: 4.3.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Involved spreadsheets:
-data, contains measured data
-data1, contains references to data
-data2, copy of data1
data2 is produced by function "move/copy table"
Each cell of data2 which contains a reference has the correct cell address of
data, but the sheet address "data1" which results in a confusion of data.
example:
data data1 data2
1 2 3 =data.B1 =data.A1 =data1.B1 =data1.A1
which results into
1 2 3 2 1 1 2
This behaviour is identical on Linux and Windows7.
MS Excel produce the correct result
The goal of this complex operation is to select and reorder data to a set of
plots
--
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
