Thanks Harold, but, as you say, it is not the same as tabbing. Using a set
number of spaces means the following characters will be placed according to
the number of characters in the preceding word, and the column will not be
left justified.
Thanks for your interest and reply,
James
----- Original Message -----
From: "Harold Fuchs" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, July 17, 2008 11:44 PM
Subject: Re: [users] Tabbing within a Calc cell.?
On 17/07/2008 10:38, James Elliott - WA Rural Computers wrote:
I have a large, merged cell in my invoice spreadsheet template, for
typing messages to customers in. Sometimes I might want to list things
and it would be handy to tab from position to position. For example:
Message:
Invoice date: 1/4/08
Statement: 1/6/08
As you know, if I hit "Tab" then my cursor jumps to the next cell to the
right. I have tried CTRL+TAB, but that doesn't work.
Is there any way to tab within a cell or is that not possible in Calc
spreadsheets?
Many thanks, James
You could use a "magic" character and then change all occurrences of it
to, say, 4 spaces. By "magic character" I mean one that isn't used
anywhere else so that when you change all occurrences of it you won't
affect anything other than the data you want formatted. So, in your
example, you'd enter
Invoice date:!1/4/08
Statement:!1/6/08
and then change every "!" to " ".
I used an exclamation mark just to play before writing this. It's not the
same as tabs but ...
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
