Re: [users] Re: Calc- reference a bunch cells into 1 cell?

2011-02-19 Thread Johnny Rosenberg

Den 2011-02-19 02:35:20 skrev Harold Fuchs hwfa.gmanen...@gmail.com:



Johnny Rosenberg gurus.knu...@gmail.com wrote in message  
news:op.vq397ls0xqd8ry@pb-laptop...

Den 2011-02-18 21:56:45 skrev . pe...@aleksandrsolzhenitsyn.net:



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

My spreadsheet has a tiny monthly calendar on it that has 1 cell for
each day.  So, it has 7 columns across and 8 rows down.  When you select
the cells it has a range like this-  A1:G8



Erm. Sorry, but where you live do months have 56 days?



I think you should have removed my name above, since you removed  
everything I wrote. Someone would maybe think that I wrote the text above,  
otherwise. Not a big deal, I just wanted to point out that I didn't write  
anything of the above, as far as I can see.


Thanks.

--
Kind regards

Johnny Rosenberg

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



Re: [users] Re: Calc- reference a bunch cells into 1 cell?

2011-02-18 Thread .


On 02/18/2011 08:35 PM, Harold Fuchs wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 My spreadsheet has a tiny monthly calendar on it that has 1 cell for
 each day.  So, it has 7 columns across and 8 rows down.  When you select
 the cells it has a range like this-  A1:G8


 Erm. Sorry, but where you live do months have 56 days?

The month occupies 1 row
The days of the week occupy 1 row, each day is in an individual column
There's a 1 row space between the days of the week and the first day
numbers of the week.

Not all months have the same number of weeks so an extra row has to be
added.

Please, let me know if you know how to solve the problem. 






signature.asc
Description: OpenPGP digital signature