Basic Calc/Spreadsheet Questions

2016-01-12 Thread Linda Hull 
Is there a written Tutorial for making charts in AOO 4.1.2? I haven't found
much.

I want to make a pie chart.

I have a list of country names and numbers:
390 CA
337 GB
286 NL
234 DE
 51KR
 46RU
 44EG

Calc appears to handle the CA GB NL as second column of data, but doesn't
know how to assign them values.

I would like the chart to have a key that shows the colors of the segment
and has the Country Code beside it:

[purple] CA
[green] GB
[yellow] NL

Is there a way to rotate the pie, so that I can pick which segments are in
front? Can the colors be changed?

How do I get a title to appear in the Chart? One time it worked. The next
time each word in the title ended up with a color marker by it, like a key;
but I couldn't make it do that again.

Separately:
I've had problems keeping titles at the tops of spreadsheets. When
reopened, they often end up below the table.

I appreciate all your help.

Sincerely,

Linda

Re: Basic Calc/Spreadsheet Questions

2016-01-12 Thread Rory O'Farrell 
On Tue, 12 Jan 2016 05:06:55 -0500
Linda Hull  wrote:

> Is there a written Tutorial for making charts in AOO 4.1.2? I haven't found
> much.
> 
> I want to make a pie chart.
> 
> I have a list of country names and numbers:
> 390 CA
> 337 GB
> 286 NL
> 234 DE
>  51KR
>  46RU
>  44EG
> 
> Calc appears to handle the CA GB NL as second column of data, but doesn't
> know how to assign them values.
> 
> I would like the chart to have a key that shows the colors of the segment
> and has the Country Code beside it:
> 
> [purple] CA
> [green] GB
> [yellow] NL
> 
> Is there a way to rotate the pie, so that I can pick which segments are in
> front? Can the colors be changed?
> 
> How do I get a title to appear in the Chart? One time it worked. The next
> time each word in the title ended up with a color marker by it, like a key;
> but I couldn't make it do that again.
> 
> Separately:
> I've had problems keeping titles at the tops of spreadsheets. When
> reopened, they often end up below the table.
> 
> I appreciate all your help.
> 
> Sincerely,
> 
> Linda

I don't do spreadsheets at other than a trivial level, but I can tell you that 
one can freeze the first rows/columns by positioning the cursor in the first 
row/column one does not wish to freeze and selecting /Window /Freeze.

 
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Basic Calc/Spreadsheet Questions

2016-01-12 Thread Brian Barker 

At 05:06 12/01/2016 -0500, Linda Hull wrote:

Is there a written Tutorial for making charts in AOO 4.1.2?


Yes: Chapter 3 "Creating Charts and Graphs: Presenting information 
visually" in the Calc Guide. See

https://wiki.openoffice.org/w/images/d/d0/0303CG33-ChartsAndGraphs.pdf .


I want to make a pie chart.


There's a section on pie charts.


I have a list of country names and numbers:
390 CA
337 GB
286 NL
[...]

Calc appears to handle the CA GB NL as second column of data, but 
doesn't know how to assign them values.


You need to swap the order of your columns: to have the labels to the 
left of the values.


I would like the chart to have a key that shows the colors of the 
segment and has the Country Code beside it:

[purple] CA
[green] GB
[yellow] NL


Tick "Display legend" in the fourth step ("Chart Elements") of the 
Chart Wizard.


Is there a way to rotate the pie, so that I can pick which segments 
are in front?


Reorder your data. The segments appear to be presented starting at 
the top and working anticlockwise.



Can the colors be changed?


Yes - at Tools | Options... | Charts | Default Colours.


How do I get a title to appear in the Chart?


Add it in the fourth step ("Chart Elements") of the Chart Wizard.


Separately:
I've had problems keeping titles at the tops of spreadsheets. When 
reopened, they often end up below the table.


Really?

You can create titles by entering them into suitable spreadsheet 
cells - or suitable merged cells. You can also enter a header at 
Format | Page... | Header | Edit... and similarly for a footer. I 
don't see why any of these should move around.


I trust this helps.

Brian Barker - privately


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Basic Calc/Spreadsheet Questions

2016-01-12 Thread Linda Hull 
Brian,

You have always come through with beautiful simple answers that take the
kinks out of doing things.

Thanks so MUCH!

I'll try this when I'm more awake and then I might have more questions.

Have a beautiful day :)

Most sincerely,

Linda

On Tue, Jan 12, 2016 at 6:15 AM, Brian Barker 
wrote:

