Issue 109527 - Unchanged cells with contents marked as changed - Calc spreadsheet
Summary: Unchanged cells with contents marked as changed - Calc spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-02-23 08:00 UTC by warnebald
Modified: 2013-01-29 21:48 UTC (History)
2 users (show)

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

Screen shots of problem in zip folder (639.35 KB, text/plain)
2010-04-20 03:21 UTC, warnebald
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description warnebald 2010-02-23 08:00:28 UTC
In A calc spreadsheet with EDIT-CHANGES-RECORD active if 2 non consecutive cells
in a row or column are selected and then deleted together with the delete key,
all cells in between that contain text, numeric data or formulas are also marked
as changed even though they have not been touched. If the two cells are deleted
separately one at a time there is no problem.
Comment 1 Rainer Bielefeld 2010-04-17 13:23:41 UTC
NOT reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]" and "Ooo-Dev
3.3 multilingual version English UI WIN XP: [DEV300_m76 (Build 9491)]" (here
using context menu instead of del key because of Issue 110958)!


Pls. feel free to reopen the issue if you find out that the problem still exists
in a current stable version (3.1.1 or later).
Before you file further issues or post again here, please read our guidelines on
<> and  
<>, then select
correct information for all Issue Tracker selection fields, 
contribute a clear step by step instruction containing all observations (error
messages ...), _every_key_press_and_every_mouse_click_ how to reproduce the
problem, and explain why you believe that your results are unexpected.
That means (for example): 
 do not write something like "I am not able to ...", but
  6. left mouse click on …
     expected: …, color of … changes, … 
     actual: no …., color remains white, no …

Screenshots might help to explain the problem.

- always specify your OOo version, localization,
  OS and Platform you used for your tests!
- attach a sample document (always with ODF source document)!
- Always contribute a meaningful Summary

I will close the issue finally within 10 days if we don't get required further
Comment 2 warnebald 2010-04-20 03:19:06 UTC
OO Calc version 3.2.0, Windows Vista 64bit duel core dell laptop inspiron 1521
Fill an array of cells with numbers or text. Turn on record changes. Select 2
non adjacent cells and select the delete contents function with all or any of
the options selected. After you click OK all items in the array between the two
selections that contain data will be marked as changed even though they have not
been changed and even if the data type should not have been affected by the
delete selection.
Comment 3 warnebald 2010-04-20 03:21:15 UTC
Created attachment 68996 [details]
Screen shots of problem in zip folder
Comment 4 Rainer Bielefeld 2010-04-20 05:21:22 UTC
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]", "Ooo-Dev 3.3
multilingual version German UI WIN XP: [DEV300_m76 (Build 9491)]"!

The problem only occurs if the unselected, not deleted cells are with contents,
empty cells will not be marked as changed.	
Comment 5 Rainer Bielefeld 2010-04-20 07:17:13 UTC
Also see that problem with "2.4.1 Multilingual version German UI WIN XP:
[680m17(Build9310)]" and 1.1.4 (German) WIN XP: [645m52 (Build 8824)]