On Wednesday 29 November 2006 02:38 am, Peter wrote:
> People
>
> Firstly thanks for the free software
>
> To improve the spread sheet function can you increase the total
> number of columns that a spreadsheet can have .
>
> I have recently taken over the rota management at work and require
> a spreadsheet that can have more than the number of days in a
> year(ie >365)
>
> Is this possible with OpenOffice ?
>
> Merry Christmas
>
> Pete Atkin
What is wrong with having one sheet per month? That would result
in a file with twelve sheets plus any sheets you want to use for
summaries. And why would you want to have more than a year's entries
on one spreadsheet?
With this large number of entries, you might be better off using
a database instead.
When I checked an empty spreadsheet in OOo, I found 230 columns
and 65,536 rows. So, perhaps you might want to consider interchanging
the rows and columns. Or would you have more than 230 items to enter
for a given day?
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
