Bug 91211 - EDITING: Copy of a spreadsheet containing references to cells in an other sheet doesn't work properly
Summary: EDITING: Copy of a spreadsheet containing references to cells in an other she...
Status: RESOLVED DUPLICATE of bug 85538
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-10 22:32 UTC by Hans Preineder
Modified: 2017-04-19 09:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hans Preineder 2015-05-10 22:32:40 UTC
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
Comment 1 Hans Preineder 2015-05-10 22:41:49 UTC
active versions:
Linux Suse 13.2:   libreOfice 4.3.6.2
Windows7:          libreOfice 4.4.2.2
Comment 2 m_a_riosv 2015-05-10 23:36:24 UTC
I think this is a duplicate, please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 86652 ***
Comment 3 Hans Preineder 2015-05-11 08:54:50 UTC
It seems to be correct to mark it as a duplicate. Sorry I hadn't found it
Comment 4 Kevin Suo 2017-04-19 09:55:24 UTC

*** This bug has been marked as a duplicate of bug 85538 ***