Issues

[David Beanblossom <pd...@charter.net>]

I have been building a house and have spent way too much time generating
spreadsheets lately since the project is winding down.  I have observed what
I believe are defects in your calc program. Such as:

 

 

.         I haven't found a way to change the default fonts in Calc.  They
are always Arial 10.  I have change the OpenOffice Writer to what I want,
but not in Calc.

 

.         Spell check does not work in Calc although it tells you everything
is OK and there is no misspelling.

 

.         I have a file with multiple sheets.  In one file, sheet #2 shows
data, but it is blank in page preview and will not print.  Yet the data is
right in front of me.

 

.         The header and footers drive me nuts.  I can't turn off the header
"Sheet 1" nor the footer "Page 1".  I have to go into every sheet and delete
them every time I open a spreadsheet.  If you can turn them off or make a
default, your Help button doesn't know it.  And, if I do delete them and
later want to add a header, I can't.  The header and footer are grayed out
in "Edit" and cannot be added under "Insert".  What is the deal???

 

I will write more when I remember the other irritations of Calc.

 

 

David Beanblossom

(864) 676-2218

pdtmu@charter.net

 



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Re: Issues

[Regina Henschel <rb...@t-online.de>]

Hi David,

David Beanblossom schrieb:
> I have been building a house and have spent way too much time generating
> spreadsheets lately since the project is winding down.  I have observed what
> I believe are defects in your calc program.

If they are indeed bugs, then you should report them to our Bugzilla 
https://issues.apache.org/ooo/. But it is likely, that things work, but 
perhaps not in a way you expect. For that you should discuss the 
problems in the forum https://forum.openoffice.org/en/forum/ or on the 
users mailing list users@openoffice.apache.org.

  Such as:
>
>
>
>
>
> .         I haven't found a way to change the default fonts in Calc.  They
> are always Arial 10.  I have change the OpenOffice Writer to what I want,
> but not in Calc.

Change the font in the cell style "Default". To make the setting 
permanent, save the document as template and set this template as your 
default template.

>
>
>
> .         Spell check does not work in Calc although it tells you everything
> is OK and there is no misspelling.

Spellcheck works here. Make sure you have installed the dictionaries and 
your cell style has set the correct language.

>
>
>
> .         I have a file with multiple sheets.  In one file, sheet #2 shows
> data, but it is blank in page preview and will not print.  Yet the data is
> right in front of me.

Then you have set a print range somewhere. Delete all print ranges to 
get all used cells automatically or set print ranges for all cells you 
want to print.

>
>
>
> .         The header and footers drive me nuts.  I can't turn off the header
> "Sheet 1" nor the footer "Page 1".

They are enabled/disabled in the page style. Disable them in the page 
style "Default" and use such spreadsheet document as default template.

   I have to go into every sheet and delete
> them every time I open a spreadsheet.  If you can turn them off or make a
> default, your Help button doesn't know it.  And, if I do delete them and
> later want to add a header, I can't.  The header and footer are grayed out
> in "Edit" and cannot be added under "Insert".  What is the deal???
>

The item in the Edit menu is only for the content of header and footer. 
You have to enable/disable header/footer first in the page style.

>
>
> I will write more when I remember the other irritations of Calc.

You will find it less irritating, when you become more familiar with 
styles and templates. Do you know already the "Getting started" guide 
and the Calc tutorial?

Kind regards
Regina


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org