To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105211 Issue #|105211 Summary|copy-paste dollars and formulas broken Component|Spreadsheet Version|OOO310m19 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|yinghu37
------- Additional comments from [email protected] Sat Sep 19 18:40:37 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
