You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Roy Grainger <ro...@sky.com> on 2014/03/25 11:39:57 UTC
Problem with Open Office
Using Apple Mac - Open Office- I can produce and save a document, when I go back into it I only get a snapshot and am unable to access/enlarge and work on it. I can copy documents via a memory stick onto a Laptop (not an Apple) where I can then work on it.
Have tried deleting and reinstalling Open Office but get the same results.
This has recently occurred and effects all of my documents.
Any help will be gratefully received.
Re: Calc and filter
Posted by Brian Barker <b....@btinternet.com>.
At 21:45 25/03/2014 +0100, Laurens Thissen wrote:
>On [25 mrt.], at 17:24, Brian Barker wrote:
>> At 13:49 25/03/2014 +0100, Laurens Thissen wrote:
>>>When I apply a filter in a Calc file, is it possible to see how
>>>many records are filtered? I am unable to find an easy way to do
>>>this in Calc. In Excel this is instantly readable in the status
>>>bar (e.g. 7 out of 36 records found).
>>
>>Towards the right of the Status Bar (at the bottom of the window),
>>you will see a field that is described as "Cell or object
>>information". This may show Sum or Average by default, but if you
>>right-click it you can select Count instead. Observing this both
>>before and after the filtering process may provide what you need.
>
>In order for Count to work for my purposes, I have to manually
>select a filtered, randomly selected column of cells, but these
>cells need to be formatted as Numbers.
You can count values more generally using CountA - which is also in
the same place - instead of Count.
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: Calc and filter
Posted by Laurens Thissen <lt...@xs4all.nl>.
Thanks Brian,
It helps, i.e. it’s a workaround, not ideal. In order for Count to work for my purposes, I have to manually select a filtered, randomly selected column of cells, but these cells need to be formatted as Numbers. All this is not so bad with small database files, but is quite cumbersome in the case of bigger ones. I hope I am overlooking something, but atm this is one of the strong points of Excel which I’d love to see developed for Calc as well.
Thanks again, Laurens
On [25 mrt.], at 17:24, Brian Barker <b....@btinternet.com> wrote:
> At 13:49 25/03/2014 +0100, Laurens Thissen wrote:
>> When I apply a filter in a Calc file, is it possible to see how many records are filtered? I am unable to find an easy way to do this in Calc. In Excel this is instantly readable in the status bar (e.g. 7 out of 36 records found).
>
> Towards the right of the Status Bar (at the bottom of the window), you will see a field that is described as "Cell or object information". This may show Sum or Average by default, but if you right-click it you can select Count instead. Observing this both before and after the filtering process may provide what you need.
>
> 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: Calc and filter
Posted by Brian Barker <b....@btinternet.com>.
At 13:49 25/03/2014 +0100, Laurens Thissen wrote:
>When I apply a filter in a Calc file, is it possible to see how many
>records are filtered? I am unable to find an easy way to do this in
>Calc. In Excel this is instantly readable in the status bar (e.g. 7
>out of 36 records found).
Towards the right of the Status Bar (at the bottom of the window),
you will see a field that is described as "Cell or object
information". This may show Sum or Average by default, but if you
right-click it you can select Count instead. Observing this both
before and after the filtering process may provide what you need.
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
Calc and filter
Posted by Laurens Thissen <lt...@xs4all.nl>.
When I apply a filter in a Calc file, is it possible to see how many records are filtered? I am unable to find an easy way to do this in Calc. In Excel this is instantly readable in the status bar (e.g. 7 out of 36 records found).
Thanks for your time,
Laurens
-------------------------------------------
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: Problem with Open Office
Posted by Roy Grainger <ro...@sky.com>.
Dave
Thank you for your very quick response, I have been toying with the problem over the last few hours, I noted that one document had locked after the title which I changed, shortly after I had to restart the computer as it would not open any files, low and behold the documents are now O.K. even a problem I had with the time it was taking to go into Open Office seems to have resolved itself.
The problem I had was with all my documents but this has also resolved itself and they are all behaving.
Many thanks for your suggestion I will log this in case I get a similar situation
Kind regards
Roy
On 25 Mar 2014, at 12:01, Dave Barton <db...@tasit.net> wrote:
> -------- Original Message --------
> From: Roy Grainger <ro...@sky.com>
> To: users@openoffice.apache.org
> Date: Tue, 25 Mar 2014 10:39:57 +0000
>
>> Using Apple Mac - Open Office- I can produce and save a document, when I go back into it I only get a snapshot and am unable to access/enlarge and work on it. I can copy documents via a memory stick onto a Laptop (not an Apple) where I can then work on it.
>> Have tried deleting and reinstalling Open Office but get the same results.
>> This has recently occurred and effects all of my documents.
>> Any help will be gratefully received.
>
> Roy,
>
> It sounds like you have inadvertently changed your document's zoom
> setting. Open your document, look in the bottom right hand corner of the
> document window and you will see an area with a percentage (maybe 20%)
> value. Right click in that area and from the context (pop-up) menu that
> appears select a different (maybe 100% or Page Width) option. Now save
> your document and when you open it again it should have the same zoom
> setting.
>
> Hope this helps.
>
> Dave
>
>
Re: Problem with Open Office
Posted by Dave Barton <db...@tasit.net>.
-------- Original Message --------
From: Roy Grainger <ro...@sky.com>
To: users@openoffice.apache.org
Date: Tue, 25 Mar 2014 10:39:57 +0000
> Using Apple Mac - Open Office- I can produce and save a document, when I go back into it I only get a snapshot and am unable to access/enlarge and work on it. I can copy documents via a memory stick onto a Laptop (not an Apple) where I can then work on it.
> Have tried deleting and reinstalling Open Office but get the same results.
> This has recently occurred and effects all of my documents.
> Any help will be gratefully received.
Roy,
It sounds like you have inadvertently changed your document's zoom
setting. Open your document, look in the bottom right hand corner of the
document window and you will see an area with a percentage (maybe 20%)
value. Right click in that area and from the context (pop-up) menu that
appears select a different (maybe 100% or Page Width) option. Now save
your document and when you open it again it should have the same zoom
setting.
Hope this helps.
Dave
-------------------------------------------
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