Ask Your Question

Calc: formatting of trailing non-printing digits [closed]

asked 2017-06-03 08:22:43 +0100

PaulG gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-05 23:12:18.721735

1 Answer

Sort by » oldest newest most voted

answered 2017-06-03 09:39:16 +0100 tells that requested functionality must work, but I reproduce your problem with LO

Please file a bug at Bugzilla.

edit flag offensive delete link more


Bug #108338 has been filed.

PaulG gravatar imagePaulG ( 2017-06-05 02:10:21 +0100 )edit

Question Tools

1 follower


Asked: 2017-06-03 08:22:43 +0100

Seen: 46 times

Last updated: Jun 03 '17