resolution of table number format issues

unable to file bug report. if i select a number of cells, clear direct formatting, & table number format 2 decimals, no leading zero, & #.## the result is unpredictable. all I’m trying to do is align numeric info on the decimal point & suppress leading & trailing decimal zeroes in a manner that allows spreadsheet functions. current LO & win 7. no provision here to attach a file. bugzilla’s security requirement is at best questionable. thanks for any help you can provide.