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