Issue 41447 - Remember last formatting
Summary: Remember last formatting
Status: UNCONFIRMED
Alias: None
Product: ui
Classification: Code
Component: ui (show other issues)
Version: 680m71
Hardware: PC Windows 2000
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-27 11:57 UTC by megadix
Modified: 2013-02-07 22:35 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description megadix 2005-01-27 11:57:57 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.
Comment 1 jack.warchold 2005-01-28 13:58:09 UTC
reassigned to requirements
Comment 2 ace_dent 2008-05-16 00:22:52 UTC
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
Comment 3 frednju 2008-05-16 12:44:25 UTC
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.)