Public bug reported: This bug may belong upstream at OpenOffice.org . . . .
OpenOffice.org 3.1.1 OOO310m19 (Build:9420) openoffice.org-core 1:3.1.1-1ubuntu2 Ubuntu 9.10 alpha 6, 64-bit (may be similar to bug #388464 ??) Spreadsheet Copy and paste in the spreadsheet of this edition of OpenOffice.org is completely and utterly broken (this breakage occurred between the edition of OpenOffice.org 3.x found in Ubuntu 9.04, where it worked, and now). Copying and pasting dollar values, such as $4,271.70, causes these to be inserted into the spreadsheet as text, i.e. '$4,271.70, not as numbers, which was the previous and proper behavior. Copying and pasting a formula meant to use these dollar values (even when they are converted back to numbers) brings up a weird text-formatting dialog box, and when a choice is made, and then pasting is supposed to occur, nothing is found in the supposedly pasted-into cells (in other words, you can no longer paste a formula found in one cell up or down a column). If one attempts to paste a formula from the originating cell into one single other cell, it works. If one continues, and pastes individually into a second receiving cell, that cell receives the _*value* of the first cell that *received* the paste_ (wtf!?). This all is about as incorrect a pasting behavior as can be. These problems manifest in some form whether one is attempting C-c, C-p, or Unix-style highlight and middle-click, or mouse/menu 'Copy'/'Paste'. If one cannot paste and delete numbers in and out of a spreadsheet (never mind doing any formatting afterwords), and cannot paste a formula up and down a column of numbers, it is pretty much useless. This is a show-stopper bug; I am going to have to switch to a different spreadsheet software. Description: Ubuntu karmic (development branch) Release: 9.10 ** Affects: ubuntu Importance: Undecided Status: New -- Spreadsheet copy-paste of dollars and formulas broken https://bugs.launchpad.net/bugs/433211 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