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.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
