| View previous topic :: View next topic |
| Author |
Message |
robbyn
OOo Advocate
Joined: 29 Mar 2004
Posts: 308
|
 Posted: Wed Mar 23, 2005 12:36 pm Post subject: Weekly planner (pictures working) |
 |
|
Using Calc I tried to set up a sheet which just had the half hours down col A and the days of the week across the top. I had switched on the border print. I want the print area to take up all of the paper. I therefore made it bigger than A4 paper and insisted that the print area be reduced down to fit one page of A4 size. I wanted the cells to be a big as possible but for the days and times to just fit. The days of the week and the times are so small that they are unreadable. How can I make them readable again.
Part of Sheet in normal view mode
Part of sheet in preview mode showing what is printed:
_________________
Robin
When you love a delicate rose remember she has thorns and a root. In time the petals will fall away. |
|
| Back to top |
|
 |
Philip Epstein
Power User
Joined: 06 Sep 2003
Posts: 52
|
| Posted: Wed Mar 23, 2005 9:38 pm Post subject: |
|
|
| How about making the columns read Mon, Tue, Wed ... instead of Monday, Tuesday, Wed...? That would allow bigger font size, right? |
|
| Back to top |
|
|
robbyn
OOo Advocate
Joined: 29 Mar 2004
Posts: 308
|
| Posted: Thu Mar 24, 2005 1:27 am Post subject: |
|
|
I have just tried reducing the Days to Mon, etc and it made no difference
_________________
Robin
When you love a delicate rose remember she has thorns and a root. In time the petals will fall away. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Mar 24, 2005 6:31 am Post subject: |
|
|
| robbyn wrote: | | I have just tried reducing the Days to Mon, etc and it made no difference |
Could you give a clue as to column /row width/height you chose please? I'll try to emulate it. just playing around, I made up a sheet that may be similar. I used a font size of Arial 36; day row1 height 0.36", width 3.97"; time rows height 1.94", width 2.32" to accommodate the font. This seemed t0 look OK, but I did only 10 rows, on A4 paper portrait setting, ...Fit to the page.
David. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Mar 24, 2005 6:56 am Post subject: |
|
|
| robbyn wrote: | | I have just tried reducing the Days to Mon, etc and it made no difference |
OK, here's the problem [I think]: You want to keep the same amount of information, but retain the proportions. The fact that you want so many rows gives the problem. So ...
1. Widen your boarders to accommodate. I use 0.25" left and right,; 0.5" top; 0.625" bottom.
2. Widen your columns to 4.75".
At least, that is what I did and it works just fine. Also adjust the font size as already suggested.
David. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Mar 24, 2005 6:59 am Post subject: |
|
|
| David wrote: |
2. Widen your columns to 4.75".
David. |
P.S. If anyone knows of any way to select row/column sets and cause all to change size simultaneously as you change one, I'd appreciate knowing. It may be having to press a CTRL key or something, but that should be unnecessary; all having been selected, all should change as you adjust the one in the selection.
David. |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Fri Mar 25, 2005 2:08 am Post subject: |
|
|
If you select all the columns , put the cursor in the "a,b,c" area
(sorry I dont know a name for it)
and move the cursor to the right edge of a column until a line with two arrows appears ,
-double click - all columns are optimally sized if there is content in them or otherwise the default size is chosen.
or
-drag the column wider or narrower - all selected widen narrow together
This works for rows too.
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri Mar 25, 2005 7:32 am Post subject: |
|
|
| carl wrote: | If you select all the columns , put the cursor in the "a,b,c" area
(sorry I dont know a name for it)
and move the cursor to the right edge of a column until a line with two arrows appears ,
|
Thanks, Carl. I've done that. The problem is that sometimes the magic works and sometimes it doesn't. I've selected a set and ccuased a change, and the change occurred only to the one, nto the set, causing my query. However, I did find a solution: Select the columns or rows, and right mouse height will allow you to set a value which affects all those selected with no problem. It's quite fast enough a process to use all the time.
David. |
|
| Back to top |
|
|
|
