Re: Calc Spreadsheet Questions (Linda)

[PCS]

1.  Make the font size bigger, then make the row height bigger, to fit the 
selected font size, or select optimal height to have the spreadsheet 
automatically adjust the row height for the text size, and also to auto-adjust 
for multiple lines of text in a cell if you use text wrapping, and finally 
adjust the cell width to fit the larger text or to determine where to wrap it.

•   If it is possible to change the default font size I don't know how, but 
if you create a template with the settings you prefer and save it as stationery 
you can open a new document that is ready to use without having to change font 
sizes etc.

2.  I don’t know how Windows deals with this but I believe OO and LO are 
pretty consistent across platforms (they certainly are on Mac and Linux, that 
is one of their ’selling’ points), so try copying the data in the Word document 
and using Edit / Paste Special / Paste Special… (in the first Paste Special 
menu), and in the next dialog box select “Use text import dialog”, then OK. 
Using LO on the Mac (I’ve recently switched from OO) that placed a group of tab 
or return separated numbers (see below) from a text document into different 
cells in the spreadsheet and made them able to be used in it (a simple copy and 
paste does not do this, it ignores the tabs and puts a whole row of numbers 
into a single cell). I’m pretty sure OO did the much same on the Mac and it 
should be pretty similar on Windows. Expert users probably have a better way of 
doing this, which could be worth learning if you are doing it often, but if you 
only do it occasionally and this works for you why waste time and effort 
learning to become an expert, just use the tools that you already have to hand.

123 456 789
987 654 321

This group of numbers was pasted into a spreadsheet as described above.

123 456 789 
1368
987 654 321 
1962





111011101110
3330





And these calculations were performed on them (the imported text size has been 
adjusted to be the same as the other text in this document).

•   If I have misunderstood and you are copying from a Spreadsheet to a 
text document, a simple copy and paste should work, though some text resizing 
and tidying up may be required. To copy largish portions of a sheet you could 
make a screen pic of the portion you want to use and insert that into your text 
document, but it will be displayed as a graphics object instead of being 
integrated into the text. If all that you want is a particular sheet or a 
selected portion of a sheet, with no other text or data that is not in the 
spreadsheet itself, it may be better just to save the selected portion of the 
spreadsheet as a PDF document, e.g. my wife operates a very small business and 
I do her monthly invoices that way and email out the PDF documents, because we 
can’t justify the cost of proper invoicing software for such a micro-business.

3.  Sorry, I’m not sure what’s happening there, maybe a Windows issue or 
maybe an OO setting that I’ve forgotten exists, or maybe something else 
entirely.

I hope some of this may be of use to you,

Peter.


> On 7 Nov 2022, at 4:03 am, Linda Hull  wrote:
> 
> I'm on Windows 10, Open Office 4.1.11.
> 
> I'd like to:
> 
> 1. Make the cells and text in a Calc spreadsheet larger, easier to read.
> 2. Put data on a spreadsheet that appears in a Writer document.  I send
> simple letters, don't know page styles etc.
> 
> Are there directions somewhere or can someone explain the steps?
> 
> 3. In the past, when I've saved and reopened a spreadsheet, the headings I
> put in appear lower down.  Is there a way to make them stay at the top?
> 
> Thanks so much!
> 
> Linda

Calc Spreadsheet Questions

[Linda Hull]

I'm on Windows 10, Open Office 4.1.11.

I'd like to:

1. Make the cells and text in a Calc spreadsheet larger, easier to read.
2. Put data on a spreadsheet that appears in a Writer document.  I send
simple letters, don't know page styles etc.

Are there directions somewhere or can someone explain the steps?

3. In the past, when I've saved and reopened a spreadsheet, the headings I
put in appear lower down.  Is there a way to make them stay at the top?

Thanks so much!

Linda

Basic Calc/Spreadsheet Questions

[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

[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

[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

[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: Basic Calc/Spreadsheet Questions

[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