You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Brian Barker <b....@btinternet.com> on 2012/10/18 05:03:37 UTC
Re: Calc: can the whole row be highlighted automatically when
focus on a cell?
At 10:05 18/10/2012 +0800, Lou QingLe 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 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...
Here's a workaround: when you have finished editing the first cell in
a row, instead of confirming your edit by pressing Enter, press
right-arrow. This confirms the editing and moves focus along in the
same row. Press right-arrow repeatedly until you reach the next cell
to be edited. Repeat as necessary.
If you wish, you can also confirm each edit by pressing the green
Accept tick mark next to the Input Line. This confirms the edit
without moving focus away from the cell being edited, thus again
keeping focus in the same row. Then use right-arrow as before.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc: can the whole row be highlighted automatically when focus on a cell?
Posted by Charles and Erika <ya...@nornet.on.ca>.
Dont send it here .Chas
----- Original Message -----
From: "Haim (Howard) Roman" <ro...@jct.ac.il>
To: <oo...@incubator.apache.org>
Sent: Wednesday, October 17, 2012 11:06 PM
Subject: Re: Calc: can the whole row be highlighted automatically when focus
on a cell?
> Regarding Brian's suggestion: you can configure your document so that
> ENTER
> moves the cursor right instead of down.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 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 5:03 AM, Brian Barker
> <b....@btinternet.com>wrote:
>
>> At 10:05 18/10/2012 +0800, Lou QingLe 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 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...
>>>
>>
>> Here's a workaround: when you have finished editing the first cell in a
>> row, instead of confirming your edit by pressing Enter, press
>> right-arrow.
>> This confirms the editing and moves focus along in the same row. Press
>> right-arrow repeatedly until you reach the next cell to be edited.
>> Repeat
>> as necessary.
>>
>> If you wish, you can also confirm each edit by pressing the green Accept
>> tick mark next to the Input Line. This confirms the edit without moving
>> focus away from the cell being edited, thus again keeping focus in the
>> same
>> row. Then use right-arrow as before.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail:
>> ooo-users-unsubscribe@**incubator.apache.org<oo...@incubator.apache.org>
>> For additional commands, e-mail:
>> ooo-users-help@incubator.**apache.org<oo...@incubator.apache.org>
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc: can the whole row be highlighted automatically when
focus on a cell?
Posted by Brian Barker <b....@btinternet.com>.
At 05:06 18/10/2012 +0200, Haim (Howard) Roman wrote:
>On Thu, Oct 18, 2012 at 5:03 AM, Brian Barker wrote:
>> At 10:05 18/10/2012 +0800, Lou QingLe 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 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...
>>
>>Here's a workaround: when you have finished editing the first cell
>>in a row, instead of confirming your edit by pressing Enter, press
>>right-arrow. This confirms the editing and moves focus along in
>>the same row. Press right-arrow repeatedly until you reach the
>>next cell to be edited. Repeat as necessary.
>>
>>If you wish, you can also confirm each edit by pressing the green
>>Accept tick mark next to the Input Line. This confirms the edit
>>without moving focus away from the cell being edited, thus again
>>keeping focus in the same row. Then use right-arrow as before.
>
>Regarding Brian's suggestion: you can configure your document so
>that ENTER moves the cursor right instead of down.
Indeed you can: go to Tools | Options... | OpenOffice.org Calc |
General | Input Settings | Press Enter to move selection:
Right. (But that's configuring your installation, in fact, not just
the current document.)
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Calc: can the whole row be highlighted automatically when focus
on a cell?
Posted by "Haim (Howard) Roman" <ro...@jct.ac.il>.
Regarding Brian's suggestion: you can configure your document so that ENTER
moves the cursor right instead of down.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 5:03 AM, Brian Barker <b....@btinternet.com>wrote:
> At 10:05 18/10/2012 +0800, Lou QingLe 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 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...
>>
>
> Here's a workaround: when you have finished editing the first cell in a
> row, instead of confirming your edit by pressing Enter, press right-arrow.
> This confirms the editing and moves focus along in the same row. Press
> right-arrow repeatedly until you reach the next cell to be edited. Repeat
> as necessary.
>
> If you wish, you can also confirm each edit by pressing the green Accept
> tick mark next to the Input Line. This confirms the edit without moving
> focus away from the cell being edited, thus again keeping focus in the same
> row. Then use right-arrow as before.
>
> I trust this helps.
>
> Brian Barker
>
>
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: ooo-users-unsubscribe@**incubator.apache.org<oo...@incubator.apache.org>
> For additional commands, e-mail: ooo-users-help@incubator.**apache.org<oo...@incubator.apache.org>
>
>