Harold Fuchs wrote: > 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.
But multiple spaces are not tabs. I see that the help (inserting;tab stops) mentions: "If you want to change the settings of your default tab stops, you will find further information under Tools - Options - OpenOffice.org Calc - General." But how and where is that used, especially if tabs themselves can't be entered? > PLEASE someone tell me there's a better way. I hope so! -- Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
