You can rotate the text in each cell by 90°, then use rows as columns and columns as rows. Just don't forget to also rotate your screen by 90°, and you also have to remember that your columns now will be numbers counting backwards (1 jan at A365 or something like that) instead of letters…
I wonder what you will do with 29 feb. Include it every year, just not filling it in, or only include it every fourth year? Yes, I know, not a very good tip, but at least I tried… Johnny Andersson 2006/11/29, Peter <[EMAIL PROTECTED]>:
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]
