Public bug reported:
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 several different times with several
different cell locations -- skip step 3 (do not select all); nothing
apparently happens
2 continue by repeating the above steps one more time and this time
include step 3
3 all contents of cells selected during prior repetitions is now
overwritten
** Affects: openoffice.org2-amd64 (Ubuntu)
Importance: Undecided
Status: New
--
datapilot overwrites cell contents on a protected source sheet before table
creation; cannot be undone
https://bugs.launchpad.net/bugs/196321
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
