Issue 103421

Summary: Mark cell contents sets document modified status
Product: Calc Reporter: openofficebugs <openofficebugs>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: OOO310m11Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Spreadsheet to demonstrate issue with document modified status none

Description openofficebugs 2009-07-08 17:44:28 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.
Comment 1 openofficebugs 2009-07-08 17:46:30 UTC
Created attachment 63440 [details]
Spreadsheet to demonstrate issue with document modified status
Comment 2 Rainer Bielefeld 2009-07-09 04:49:16 UTC
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