On Sunday 20 April 2014 18:39:05 you wrote: > On Sunday 20 April 2014 18:12:49 you wrote: > > At 16:34 20/04/2014 -0800, Greg Madden wrote: > > >I am using AOO v 4.0.1, Debian Wheezy, Linux. I create a table in > > >writer, select a range of cells, apply number formating. the > > >'currency' number format. The cells are empty, data gets entered > > >later. Formatting only works if there is a number in the cell. > > > > To achieve what you want, you need to tick Tools | Options... | > > OpenOffice Writer | Table | Input in tables | Number recognition. > > You may want to experiment with whether you also need to tick Tools > > | Options... | OpenOffice Writer | Table | Input in tables | Number > > format recognition: no-one can explain what this does - not the > > help text or even the manual. > > > > I trust this helps. > > > > Brian Barker > > Thank you, that works
Another benifit, with number format recognition checked I no longer get dialog boxes when I select>delete cell contents. The default cell format is 'text' which produces a dialog box when deleting contents, asking a number of questions on what formating needs to be deleted. Simplified work flow...yea. -- Peace, Greg ------------------------------------------- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
