Issue 103421 - Mark cell contents sets document modified status
Summary: Mark cell contents sets document modified status
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO310m11
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-07-08 17:44 UTC by openofficebugs
Modified: 2013-01-29 21:46 UTC (History)
2 users (show)

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

Spreadsheet to demonstrate issue with document modified status (8.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-08 17:46 UTC, openofficebugs
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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
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