> At 05:06 12/01/2016 -0500, Linda Hull wrote:
>
>> Is there a written Tutorial for making charts in AOO 4.1.2?
>>
>
> Yes: Chapter 3 "Creating Charts and Graphs: Presenting information
> visually" in the Calc Guide. See
> https://wiki.openoffice.org/w/images/d/d0/0303CG33-ChartsAndGraphs.pdf .
>
> I want to make a pie chart.
>>
>
> There's a section on pie charts.
>
> I have a list of country names and numbers:
>> 390 CA
>> 337 GB
>> 286 NL
>> [...]
>>
>> Calc appears to handle the CA GB NL as second column of data, but doesn't
>> know how to assign them values.
>>
>
> You need to swap the order of your columns: to have the labels to the left
> of the values.
>
> I would like the chart to have a key that shows the colors of the segment
>> and has the Country Code beside it:
>> [purple] CA
>> [green] GB
>> [yellow] NL
>>
>
> Tick "Display legend" in the fourth step ("Chart Elements") of the Chart
> Wizard.
>
> Is there a way to rotate the pie, so that I can pick which segments are in
>> front?
>>
>
> Reorder your data. The segments appear to be presented starting at the top
> and working anticlockwise.
>
> Can the colors be changed?
>>
>
> Yes - at Tools | Options... | Charts | Default Colours.
>
> How do I get a title to appear in the Chart?
>>
>
> Add it in the fourth step ("Chart Elements") of the Chart Wizard.
>
> Separately:
>> I've had problems keeping titles at the tops of spreadsheets. When
>> reopened, they often end up below the table.
>>
>
> Really?
>
> You can create titles by entering them into suitable spreadsheet cells -
> or suitable merged cells. You can also enter a header at Format | Page... |
> Header | Edit... and similarly for a footer. I don't see why any of these
> should move around.
>
> I trust this helps.
>
> Brian Barker - privately
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Basic Calc/Spreadsheet Questions

2016-01-12 Thread Brian Barker 

At 06:47 12/01/2016 -0500, Linda Hull wrote:
You have always come through with beautiful simple answers that take 
the kinks out of doing things.


How kind!


Thanks so MUCH!


No probs!

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Please Help

2016-01-12 Thread Julian Thomas 

> On Jan 11, 2016, at 23:04, Dale Erwin  wrote:
> 
> I submit that no set of computer-generated numbers is truly random.  
> Pseudo-random is the best you can hope for.

True if it's strictly an algorithmic process.  

Not necessarily true if you introduce variability from external sources [ping 
or response time on the network, or stock market fluctuations for example].  
Pseudo random implies repeatability.

In a prior life I came up with a scheme for a pseudorandom generator that used 
computer hardware measured values determined at power on to generate a 
non-repeatable seed.

I think we are converging on violent agreement!


 —
jt - j...@jt-mj.net

If it screams, it's not food... Yet. 





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: revolting support

2016-01-12 Thread John Hart 

On 1/11/2016 6:53 PM, Dennis E. Hamilton wrote:

John,

If you look at the raw SMTP headers that you presented in the first remark 
about From and To, you'll see that Reply-To has the list address, and also 
there is a List-Id field that could be used.  Delivered-To might be useful also.

I know that some email clients don't present these, but it may still be 
possible to have filter rules on them.


Thanks, I found a tab in Thunderbird to add filter types.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: revolting support

2016-01-12 Thread j.nitsc...@ok.de 
On Tue, 12 Jan 2016 03:20:33 + Toki wrote:
> My recommendation is to use the List-Id line for list mail.
Yes, List-Id is the standard. (RFC2919 if someone cares)
Here instructions how to setup various mail clients:
https://www.w3.org/2006/tools/wiki/EmailClientForMailingListFiltering

Cheers!



signature.asc
Description: OpenPGP digital signature

contact info

2016-01-12 Thread Scott Meyer 
Hi ,

Please send me a phone number so I can talk with a real person about Open
Office.

Thanks

Scott Meyer

Re: contact info

2016-01-12 Thread Martin Groenescheij 



On 13-Jan-16 10:48, Scott Meyer wrote:

Hi ,

Please send me a phone number so I can talk with a real person about Open
Office.

Thanks

Scott Meyer


You send an email to a user forum. Everyone is a user like you.
As OpenOffice is an open source project developed by volunteers there is 
no phone service.

Most questions get quick response from fellow users.
So when you have a question or problem send it to us.
Make sure you give enough information e.g. version of OpenOffice 
Operating System

what you were doing when the problem occurred etcetera.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: contact info

2016-01-12 Thread Alan B 
On Tue, Jan 12, 2016 at 6:48 PM, Scott Meyer  wrote:

> Please send me a phone number so I can talk with a real person about Open
> Office.
>

In addition to Martin's reply phone numbers for actual people are available
via paid support.

A (very short) list of potential consultant contacts can be found here
http://www.openoffice.org/bizdev/consultants.html

Updates

2016-01-12 Thread Dick Gauck 
Updates are available manually. When directed (downloaded) to the a web page 
there is no location to initiate the updates.

Sent from Mail for Windows 10