[Calc] Feature request: Find & Replace colors

[Tony <ab...@gmail.com>]

Hey!

I color-code my cells to assist me in entering data, creating or changing
formulae, or deleting data, formulae and links:

   - Enter data and information in Green shaded cells only
   - Blue shaded cells calculate results within a spreadsheet
   - Data in Yellow shaded cells is transferred to other worksheets
   - Purple shaded cells bring in data from other spreadsheets

But now I want to replace those colors with different shades, and cannot
find a function to do so.

Could OpenOffice.org Calc perhaps incorporate a Find & Replace function
similar to that of, say, the Adobe apps?

http://i.imgur.com/Xu9JG.png

Thanks for listening.

Tony

Re: [Calc] Feature request: Find & Replace colors

[Tony <ab...@gmail.com>]

On Tue, May 29, 2012 at 1:01 AM, Dan Lewis <el...@gmail.com> wrote:

>
>     Had you used cell styles to define these colors and applied these
> styles to the cells of your spreadsheet, changing any of the colors would
> be a snap. All you would have to do is to change the color in the
> appropriate style.
>     Furthermore, if you need a cell for a given purpose, you would only
> have to click the cell and double click the proper style.
>
> --Dan
>

Great idea Dan - thanks a bunch!

I hereby withdraw my Find & Replace feature request.

Tony

Re: [Calc] Feature request: Find & Replace colors

[Dan Lewis <el...@gmail.com>]

Tony wrote:
> Hey!
>
> I color-code my cells to assist me in entering data, creating or changing
> formulae, or deleting data, formulae and links:
>
>     - Enter data and information in Green shaded cells only
>     - Blue shaded cells calculate results within a spreadsheet
>     - Data in Yellow shaded cells is transferred to other worksheets
>     - Purple shaded cells bring in data from other spreadsheets
>
> But now I want to replace those colors with different shades, and cannot
> find a function to do so.
>
> Could OpenOffice.org Calc perhaps incorporate a Find&  Replace function
> similar to that of, say, the Adobe apps?
>
> http://i.imgur.com/Xu9JG.png
>
> Thanks for listening.
>
> Tony
>
      Had you used cell styles to define these colors and applied these 
styles to the cells of your spreadsheet, changing any of the colors 
would be a snap. All you would have to do is to change the color in the 
appropriate style.
      Furthermore, if you need a cell for a given purpose, you would 
only have to click the cell and double click the proper style.

--Dan

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org