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 2017/12/06 12:53:04 UTC
[Issue 127624] New: Partially Cut&Pasting a line from a file to
another corrupt an unrelated line
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Issue ID: 127624
Issue Type: DEFECT
Summary: Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Product: Calc
Version: 4.1.4
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: fphenix@hotmail.com
Target Milestone: ---
Hello,
I can systematically reproduce the following issue when cut&pasting info from
one Calc ods file to another.
The files have lines composed of a few text fields then some formulae fields.
For instance the S38 has "=IF($D38<>"";$E$1;0)"; with a fixed value of 14 in
E1.
If D38 is empty then S38 displays 0, if a name is entered in D38, S38 displays
14.
However, If I copy the fields B38 to M38 from one file to the other, but paste
these in - say - B55 to M55, then in the receiving file the S55 field is
updated BUT the S38 fields also has its formulae modified and pointing on D55,
hence displaying incorrect info.
Note: the first file was converted from xls to ods a while ago.
Let me know if you need the files (I won't be able to give them as is, but can
try to change de data so it can be send out.
i tried in both 4.1.3 and 4.1.4 with same issue in both.
Thanks,
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|4.1.6 |4.1.7
Confirmation in| |
Severity|Major |Normal
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |damjan@apache.org
Latest|4.1.11 |4.1.13
Confirmation in| |
--- Comment #10 from damjan@apache.org ---
This still happens on Windows with 4.1.13, but the latest Git works perfectly
on FreeBSD: after cut of C19:Q19 from 2017 and paste to C15 in 2018, the S19
formula in 2018 still refers to D19.
Why?
1. A Windows-specific bug?
2. Some bug in the 4.1.x branch that we fixed in trunk but didn't backport?
Can someone please test with 4.2.x or trunk on Windows, so we can distinguish
between those possibilities?
Silent data loss bugs are the worst, and our users deserve better.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #14 from Matthias Seidel <ms...@apache.org> ---
I can provide a test build in the next days...
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #16 from damjan@apache.org ---
I can confirm that the bug is absent from both the latest Git on Windows and
Matthias's 4.1.14 build, and can be reproduced by reverting
faa11fa3567bc0a69178888650acd0c4c28386a8.
Therefore resolving this bug as a duplicate of bug 118023.
fphenix: thank you for your bug report and sample documents :-). If you like,
until the fix appears in a new release, you can use Matthias's unofficial
4.1.14 build, or one of our nightly builds (once we get them working again).
*** This issue has been marked as a duplicate of issue 118023 ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #2 from fphenix@hotmail.com ---
Created attachment 86292
--> https://bz.apache.org/ooo/attachment.cgi?id=86292&action=edit
second file to reproduce the issue ; paste in
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #15 from Matthias Seidel <ms...@apache.org> ---
Here it is:
https://www.dropbox.com/s/kgjrxa1tghjuww4/Apache_OpenOffice_4.1.14_Win_x86_install_en-US_774ffdbe38.exe?dl=0
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #17 from Matthias Seidel <ms...@apache.org> ---
Great!
BTW: I do unofficial test builds for Windows on a regular base:
https://home.apache.org/~mseidel/AOO-builds/
For those who want to test. The next build will include this fix.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
fphenix@hotmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|4.1.4 |4.1.11
--- Comment #9 from fphenix@hotmail.com ---
This cell/formulae corrupting issue is still there in version 4.1.11 (tried
with updated software today (10th of dec. 2021) :
Version 4.1.11 : AOO4111m1(Build:9808) - Rev. bdb20b2a64 2021-09-20 16:18
See my "Comment 3" with the procedure to reproduce using the 2 uploaded files.
Cheers.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #3 from fphenix@hotmail.com ---
Addendum
I simplified my files and can attach them.
Procedure to reproduce the issue:
Open OOCalc_bug_127624_2018.ods
Look at S19, the formulae refers to D19, that's fine.
Open OOCalc_bug_127624_2017.ods
Select C19 to Q19 from **_2017
Copy and Cut the selection (I use CTRL-X)
Paste it in/from C15 in **_2018 (I use CTRL-V)
Look at S19 in **_2018, the formulae now refers incorrectly to D15.
(S15 still and also refers to D15 which is fine.)
(likewise with the U column by the way)
Note: I haven't tried fully with a simple Copy (rather than Cut). The issue
could be while Cutting then Pasting.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Matthias Seidel <ms...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|4.1.7 |4.1.11
Confirmation in| |
CC| |mseidel@apache.org
Version|4.1.11 |4.1.4
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|Normal |Major
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact| |knmc@apache.org
Severity|Normal |Major
Priority|P3 |P2
--- Comment #8 from Keith N. McKenna <kn...@apache.org> ---
Even though there is a work around i am raising the priority as this does cause
data loss or corruption.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |4.1.6
Confirmation in| |
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #5 from fphenix@hotmail.com ---
Hi There,
I've tried it in 4.1.6 and still have the issue.
This issue has been put to Normal/lowest priority last year which I don't quite
agree as it does corrupt data if you are unaware of the issue or its
workaround.
I do rely on a "Cut&Paste" (instead of "copy&paste + delete") as part of my
workflow, so this year I fell in the trap again, and thankfully remembered my
issue from last year.
Last year it took me a couple of months before I noticed my final result wasn't
correct. Some user may not be careful enough to double check the result.
Any chance to have a look at this data corrupting bug? Thanks.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #13 from damjan@apache.org ---
It would be best if someone tested first.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Severity|Major |Normal
Status|UNCONFIRMED |CONFIRMED
CC| |knmc@apache.org
--- Comment #4 from Keith N. McKenna <kn...@apache.org> ---
Following the the op's supplied steps I can confirm that cutting from one file
and pasting to the other does indeed change the formula at S19 as he states. I
used both ctrlx and edit/cut also paste/special. How ever if I use either ctlc
or edit/copy to extract the information and then paste it into the second file
the formula in S19 remains unchanged.
Tests were carried out on both Windows 10 and Windows 7 with the same results.
System and AOO configurations as follow:
For Desk Top Configuration
Intel (R) Pentium(R) CPU 4405U @2.10GHz, 2112MHz, 2(Core(s) 4 Logical
Processors
Total Physical Memory 8.00 GB
Operating System: Windows 10 Home Version 10.0.16299 Build 16299
Apache Open Office:
AOO414m5(Build:9788) - Rev. 1811857
2017-10-11 20:12
Language: en_US
Additional Language Packs: None
For Tablet Configuration
System Configuration:
Processor: Intel Core i5 CPU M560 @2.67GHz
Installed Memory: 2.00 GB (1.6 usable)
Operating System: Windows 7 Home Premium SP1 64 bit
Apache Open Office:
AOO414m5(Build:9788) - Rev. 1811857
2017-10-11 20:12
Language: en_US
Additional Language Packs: None
As there is an apparent work-around, copy rather than cut, I have lowered the
severity to Normal
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #7 from fphenix@hotmail.com ---
Issue tested in 4.1.7 (see protocol above to reproduce the defect) : still
present in 4.1.7.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #12 from Matthias Seidel <ms...@apache.org> ---
Cherry-picked now for AOO41X.
Can we close this one as duplicate?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P5 (lowest) |P3
Keywords| |data_loss
--- Comment #6 from Keith N. McKenna <kn...@apache.org> ---
As there is a data loss/corruption associated with this issue I am raising the
severity level and adding the data_loss keyword
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another
corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #1 from fphenix@hotmail.com ---
Created attachment 86291
--> https://bz.apache.org/ooo/attachment.cgi?id=86291&action=edit
first file to cut from to reproduce the issue
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
Keith N. McKenna <kn...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127624] Partially Cut&Pasting a line from a file to another corrupt an unrelated line
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127624
--- Comment #11 from damjan@apache.org ---
I think it was case (2), and it was probably this commit that fixed it. This is
a duplicate of bug 118023 then, and we should release this fix to users ASAP!!
commit faa11fa3567bc0a69178888650acd0c4c28386a8
Author: Damjan Jovanovic
Date: Wed Feb 17 00:03:50 2016 +0000
#i118023# Calc: Cut-and-paste between spreadsheets causes incorrect cell
reference changes
When pasting cut cells, Calc updates references to their old positions
to instead refer to their new positions. This is done using the tab index,
row and column, however the document is not taken into account. As a result,
when cutting and pasting between documents, cells in the target document
end up getting changed instead of in the source, potentially leading to
formula corruption, which is undoable but could easily go unnoticed,
causing data loss when the document is saved.
We don't really support inter-document reference updates anyway, so fix
this bug by restricting reference updates to the intra-document cut and
paste case only.
Patch by: me
Reviewed by: kschenk
--
You are receiving this mail because:
You are the assignee for the issue.