Apache OpenOffice (AOO) Bugzilla – Issue 103421
Mark cell contents sets document modified status
Last modified: 2013-01-29 21:46:42 UTC
The document modified status becomes set when I highlight part of the contents of a cell with the mouse and type Control+C. I first discovered this with Control+C but other combinations such as Control+A for select all also set the document modified status. Interestingly, some combinations, such as Control+F for find do not set the modified status. This seems to indicate that there is at least some routine which is inspecting key strokes and making a decision about whether the cell has been altered or not. The current behavior is wrong, since Copy does not modify the document. It is also annoying because I have many spreadsheets that are reference documents such as a list of passwords. I only open them to copy data out of and into other applications. Every time I open, copy, and close these documents I have to respond to the document modified dialog asking if I want to save changes even though no changes have been made. Steps to reproduce (using attached spreadsheet test_modified_status.ods) 1) Select cell A1 2) Use the mouse to select the value 'a' in the cell input line above the spreadsheet 3) Type Control+c to copy the value 4) Select cell A2 simply to move the focus away from the current cell. The document modified status will change.
Created attachment 63440 [details] Spreadsheet to demonstrate issue with document modified status
I checked attached "test_modified_status.ods" with "Ooo 3.1.0 WIN XP multilingual version German UI activated [OOO310m11 (Build 9399)]" and can confirm the reported effect. Some comments concerning the report: "1": simply click 'A1' "2": double click and mark cell contents with pressed mouse button "3": seems to be not necessary, I skipped this step and also reached the reported result I was able to reproduce the reported effect with own documents and "test_modified_status.ods" in a similar way: 0. open "test_modified_status.ods" 1. move cell cursor to 'A1' using cursor arrow keys 2. pres <F2> to get caret into cell 3. press <cntrl>+<a> to mark all cell contents 4. press <Tab> key to move cell cursor to 'B1' expected: nothing else happens actual: disk icon for "Save" changes mode from "greyed out" to "active", same with "undo" icon You will get the same effect with <Escape> key in step 4