Dan
Thanks for the reply
The reason i want more than 365 columns is so that i can layout the rotas
for all 20 people with one person per row.This makes it easier to see other
peoples holiday booking and how they intereact with each other .
Having seperate pages increases the complexity of viewing the whole
"picture"
With so many rows and so few cols is it not possible to swap some rows for
cols ?
Again
Thanks for the reply
Pete Atkin
----- Original Message -----
From: "Dan Lewis" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: "Peter" <[EMAIL PROTECTED]>
Sent: Wednesday, November 29, 2006 6:12 PM
Subject: Re: [users] spreadsheet
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]
