You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Anthony Roske <an...@yahoo.co.uk> on 2015/12/29 21:19:50 UTC
My Preference For Version 3.4.1 of OpenOffice
I found that with both version 4.1.1 and 4.1.2 of OpenOffice the basic spreadsheet used cells that were incredibly small and the text size was equally small to fit the cells. This led me to have to reformat the sheet prior to use so that I could see what I was doing.
I have therefore reverted to version 3.4.1 which does not have this "problem". Furthermore this version has an constant SUM function at the bottom of the screen which automatically shows the total of whichever cells have been selected. I find this very useful.
I will watch for future versions to see if the above have been remedied.
A. Roske
Re: My Preference For Version 3.4.1 of OpenOffice
Posted by Rory O'Farrell <of...@iol.ie>.
On Tue, 29 Dec 2015 20:19:50 +0000 (UTC)
Anthony Roske <an...@yahoo.co.uk> wrote:
> I found that with both version 4.1.1 and 4.1.2 of OpenOffice the basic spreadsheet used cells that were incredibly small and the text size was equally small to fit the cells. This led me to have to reformat the sheet prior to use so that I could see what I was doing.
> I have therefore reverted to version 3.4.1 which does not have this "problem". Furthermore this version has an constant SUM function at the bottom of the screen which automatically shows the total of whichever cells have been selected. I find this very useful.
> I will watch for future versions to see if the above have been remedied.
> A. Roske
The scaling of the spreadsheet is controlled by a little slider at bottom right on OpenOffice window, or by double or right clicking in the % box at bottom right hand corner and selecting a preferred scaling factor. "100%" or "optimum" are good starting points.
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: My Preference For Version 3.4.1 of OpenOffice
Posted by Maurice Howe <ma...@gmail.com>.
You might also want to try WRAP if cells have multi-word strings, or
"foldable" arithmetic strings.
Maurice Howe
On Tue, Dec 29, 2015 at 3:19 PM, Anthony Roske <an...@yahoo.co.uk>
wrote:
> I found that with both version 4.1.1 and 4.1.2 of OpenOffice the basic
> spreadsheet used cells that were incredibly small and the text size was
> equally small to fit the cells. This led me to have to reformat the sheet
> prior to use so that I could see what I was doing.
> I have therefore reverted to version 3.4.1 which does not have this
> "problem". Furthermore this version has an constant SUM function at the
> bottom of the screen which automatically shows the total of whichever
> cells have been selected. I find this very useful.
> I will watch for future versions to see if the above have been remedied.
> A. Roske
Re: My Preference For Version 3.4.1 of OpenOffice
Posted by Johnny Rosenberg <gu...@gmail.com>.
2015-12-29 21:19 GMT+01:00 Anthony Roske <an...@yahoo.co.uk>:
> … … …
I have therefore reverted to version 3.4.1 which does not have this
> "problem". Furthermore this version has an constant SUM function at the
> bottom of the screen which automatically shows the total of whichever
> cells have been selected. I find this very useful.
>
I also find that useful. I use it all the time – with Apache OpenOffice
4.1.1. It's located at the left side of the zoom bar, I think it's the same
position as in 3.4.1, so I'm not sure you didn't seem to have it. Also, if
I right click the SUM field, I can select other things, like Maximum value,
Minimum value, Average and so on.
Kind regards
Johnny Rosenberg
> I will watch for future versions to see if the above have been remedied.
> A. Roske