Apache OpenOffice (AOO) Bugzilla – Issue 41447
Remember last formatting
Last modified: 2013-02-07 22:35:23 UTC
It would be really comfortable to have the formatting controls remember the last command. Let's see a use case: - I'm editing cells in Calc, and I want to give a pale yellow background to the cells I am interested in (e.g. a university exam, taxes, etc.) - select the cell with the mouse - choose a nice gradient of yellow (say "Yellow 2" - found another cell to color - oh, well,...I want to paint it like the former one, but must tell it again wich color to use, and of course I don't remember the gradient of yellow I've chosen. Was it "Yellow 2" or "Yellow 3"? Naah, let's go back to the previouse cell...uhm "Yellow 2" and so on. :) This _is_ frustrating, especially when you do it for work (which is the most important OOo target, isn't it?) I think that many users (especially the new ones) will like this behavior: - it's natural: less stuff to remember when editing, more concentration on contents instead of formatting - it's something users expect coming from MS Office: after all, Excel is not so bad in these use cases :) I understand that this change could upset old OOo users, so please take the time to evaluate this enhancement.
reassigned to requirements
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
This issue hasn't been addressed in either oocalc 2.4.0 or 3.0.0 Beta. While the "Format Paintbrush" can accomplish this task, there are a lot of times you just want to copy a cell's color and not its entire format. Here are the steps I currently need to follow if I want to copy the same color from one cell to another: 1. Move to the cell with the color I want. 2. Format -> Cells -> Background (tab) 3. Remember color 4. Click OK 5. Move to the cell I want to copy the color to. 6. Background color -> select color 7. If more cells to color, go to step 5. Here's what we want: 1. Move to cell with the color I want. 2. Background color -> "select current color as default" (or select a new color for this cell which also sets the default color) 3. Move to cell I want to copy the color to. 4. Click "Default Background color" button. 5. If more cells to color, go to step 3. Excluding the last steps in each part, the difference above is actually 9 steps versus 5 steps, since some steps have multiple steps. Since a mouse must be used for all these steps, it feels especially clumsy. Complementing the "what we want" steps 2 & 4 with keyboard shortcuts would be the best solution. (As far as I can tell, assigning "Background Color" to Ctrl+3 and then pressing Ctrl+3 doesn't do anything.)