Issue 69524 - Calc - data loss when drag&dropping file to Calc
Summary: Calc - data loss when drag&dropping file to Calc
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
: 70443 90182 102614 105918 109538 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-09-14 10:48 UTC by kpalagin
Modified: 2013-08-07 15:14 UTC (History)
6 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Movie Showing Bug, downloaded and re-attached from duplicate issue (656.68 KB, video/x-msvideo)
2007-11-20 20:19 UTC, slagou
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2006-09-14 10:48:49 UTC
Data is lost when user drag&drops file to Calc. Repro steps:
1. Open Calc, type arbitrary text in any cell.
2. Open Explorer window and arrange it so that Calc is visible too.
3. Drag and drop spreadsheet file (either .xls or .ods) to any cell in open 
Calc window.
4. New file is opened, text typed in step 1 is lost. Note that window list 
contains just one file.
Comment 1 frank 2006-09-28 12:06:48 UTC
Hi Niklas,

as the original document is modified, a new one should be opnend but did not.
Your construction site ?

1.1.5 asks for saving the document which also isn't what is expected.

Frank 
Comment 2 niklas.nebel 2006-10-16 14:41:47 UTC
*** Issue 70443 has been marked as a duplicate of this issue. ***
Comment 3 kpalagin 2007-08-08 11:32:33 UTC
Dear developers,
any plans to fix this data-loss defect?
Thanks for your attention.
WBR,
K. Palagin.
Comment 4 ooo 2007-08-08 17:10:52 UTC
Without promising anything: probably for OOo2.4; 'nn' currently is on vacation.
Comment 5 paulwillis2 2007-10-30 22:05:14 UTC
I have same problem on Windows ME with csv import. Unsaved work lost, no save
dialogue, just new file open and no crash recovery copy saved. To import need
new file (new sheet becomes new file losing changes) then copy & paste into
desired file.
PW
Comment 6 slagou 2007-11-20 14:40:39 UTC
I just tested this on my Ubuntu 7.10 desktop (Gnome 2.2 - kernel
2.6.22-14-generic) using OO 2.3 and the problem still occurs. So it is not
specific to MS Operating Systems 
Comment 7 slagou 2007-11-20 19:00:24 UTC
This seems like a pretty sever bug, that is reproducible cross platform, results
in loss of data and effects all users.  All other Open Office Components seem to
deal with dragged files correctly.  

Would it be possible to increase the priority of this bug?  Its easily a P2,
maybe even a P1?  It was reported over a year ago and is still present.

Also as a potential fix, would it not be possible to implement the same behavior
that the File | open command produces when run on an document with unsaved
changes?  This simply opens the document in a new instance of the client,
leaving the existing unsaved document active.
Comment 8 slagou 2007-11-20 20:19:11 UTC
Created attachment 49780 [details]
Movie Showing Bug, downloaded and re-attached from duplicate issue
Comment 9 niklas.nebel 2007-12-04 18:07:27 UTC
retarget 2.x -> 3.x
Comment 10 kpalagin 2008-03-02 05:10:36 UTC
Could this trivial bug be finally fixed for 3.0?

As 1.1.5 does not loose data I set keyword regression.
Comment 11 frank 2008-07-09 12:31:06 UTC
*** Issue 90182 has been marked as a duplicate of this issue. ***
Comment 12 sniekest 2008-07-15 19:38:51 UTC
   Using OOo3.0 beta/2.4.1 GoOO DevBuild on Windows 2000 Professional SP4.

   I've just jumped on this one recently.

   It is, my opinion, an P2 issue, becouse:
      1) it affects many users (not only using windows XP, as originally 
reported);
      2) it is really easy reproducable;
      3) May couse a serious data loss (I have to recover one my document by 
gathering data from the paper ones, and It will take for me at least 30-60 min 
to do so. And the data, that was only on the spreadsheet is lost forever).

   Expected Calc behaviour (from user's perspective):
   Dragging and dropping a document on an open window should either: 
      1) open the dropped document in the new window (which I was expecting OO 
to do, when I dragged it form windows explorer to a Calc SpreadSheet), or
      2) open the dropped document in the same window, allowing to save the one 
You worked before, if it is modified).

   Blessed resolving of this issue.

  
Comment 13 christianschaefer 2009-01-09 22:43:52 UTC
Tested on OOo300m14 (build 9376) [OOo_3.0.1rc1_20081219_Win32Intel_install_en-US]
on WinXP SP2.

Bug is still there.
Comment 14 redflagzhulihua 2009-05-11 10:18:22 UTC
CC myself.

This data loss defect still exists in latest version (OOo3.1).
Comment 15 amy2008 2009-05-11 10:25:07 UTC
cc
Comment 16 paulwillis2 2009-05-11 12:40:31 UTC
Please can this issue be made a P1 or P2 at very least. The effect is
devastating and severely disappointing. I find it hard to promote the value of
this software and oss in general while such a basic problem has remained listed
for well over 2 years now.  Please?
Comment 17 niklas.nebel 2009-06-10 17:53:52 UTC
*** Issue 102614 has been marked as a duplicate of this issue. ***
Comment 18 niklas.nebel 2009-06-10 19:30:02 UTC
Fixed in CWS "calc51".
If the current document is modified, the dropped file is opened in a new window
(like with File/Open).
Comment 19 kpalagin 2009-06-11 07:04:31 UTC
Niklas,
do you mean that if current doc is not modified it gets closed without user's 
request?
That would be not good UX.
Comment 20 niklas.nebel 2009-06-11 09:15:30 UTC
No, that description was in fact a bit unclear. It's the same behavior as with
the "open" dialog - only an empty, unchanged document is replaced.
Comment 21 kpalagin 2009-06-11 09:32:00 UTC
That is great!
Thanks a ton!
WBR,
KP.
Comment 22 niklas.nebel 2009-07-06 13:37:49 UTC
reassigning to QA for verification
Comment 23 kpalagin 2009-07-14 15:20:57 UTC
Verified - found fixed in m51.
Comment 24 kpalagin 2009-07-14 15:21:26 UTC
Fixed - closing.
Comment 25 oc 2009-07-20 10:05:52 UTC
verified in internal build cws_calc51
Comment 26 niklas.nebel 2009-11-17 16:45:17 UTC
*** Issue 105918 has been marked as a duplicate of this issue. ***
Comment 27 niklas.nebel 2010-02-24 09:54:30 UTC
*** Issue 109538 has been marked as a duplicate of this issue. ***