You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/01/31 14:36:20 UTC
[Bug 121694] New: Cut & move a cell referred by 1 cell will be
referred by 2 cells after the move
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Bug ID: 121694
Issue Type: DEFECT
Summary: Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: All
OS: Linux64
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: w4vnf3buuf@snkmail.com
CC: issues@openoffice.apache.org
Cell A1 contains 30
Cell C1 contains formula: $a1-h1
Cell d1 contains formula: $a1-i1 (ie. the same as above, but copied 1 cell
right)
Cell H1 contains 10
Current values:
A1=30
H1=10
C1=20
D1=30
Cut (ctrlX) the value from H1, paste the value to i1.
Current values displayed:
A1=30
H1=
I1=10
C1=20 (!!! formula has changed to $a1-i1)
D1=20
There is no logic in that.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact| |akva1270@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Created attachment 81658
--> https://issues.apache.org/ooo/attachment.cgi?id=81658&action=edit
Sample Document
Shows on sheet "Step1" situation before cut/paste, on "Step2" after cut/paste
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Anders Kvibäck <ak...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #1 from Anders Kvibäck <ak...@gmail.com> ---
Yes, it is confirmed.After Ctrl-X cell H has no value, i e C1 should be 30
since C1= a1-h1. But as the bugreporter says the C1 cell changes to a1 - i1.
But it should still be a1-h1.
The bug is reported on Linux64, but I have tested this on Windows Vista,
AOO 3.4.1, HP, with the same result.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Status|CONFIRMED |UNCONFIRMED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Ever confirmed|1 |0
Severity|major |normal
--- Comment #2 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
I see the effect "AOO 4.1.0-Dev – English UI / German locale -
[AOO410m1(Build:9750) - Rev. 1525917 - 2013-09-25]" on German WIN7 Home
Premium (64bit)", own separate user profile and other versions back until OOo
1.1.5, but why is the behavior a bug?
@Jani, Anders Kvibäck
a) Please cite some help or similar sources telling why the observed behavior
is a bug!
b) Please contribute information what different behavior you prefer and
why!
c) Please contribute precise information concerning the versions you used for
tests. I doubt that this one is Linux64 related
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WONTFIX
--- Comment #5 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
(d) Competitors' behavior proceeding original instruction:
(d1) Calligra: Modifies function in C1 as AOO
(d2) SoftMaker FreeOffice: Keeps old function in C1 for cut/paste, but
modifies C2 when I drag/drop H1 -> I1, IMHO inconsequent
(d3) EXCEL See Comment 4, IMHO not a smart way
I believe nearly every behavior for this sample will be rated appropriate by
some others and "without logic" by some others.
So I mark this one WONTFIX for now, but please feel open if you can contribute
some really good, comprehensible arguments not conflicting with other arguments
why current behavior should be changed.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121694] Cut & move a cell referred by 1 cell will be referred
by 2 cells after the move
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121694
Oliver-Rainer Wittmann <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.4.1 |3.4.0
OS|Linux64 |All
--- Comment #4 from Oliver-Rainer Wittmann <or...@apache.org> ---
from comments I conclude
- the described behavior been reported for "Linux64" and confirmed on Windows
Vista and Windows 7
--> Hardware platform = All
- the described behavior has been confirmed since version 1.1.5
--> Version = 'pre 3.4.0' (which is not available, thus '3.4.0'
- the described behavior not clearly seen as a defect
--> Status kept as UNCONFIRMED
my own observation:
- I can confirm Rainer's observation
- Doing the same in Microsoft Excel 2003 resp Microsoft Excel 2013 also changes
the formula in C1. It is changed to '$A1-#REF!'
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.