Re: [libreoffice-users] Tie a line to two cells

2012-07-01 Thread Tom Davies
Hi :)
How about just drawing a graph of all their results?  Each person could have a 
different colour line.  A line graph could show change over time.
Regards from
Tom :)  


--- On Sat, 30/6/12, Johnny Rosenberg gurus.knu...@gmail.com wrote:

From: Johnny Rosenberg gurus.knu...@gmail.com
Subject: [libreoffice-users] Tie a line to two cells
To: LibreOffice Användare users@global.libreoffice.org
Date: Saturday, 30 June, 2012, 15:46

Let's say that we have a small table with two columns: Column A=Name
and Column B=Value.

Adam   45
Bert     42
Caesar 90
David   33

The values could be anything, let's say points in some game. Of course
we want to sort the list:
Caesar 90
Adam   45
Bert     42
David   33

Okay, now they play another round of their game, and their points now
increased in most cases:
Caesar  90 (he blew it completely, didn't he…? ☺)
Adam  103
Bert    111
David   96

Now I want to illustrate how their positions changed by drawing lines
between them.
First I just copy their names to column D, so their order is the same
as after their last game, in this case as above with Caesar first and
David last.
Then entering their points, just like I did above.
Now I draw lines: B1↔D1, B2↔D2 and so on.
Caesar 90 —— Bert    111
Adam   45 —— Adam 103
Bert     42 —— David   96
David   33 —— Caesar 90


As the very last step I sort D1:E4.
Caesar 90 \  /  Bert    111
Adam   45 -\/– Adam 103
Bert     42  / \ /David   96
David   33    / \Caesar 90

However, this is not what happens. No lines are moved at any
direction. Is there a way to do this?


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Tie a line to two cells

2012-07-01 Thread Johnny Rosenberg
2012/7/1 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 How about just drawing a graph of all their results?  Each person could have 
 a different colour line.  A line graph could show change over time.
 Regards from
 Tom :)

Yes, that works, but that was not what I asked. Thanks anyway.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 --- On Sat, 30/6/12, Johnny Rosenberg gurus.knu...@gmail.com wrote:

 From: Johnny Rosenberg gurus.knu...@gmail.com
 Subject: [libreoffice-users] Tie a line to two cells
 To: LibreOffice Användare users@global.libreoffice.org
 Date: Saturday, 30 June, 2012, 15:46

 Let's say that we have a small table with two columns: Column A=Name
 and Column B=Value.

 Adam   45
 Bert 42
 Caesar 90
 David   33

 The values could be anything, let's say points in some game. Of course
 we want to sort the list:
 Caesar 90
 Adam   45
 Bert 42
 David   33

 Okay, now they play another round of their game, and their points now
 increased in most cases:
 Caesar  90 (he blew it completely, didn't he…? ☺)
 Adam  103
 Bert111
 David   96

 Now I want to illustrate how their positions changed by drawing lines
 between them.
 First I just copy their names to column D, so their order is the same
 as after their last game, in this case as above with Caesar first and
 David last.
 Then entering their points, just like I did above.
 Now I draw lines: B1↔D1, B2↔D2 and so on.
 Caesar 90 —— Bert111
 Adam   45 —— Adam 103
 Bert 42 —— David   96
 David   33 —— Caesar 90


 As the very last step I sort D1:E4.
 Caesar 90 \  /  Bert111
 Adam   45 -\/– Adam 103
 Bert 42  / \ /David   96
 David   33/ \Caesar 90

 However, this is not what happens. No lines are moved at any
 direction. Is there a way to do this?


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted