OpenOffice.org 3.1.1
OOO310m19 (Build:9420)
openoffice.org-core 1:3.1.1-1ubuntu2
Ubuntu 9.10 alpha 6, 64-bit
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 something is chosen, 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
must move to a different spreadsheet software.

**Spreadsheets, like any software, should make difficult things easy, not easy
things difficult.  In Excel (sorry to mention it), if you delete a cell, it just
deletes.  In OOo spreadsheet, you get this dialog asking if you want to delete
formatting, yadda, yadda, and get it _everytime_ you delete something (the
program is extremely poor about remembering often-chosen options).  This is
dumb. It should just delete.  This is what most people are doing. For those who
need more complicated deleting scenarios, there should be a button on the menus
that basically says "Turn on more complicated deleting scenarios so options can
be chosen upon delete" - this is the sensible design.