I have a column of numbers, some of which are strictly integers and others which have non-zero fractional digits.
In the “other” spreadsheet program, I would be able to apply a format of ‘#,##0_._0_0’ to request that space for a decimal point and two fractional digits be reserved, but not printed; with horizontal-alignment of “right” the above format would align correctly with numbers formatted at ‘#,##0.00’.
However, with Calc, the _ formatting directive doesn’t seem to work. It allows me to create a user-defined format, but when the document is saved and then reloaded, all formats with the _x type of directive are replaced with modified formats that have trailing quoted spaces instead of the _x directive(s). And the number of spaces does not seem to be correct for ensuring vertical alignment.
Is there some other way I should format these numbers?