Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
Sender: roman@g.jct.ac.il
In-Reply-To: <507F6DAB.3030807@Groenescheij.COM>
References: 
 <CAO30CPXpiG+5g_tWrA5W-NOvDsEujxXMtKrNSq0=ZkONviJM9A@mail.gmail.com>
	<507F6DAB.3030807@Groenescheij.COM>
Date: Thu, 18 Oct 2012 05:04:42 +0200
Message-ID: 
 <CAKsmiHUovgB_NA-OTRjfH3BzMFVxQNhYiL_kx+XNrXyCEVEmPA@mail.gmail.com>
Subject: Re: Calc: can the whole row be highlighted automatically when focus
 on a cell?
From: "Haim (Howard) Roman" <roman@jct.ac.il>
To: ooo-users@incubator.apache.org
Content-Type: multipart/alternative; boundary=047d7b2e42b2107c1404cc4ca650

--047d7b2e42b2107c1404cc4ca650
Content-Type: text/plain; charset=ISO-8859-1

Is there a way to select some sort of table format so that, e.g., every 3rd
row is a different color?  That would help you keep track.

Regarding Martin's suggestion of filtering:
(1) you could add a column at the beginning that is simply row number.
That would be easy to fill in.  And that would make filtering easy.
(2) when filtering, you could show a small number of rows.  That would make
keeping track of which row you're on easier.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Haim (Howard) Roman
Computer Center, Jerusalem College of Technology
Phone: 052-8-592-599 (6022 from within Machon Lev)


On Thu, Oct 18, 2012 at 4:47 AM, Martin Groenescheij <
Martin@groenescheij.com> wrote:

> I don't know how to highlight a row automatically, but why don't you use
> the Auto Filter option.
> Select a column with unique values (or multiple columns) so that there is
> only one row visible.
>
>
> On 18/10/2012 1:05 PM, lou ql wrote:
>
>> I am editing a calc file, and have to change data in discontinuous cells
>> row by row.
>>
>> In order to avoid changing data of another row, I follow the steps for
>> each:
>> 1. edit data in one cell, e.g. C111
>> 2. highlight the whole row manually to help me to locate the the next cell
>> that need modify, e.g. F111
>> 4. repeat highlight then select till this row finished.
>>
>> It will be helpful if the row can be highlighted automatically when I
>> focus
>> or edit a cell...
>>
>>
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: ooo-users-unsubscribe@**incubator.apache.org<ooo-users-unsubscribe@incubator.apache.org>
> For additional commands, e-mail: ooo-users-help@incubator.**apache.org<ooo-users-help@incubator.apache.org>
>
>

--047d7b2e42b2107c1404cc4ca650--