Openoffice.org

Tomorrow's World was a show on BBC TV about innovations and tech stuff and I thought a good name for our computing and tech section.
User avatar
MKG
Site Admin
Site Admin
Posts: 5031
Joined: Fri Mar 07, 2008 5:15 pm
Location: North Notts.

Re: Openoffice.org

Post: #131164 MKG
Tue Nov 11, 2008 5:28 pm

I'm not sure what you mean by the text filter - nor is Excel Help :roll:

Give us a clue and I'll have a look around Open Office - I'll be well gobsmacked if what you need isn't actually there.
The secret of life is to aim below the head (With thanks to MMM)

Shirley
A selfsufficientish Regular
A selfsufficientish Regular
Posts: 7025
Joined: Fri Sep 30, 2005 9:05 am
Location: Manchester
Contact:

Re: Openoffice.org

Post: #131184 Shirley
Tue Nov 11, 2008 8:25 pm

Ok... well I usually apply a data filter when I upload the pricelist - and from each column, when I click the little downward arrow/triangle I am given an option (in Excel) to filter - I can choose equal to, contains, begins with, ends with, and more. I don't appear to be able to do this with OO calc.

eg. I've got a column called description. It contains 6000 items and I want to call up anything that has flour in the description. I can choose 'contains' and then type in 'flour' and it will only show the details for the descriptions containing 'flour' - it's been really useful to me while looking for certain items in the spreadsheet.

Of course this may not be the best way to do it, and there could be a search function that would do the job just as well, if not better.

I'm not put off, I've got Office 2007 anyway, but I do know that a lot of the people that download the spreadsheet don't have the same version (and indeed some may not have ANY version and thus don't order from the food co-op). If anyone knows of a way to upload a spreadsheet that can be shared, viewed, and updated by those that are allowed access then please let me know.
Shirley
NEEPS! North East Eco People's Site

My photos on Flickr

Don't forget to check out the Ish gallery on Flickr - and add your own photos there too. http://www.flickr.com/groups/selfsufficientish/

John Headstrong

Re: Openoffice.org

Post: #131189 John Headstrong
Tue Nov 11, 2008 9:08 pm

Shirley wrote:If anyone knows of a way to upload a spreadsheet that can be shared, viewed, and updated by those that are allowed access then please let me know.


yep, http://docs.google.com/

Shirley
A selfsufficientish Regular
A selfsufficientish Regular
Posts: 7025
Joined: Fri Sep 30, 2005 9:05 am
Location: Manchester
Contact:

Re: Openoffice.org

Post: #131197 Shirley
Tue Nov 11, 2008 10:27 pm

Thanks JH - will give that a shot.
Shirley
NEEPS! North East Eco People's Site

My photos on Flickr

Don't forget to check out the Ish gallery on Flickr - and add your own photos there too. http://www.flickr.com/groups/selfsufficientish/

User avatar
MKG
Site Admin
Site Admin
Posts: 5031
Joined: Fri Mar 07, 2008 5:15 pm
Location: North Notts.

Re: Openoffice.org

Post: #131209 MKG
Wed Nov 12, 2008 2:42 am

I posted the solution - and then tried it myself and so deleted my post. You're right - the function you need doesn't appear to be there. As it's such a simple function, that's plain silly. Like the police investigating the hole in the road, I'm looking into it.

EDIT: OK - I'm well gobsmacked. You can set up the downward arrow, but the dropdown box doesn't contain the filter conditions you need. An issue about the missing conditions was raised with the development team earlier this year, so I suppose that it's all in the pipeline. I am severely disgruntled.
The secret of life is to aim below the head (With thanks to MMM)

Shirley
A selfsufficientish Regular
A selfsufficientish Regular
Posts: 7025
Joined: Fri Sep 30, 2005 9:05 am
Location: Manchester
Contact:

Re: Openoffice.org

Post: #131243 Shirley
Wed Nov 12, 2008 2:22 pm

Thanks for your help - sorry that you have become disgruntled though.
Shirley
NEEPS! North East Eco People's Site

My photos on Flickr

Don't forget to check out the Ish gallery on Flickr - and add your own photos there too. http://www.flickr.com/groups/selfsufficientish/

oldfella
A selfsufficientish Regular
A selfsufficientish Regular
Posts: 1237
Joined: Tue Jan 22, 2008 3:31 pm
latitude: 44.564
longitude: 0.959
Location: Lot et Garonne France

Re: Openoffice.org

Post: #131250 oldfella
Wed Nov 12, 2008 3:52 pm

MKG wrote: I am severely disgruntled.


Sorry to hear about your problem, but I have a spare gruntle but unfortunately its of French origin, but if it of use to you, I will put it in the post tomorrow,

Regards Oldfella
I can't do great things, so I do little things with love.

Shirley
A selfsufficientish Regular
A selfsufficientish Regular
Posts: 7025
Joined: Fri Sep 30, 2005 9:05 am
Location: Manchester
Contact:

Re: Openoffice.org

Post: #131277 Shirley
Wed Nov 12, 2008 8:46 pm

oldfella wrote:
MKG wrote: I am severely disgruntled.


Sorry to hear about your problem, but I have a spare gruntle but unfortunately its of French origin, but if it of use to you, I will put it in the post tomorrow,

Regards Oldfella


:cheers: :flower: nice one!
Shirley
NEEPS! North East Eco People's Site

My photos on Flickr

Don't forget to check out the Ish gallery on Flickr - and add your own photos there too. http://www.flickr.com/groups/selfsufficientish/

User avatar
MKG
Site Admin
Site Admin
Posts: 5031
Joined: Fri Mar 07, 2008 5:15 pm
Location: North Notts.

Re: Openoffice.org

Post: #131294 MKG
Wed Nov 12, 2008 11:51 pm

Thanks, Oldfella.

I thought I had a spare one in the shed, but it appears that the mice have gnawed through the seal for the krombish valve.
The secret of life is to aim below the head (With thanks to MMM)

User avatar
Brij
Living the good life
Living the good life
Posts: 389
Joined: Tue Apr 01, 2008 12:48 pm
Location: Ile de France
Contact:

Re: Openoffice.org

Post: #131354 Brij
Thu Nov 13, 2008 2:13 pm

Have you tried Ctrl+F to do a simple "Find" for the text you want in the document?
"Only after the last tree has been cut down,
Only after the last river has been poisoned,
Only after the last fish has been caught,
Only then will you realise that money cannot be eaten"

Cree Indian prophecy

My Blogette


Return to “Tomorrow's World (Computing and Tech)”

Who is online

Users browsing this forum: No registered users and 1 guest