datapilot overwrites cell contents on a protected source sheet before table creation; cannot be undone

Bug #196321 reported by ethanay
2
Affects Status Importance Assigned to Milestone
openoffice.org (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

Binary package hint: openoffice.org2-core

On up to date Ubuntu Gutsy

openoffice.org-core version: 1:2.3.0-1ubuntu5.3
------------------------------------
steps to reproduce
------------------------------------
1 open data source sheet in Oo calc

2 leave cursor at any full cell x,y (within the source data range)

3 use ctrl-a to "select all" on source sheet (cursor still at cell x,y)

4 start datapilot

5 use current selection

6 hit "tab" at least six times to pass "selection from" category

7 cancel datapilot

8 return to source sheet

9 the contents of cell x,y have been overwritten

10 it is not possible to undo the changes using the "undo" function, requiring reversion to last known-good saved version of the document
-----------------------------------
this also occurs with unprotected sheets; however, it is more disconcerting that it occurs with protected data.

it seems that datapilot ignores the original "select all" range and, when tabbing through the "selection from" option in the datapilot layout window, the current cell cursor location is used instead. This seems understandable given the default value for the pivot table location -- there is no "underneath" a range defined by select all (infinity)

Here's the bug:
1 pivot table data is written by default underneath the selected range, but that doesn't explain why cell x,y is overwritten (the cells beneath it should be overwritten).
2 since the datapilot operation is canceled, no table should be created and no cell contents should be overwritten
3 the changes cannot be undone
4 it should not be possible to overwrite protected data
---------------------------------------
note: on further testing it seems that datapilot leaves a "marker" that can cause latent subsequent data loss

1 repeat the above steps 1-10 -- skip step 3 (do not select all); nothing apparently happens

2 continue by repeating the above steps one more time with or without step three

3 all contents of two sets of cells are now overwritten rather than one set of cells

Revision history for this message
ethanay (ethan-y-us) wrote :

whatever the default i386 openoffice install is...up to date

Revision history for this message
Chris Cheney (ccheney) wrote :

Can you attach an example document that exhibits this problem.

Thanks,

Chris Cheney

Changed in openoffice.org:
assignee: nobody → ccheney
status: New → Incomplete
ethanay (ethan-y-us)
description: updated
Revision history for this message
ethanay (ethan-y-us) wrote :

see attached

sheet 1 is clean. sheet two shows the results of the problem after a couple of repetitions. Note that BOTH sheets are protected. You should be able to reproduce on sheet 1.

I briefly unprotected sheet 2 after reproducing the problem to add comments.

Revision history for this message
ethanay (ethan-y-us) wrote :

What is the status of this bug?

Is there any more info necessary?

Revision history for this message
Chris Cheney (ccheney) wrote :

I believe that this bug has been corrected in Ubuntu hardy openoffice.org 1:2.4.0~rc2-1ubuntu3 so I am marking it as Fix Released. If after upgrading you continue to have problems with this issue then feel free to reopen this bug.

Thanks,

Chris Cheney

Changed in openoffice.org:
assignee: ccheney → nobody
status: Incomplete → Fix Released
Revision history for this message
ethanay (ethan-y-us) wrote :

great to hear it -- thanks

ethan

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.