Ask Your Question
0

Calc: formatting of trailing non-printing digits

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-03 09:39:16 +0100

https://help.libreoffice.org/Common/N... tells that requested functionality must work, but I reproduce your problem with LO 5.3.3.2.

Please file a bug at Bugzilla.

edit flag offensive delete link more

Comments

Bug #108338 has been filed.

PaulG gravatar imagePaulG ( 2017-06-05 02:10:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 29 times

Last updated: Jun 03 '17