Ask Your Question
0

Calc printing sheet in 000's? Or Millions without "M"

asked 2018-03-17 22:44:24 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Sheets with large numbers.

edit retag flag offensive close merge delete

Comments

Seems cristal ball is broken. Please can you detail a bit, and share a sample file for test.

m.a.riosv gravatar imagem.a.riosv ( 2018-03-17 22:47:22 +0200 )edit

$#.##,,"M";

mywatch gravatar imagemywatch ( 2018-03-21 13:29:43 +0200 )edit

There are some hints here concerning how to ask questions in a way allowing helpers to help without wasting a lot of time.
There is no way in Calc to display the "M" order of magnitude as an M. If you want to get shorter output with good resolution, use the Scientific format, probably in the Engineering variant.

Lupp gravatar imageLupp ( 2018-03-21 18:52:48 +0200 )edit

Thankyou very much!

mywatch gravatar imagemywatch ( 2018-03-25 14:11:48 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-21 17:51:51 +0200

m.a.riosv gravatar image

Instead commas use the thounsand separator.

image description

edit flag offensive delete link more

Comments

Thanks, great help!

mywatch gravatar imagemywatch ( 2018-03-25 14:12:20 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2018-03-25 18:29:41 +0200 )edit

LibreOffice only fully supports as group separators (GS) the comma in locales where the decimal separator is the point and the point in the reverse case. These are exactly the GS explicitly deprecated by ISO 31-0. The standard suggests to use a "small space".
In LibO There is also limited support for some unicode space characters like the ordinary space (U+0020 ; not recommended here) and the NARROW NO-BREAK SPACE (U+202F; recommendable). The limitation lies in additional U+202F.

Lupp gravatar imageLupp ( 2018-03-25 20:21:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-17 22:44:24 +0200

Seen: 28 times

Last updated: Mar 21 '18