OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Getting Divorced...

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dmoc
General User
General User


Joined: 18 Nov 2005
Posts: 9

PostPosted: Fri Dec 02, 2005 3:08 am    Post subject: Getting Divorced... Reply with quote

Crying or Very sad ...so we sit down (amicably Very Happy ) and compile a list of belongings such as...

ITEM OWNER
Bike Him
Car Her
Computer Him
Stereo Her

...and now we want a list such as...

OWNER ITEMS
Her Car,Stereo
Him Bike, Computer

...and after "dis'cussin" Rolling Eyes how to do this we decide to go to arbitration, ie, this forum Razz

So, any suggestions?

PS: Just joking, no divorce, thought I'd make the request entertaining Twisted Evil
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Dec 02, 2005 6:44 am    Post subject: Re: Getting Divorced... Reply with quote

Without actually trying it ...

Have both lists in the same order: Owner, Item.

Now try SORT and FILTER options. It's a matter possibly of just arranging the material as is?

Good luck on the hypothetical divorce. Let us know how you make out. According to common practice, you might as well just make one list, for her. That also makes it easier to sort. Smile

David.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Fri Dec 02, 2005 7:24 am    Post subject: Re: Getting Divorced... Reply with quote

dmoc wrote:
Crying or Very sad ...so we sit down (amicably Very Happy ) and compile a list of belongings such as...

ITEM OWNER
Bike Him
Car Her
Computer Him
Stereo Her

...and now we want a list such as...

OWNER ITEMS
Her Car,Stereo
Him Bike, Computer

...and after "dis'cussin" Rolling Eyes how to do this we decide to go to arbitration, ie, this forum Razz

So, any suggestions?

PS: Just joking, no divorce, thought I'd make the request entertaining Twisted Evil


I believe you're in the wrong forum. Marriages and divorces are handled in Setup & Troubleshooting Smile
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
richhill
OOo Advocate
OOo Advocate


Joined: 16 Jun 2004
Posts: 418
Location: Mesa, AZ

PostPosted: Fri Dec 02, 2005 8:02 am    Post subject: Reply with quote

Quote:
Marriages and divorces are handled in Setup & Troubleshooting


A bit late for troubleshooting, try upgrades/exchanges Laughing
_________________
OOo Calc tips: http://www.openofficetips.com
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Dec 02, 2005 8:04 am    Post subject: Reply with quote

Or look for an older version. I hear older is better.

David.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Dec 02, 2005 8:49 am    Post subject: Reply with quote

Make this table a little bit more spicy:
Add a third column VALUE!
Since it may take a while until you agreed about it's content, fill it with ones.
Select this table (or the entire columns)
Data > Data Pilot
In the wizzard drag the ITEM into the left Row-Box, OWNER into the top Column-box and VALUE into the large box in the center.
As target for the data-pilot, choose the top-left cell of some free space on any sheet. After adding some VALUEs, select a cell within the new data-pilot range and apply Data > Refesh.
Back to top
View user's profile Send private message
BookLady
Super User
Super User


Joined: 03 Nov 2004
Posts: 727

PostPosted: Fri Dec 02, 2005 11:21 am    Post subject: Reply with quote

What no column for when or how acquired? Who gave what to whom when and why can make a big difference.

This thread reminds me of one on another board about just what things people keep track of using spreadsheets.

And David, if they spend a little more time "making out" instead of "making lists" the divorce issue would probably be moot.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Dec 02, 2005 3:05 pm    Post subject: Reply with quote

BookLady wrote:
And David, if they spend a little more time "making out" instead of "making lists" the divorce issue would probably be moot.


My kind of woman. Smile Relax. I'm many years happily married. However, back to the original problem hidden in all of this, I do think that a solution is in sorting and filtering. Any other suggestions peerhaps?

David.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Dec 02, 2005 3:36 pm    Post subject: Re: Getting Divorced... Reply with quote

dmoc wrote:
:
PS: Just joking, no divorce, thought I'd make the request entertaining Twisted Evil

OK, my answer was not complete. Your table could be a simple unordered list with one item per cell:
OWNER ITEM VALUE
Romeo Car 0
Juliet Bike 3
Juliet Child 1
Romeo Child 1
Romeo Child 2
......

With Tools >Content >auto-input you just have to type J and R in the first column.
Then you may create a data-pilot, which will look like this:
Code:

         J R  All
Car     1  1   2
Bike    3 0   3
Child   1 3   4
SUM    5 4  9

Or simply select data Data > apply autofilter
Back to top
View user's profile Send private message
dmoc
General User
General User


Joined: 18 Nov 2005
Posts: 9

PostPosted: Fri Dec 02, 2005 4:27 pm    Post subject: Reply with quote

Thanks for all the suggestions! In the mean time I did it by hand (constructing the list that is). There's no values involved and my best guess is a macro to scan and compile... but list handling would be nice (anyone used LotusNotes macros? Good list handling).

BTW: If I ever get divorced (assuming I ever get married) I'll be back for advice Razz

Thanks all and keep the suggestion coming if you come up with any interesting solutions.
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Fri Dec 02, 2005 5:15 pm    Post subject: Reply with quote

You could always try a macro to work it's way through the lot. That would be more useful if your fictional soon-to-be-estranged wife and you had a lot to argue over.

dmoc wrote:
BTW: If I ever get divorced (assuming I ever get married) I'll be back for advice Razz

By that stage you'll be too late for advice! I seem to remember Revnomad saying he did a bit of this relationship counselling stuff.

Good way to draw attention to your thread though. Perhaps next time I have a query I'll give it the title "I really need a girlfriend". Wink No-one would post still... Crying or Very sad
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group