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.
You can use a question mark ‘?’ instead ‘0’ or ‘#’, but I think only used in combination with a Monospaced font, you can get the desired result.
More information in this bug report FDO#90684