At 07:39 08/07/2007 -0700, Chris Shaffer wrote:
>> Is there any way to tell Calc to draw the black border on top of
>> the white border? As best I can tell, the vertical borders
>> always take precedence.
>
>There does not appear to be, probably because people want the
>vertical lines dominate rather than the horizontal lines. If you do
>black vertical and white horizontal you get what you are after.
Not exactly. That would only work if I could rotate my entire
spreadsheet 90 degrees.
What I'm after is a way to make the horizontal lines dominant.
You might have thought you were joking when you mentioned the
possibility of rotating your spreadsheet. But not so. I had thought
when you first enquired of offering this as a rather cumbersome
workaround, but hoped someone would offer a better solution.
If there is nothing better, you could indeed construct your
spreadsheet sideways. Text can be rotated to suit and all the
options of alignment seem to be available, albeit perhaps in slightly
different places. All you have to do then is swap portrait for
landscape and your output should look as you want it. What you have
done is to hoodwink Calc into thinking your horizontal borders are
vertical ones and vice versa.
Oh, and you may be able to start the whole thing off by copying the
existing material and then pasting it using Paste Special, but
selecting Transpose from the Options list. This will move everything
about so that what were rows are now columns and vice versa, but will
leave you with an enantiomorph of what you actually need. You just
need now to reverse the order of your new rows. I can think of three
ways to do this: you could do it manually, you could reconstruct the
formulae that produced the cell values so that the appropriate values
arrived in the correct cells, or you could add an extra temporary
column of integers in order and then sort on these before deleting
the column. The best solution depends on the detail of your work.
There will no doubt be some things that don't quite work: headers and
footers would appear at the sides of your page, so will presumably be unusable.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
