On 27/11/2007 17:54, Elchanan wrote:
How can one insert a tab character into a Calc cell?
Elchanan
The *only* way I've found so far is really horrible:
Create a blank document in a text editor (Notepad, vi, whatever) and
enter a tab character. Select this tab character and copy it to the
clipboard. Go to the relevant place in the Calc cell's input line and
paste from the clipboard. Turns out you can use Writer as your "text
editor" if you like.
I've tried using Regular Expressions in Calc but that's no good. For
example, with REs turned on, changing XX to X\tX *should* insert a tab
between the two X's. Works in Writer, not in Calc.
Ahhhhh. "Insert>Formatting Mark>Non-breaking space" will insert a single
non-breaking space; repeat as necessary :-( The cursor needs to be
positioned at the right place within the text input line.
PLEASE someone tell me there's a better way.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]