Apache OpenOffice (AOO) Bugzilla – Issue 69524
Calc - data loss when drag&dropping file to Calc
Last modified: 2013-08-07 15:14:30 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.
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
*** Issue 70443 has been marked as a duplicate of this issue. ***
Dear developers, any plans to fix this data-loss defect? Thanks for your attention. WBR, K. Palagin.
Without promising anything: probably for OOo2.4; 'nn' currently is on vacation.
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
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
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.
Created attachment 49780 [details] Movie Showing Bug, downloaded and re-attached from duplicate issue
retarget 2.x -> 3.x
Could this trivial bug be finally fixed for 3.0? As 1.1.5 does not loose data I set keyword regression.
*** Issue 90182 has been marked as a duplicate of this issue. ***
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.
Tested on OOo300m14 (build 9376) [OOo_3.0.1rc1_20081219_Win32Intel_install_en-US] on WinXP SP2. Bug is still there.
CC myself. This data loss defect still exists in latest version (OOo3.1).
cc
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?
*** Issue 102614 has been marked as a duplicate of this issue. ***
Fixed in CWS "calc51". If the current document is modified, the dropped file is opened in a new window (like with File/Open).
Niklas, do you mean that if current doc is not modified it gets closed without user's request? That would be not good UX.
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.
That is great! Thanks a ton! WBR, KP.
reassigning to QA for verification
Verified - found fixed in m51.
Fixed - closing.
verified in internal build cws_calc51
*** Issue 105918 has been marked as a duplicate of this issue. ***
*** Issue 109538 has been marked as a duplicate of this issue. ***