On Mon, 19 May 2008 20:21:17 +0100 Brian Barker <[EMAIL PROTECTED]> dijo:
> At 09:09 19/05/2008 -0700, John Jason Jordan wrote: > >Using OOo 2.4 Writer on Ubuntu. > > > >When I select cells in a table and apply a number format the > >formatting does not take unless there is a number already in the > >cell. You cannot apply number formatting to empty cells. This makes > >it really tedious to enter data in the cells - you have to format > >after each number as you enter it. > > > >Is this by design? Have I failed to do something right? Or is it a bug? > > This (at least on my Windows version) is not so. You can apply the > number formatting first, but you have to set an option which is not > on by default. > > o Go to Tools | Options... | OpenOffice.org Writer | Table | Input in tables. > o Tick "Number recognition". > o (Probably) ensure that Alignment is not ticked. > > Your choice for "Number format recognition" doesn't matter if what > you enter into the cell is a real number that fits your preset > formatting. But if this option is not ticked and you enter something > in error that is not a true number, the number format for that cell > is reset to Text. Even if you then correct your mistake, the number > formatting has been lost. So it is probably useful to tick this option too. Thanks. Your guess was correct. "Number Recognition" was not checked. After I checked it the table worked properly. Another question is why this box is not checked by default. But at least I have it fixed now. Thanks again. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
