You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by davidbath <da...@davidbath.plus.com> on 2014/02/18 15:39:46 UTC
Uninitiateds basic question
Dear Open Office
Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head.
I imported a .wdb file which was put into Calc in cell “A” on 92 rows. I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it.
I want to sort the complete file but found that the “Sort” selection was greyed out. To me this indicated that some thing else needed to be done first. I tried “Select All” and many other functions but have yet no luck.
I have consulted the “Tutorials” but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction.
If it is possible that you could assist I would be most grateful.
Regards
David Bath
Re: Uninitiated's basic question
Posted by Brian Barker <b....@btinternet.com>.
At 14:39 18/02/2014 +0000, David Bath wrote:
>I imported a .wdb file which was put into Calc in cell "A" on 92
>rows. I needed to Edit 4 records which I discovered how to do but it
>left the boxes highlighted in red.
When you say "highlighted", you mean that the border of the cells has
turned red - with a small red square in the top left corner - right?
>I do not know what this means ...
This will be because you have the recording of changes turned on. If
you hover your mouse over the cells, you will see a note indicating
who made what change when.
>... and have been unable to remove it.
If you wish to maintain the recording of changes, you can accept the
changes made so far using Edit | Changes > | Accept or Reject...
. If (as is likely) you didn't want this in the first place, you can
more easily just turn it off by removing the tick from Edit |
Changes > | Record.
>I want to sort the complete file but found that the "Sort" selection
>was greyed out. To me this indicated that something else needed to
>be done first.
You need to accept your changes, making them permanent and no longer
marked (using either technique above), before you can do this. Once
you have done so, you will be able to select and sort the changed values.
I trust this helps.
Brian Barker
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Uninitiateds basic question
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
As you are not subscribed to the mailing list you have missed the
answer from Andrew Pitonyak.
His suggestion was that it could be that you Record Changes.
You could switch it of under Edit --> Changes ... Record.
See this article
<https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=11351> in the
forum.
To make sure you see all answers you should subscribe to this mailing list.
On 19-2-2014 22:01, davidbath wrote:
> Dear Mr Groenescheji
> Thank you for your fantastically fast reply. Unfortunately none of
> the replies in the forum were applicable, however I have worked out
> how to do it. The only thing I have not found out is the significance
> of the RED outline to the cell after I have manipulated entry. Could
> you tell me what it means.
> Regards
> David Bath
> *From:* Martin Groenescheij <ma...@Groenescheij.COM>
> *Sent:* Tuesday, February 18, 2014 11:18 PM
> *To:* users@openoffice.apache.org <ma...@openoffice.apache.org>
> ; david@davidbath.plus.com <ma...@davidbath.plus.com>
> *Cc:* Martin@Groenescheij.COM <ma...@Groenescheij.COM>
> *Subject:* Re: Uninitiateds basic question
> See this article
> <https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=55968> in
> the OpenOffice Forum.
>
> On 19-2-2014 1:39, davidbath wrote:
>> Dear Open Office
>>
>> Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head.
>>
>> I imported a .wdb file which was put into Calc in cell "A" on 92 rows. I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it.
>>
>> I want to sort the complete file but found that the "Sort" selection was greyed out. To me this indicated that some thing else needed to be done first. I tried "Select All" and many other functions but have yet no luck.
>>
>> I have consulted the "Tutorials" but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction.
>>
>> If it is possible that you could assist I would be most grateful.
>>
>> Regards
>>
>> David Bath
>
Re: Uninitiateds basic question
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
See this article
<https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=55968> in
the OpenOffice Forum.
On 19-2-2014 1:39, davidbath wrote:
> Dear Open Office
>
> Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head.
>
> I imported a .wdb file which was put into Calc in cell "A" on 92 rows. I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it.
>
> I want to sort the complete file but found that the "Sort" selection was greyed out. To me this indicated that some thing else needed to be done first. I tried "Select All" and many other functions but have yet no luck.
>
> I have consulted the "Tutorials" but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction.
>
> If it is possible that you could assist I would be most grateful.
>
> Regards
>
> David Bath
Re: Uninitiateds basic question
Posted by Hagar Delest <ha...@laposte.net>.
Forwarded to OP, not subscribed to the list.
Hagar
Le 18/02/2014 16:48, Andrew Douglas Pitonyak a écrit :
> On 02/18/2014 09:39 AM, davidbath wrote:
>> Dear Open Office
>>
>> Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head.
>
> Someone here will hopefully know the answers :-)
>
>>
>> I imported a .wdb file which was put into Calc in cell “A” on 92 rows.
>
> Did not know we could read wdb files...
>
>> I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it.
>
> So the background of the cell is red, just the outline is red?
>
> I expect that "change tracking" is turned on, but I am only guessing:
>
> https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=11351
>
>
>>
>> I want to sort the complete file but found that the “Sort” selection was greyed out. To me this indicated that some thing else needed to be done first. I tried “Select All” and many other functions but have yet no luck.
>
> What if you select only the cells that you want to sort? Is the sort method still greyed out?
>
>>
>> I have consulted the “Tutorials” but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction.
>>
>> If it is possible that you could assist I would be most grateful.
>>
>> Regards
>>
>> David Bath
>
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Uninitiateds basic question
Posted by Andrew Douglas Pitonyak <an...@pitonyak.org>.
On 02/18/2014 09:39 AM, davidbath wrote:
> Dear Open Office
>
> Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head.
Someone here will hopefully know the answers :-)
>
> I imported a .wdb file which was put into Calc in cell “A” on 92 rows.
Did not know we could read wdb files...
> I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it.
So the background of the cell is red, just the outline is red?
I expect that "change tracking" is turned on, but I am only guessing:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=11351
>
> I want to sort the complete file but found that the “Sort” selection was greyed out. To me this indicated that some thing else needed to be done first. I tried “Select All” and many other functions but have yet no luck.
What if you select only the cells that you want to sort? Is the sort
method still greyed out?
>
> I have consulted the “Tutorials” but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction.
>
> If it is possible that you could assist I would be most grateful.
>
> Regards
>
> David Bath
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Uninitiateds basic question
Posted by Daniel Lopez <d....@gmail.com>.
STOP
On Tue, Feb 18, 2014 at 8:39 AM, davidbath <da...@davidbath.plus.com> wrote:
> Dear Open Office
>
> Sorry to be contacting you on this, but I seem to be making little headway
> with what appears to be just what I need but is way above my head.
>
> I imported a .wdb file which was put into Calc in cell "A" on 92 rows. I
> needed to Edit 4 records which I discovered how to do but it left the boxes
> highlighted in red. I do not know what this means and have been unable to
> remove it.
>
> I want to sort the complete file but found that the "Sort" selection was
> greyed out. To me this indicated that some thing else needed to be done
> first. I tried "Select All" and many other functions but have yet no luck.
>
> I have consulted the "Tutorials" but there I cannot find any reference to
> my problems, in desperation I hope you could point me in right direction.
>
> If it is possible that you could assist I would be most grateful.
>
> Regards
>
> David Bath