Re: [users] Re: CALC: Insert tab character

2007-11-29 Thread Harold Fuchs
On 28/11/2007 22:56, Jim Allan wrote: Elchanan wrote: How can one insert a tab character into a Calc cell? Well you can insert one in a way, but as it doesn't do anything in the cell, there’s not much point in it. In the expression box you can type =a CHAR(8) b CHAR(8) c The

[users] Re: CALC: Insert tab character

2007-11-28 Thread Bob Long
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

[users] Re: CALC: Insert tab character

2007-11-28 Thread Jim Allan
Elchanan wrote: How can one insert a tab character into a Calc cell? Well you can insert one in a way, but as it doesn't do anything in the cell, there’s not much point in it. In the expression box you can type =a CHAR(8) b CHAR(8) c The expression CHAR(8) represents the tab

[users] Re: CALC: Insert tab character

2007-11-28 Thread Andy Lewis
Harold Fuchs wrote: On 27/11/2007 17:54, Elchanan wrote: How can one insert a tab character into a Calc cell? Elchanan 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