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

Reply via email to