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]

Reply via email to