How to configure LibreOffice Calc to display a maximum of 10 digits for decimal numbers like Excel?

[cpf]

In Microsoft Excel, when a cell is formatted as “General” and its content is a decimal number, Excel displays a maximum of 10 digits (both before and after the decimal point), with the last digit rounded.

However, when I open the same Excel file in LibreOffice Calc, Calc displays up to 15 digits in total.

Is there a way to configure LibreOffice Calc to behave the same as Excel, showing a maximum of 10 digits in total for decimal numbers?

I have tried the “Limit decimals for general number format” option, but that option only applies to the digits after the decimal point and does not include the digits before the point.

Any advice would be appreciated. Thanks!

[Zizi64]

The LibreOffice uses the double precision floating numbers for the calculations and for the displaing results. It has a dynamic accuracy with about 15 decimal digit.

You can format these numbers to less (10) decimal place in the Calc.
But - I suppose it - you want to format them to 10 significant figure:
6.66666667
66.6666667
666.666667

It is more difficult.
You can use the built-in Engineering format, or you must create your own macro functions.

Number format code to display x significant figures

I know that the number of decimal places can be given by using 0’s. However, I want to be able to display values to 4SF. 1.2345 -> '1.235' 12.345 -> '12.35' 123.45 -> '123.5' 1234.5 -> '1235' 12345 -> '12350' 0.1 -> '0.1000' 1 -> '1.000' 10 -> '10.00' 100 -> '100.0' 1000 -> '1000' Used in combination with this, I want to ultimately be able to express any value in this way: 1.2345 -> '1.235 ' 123456 -> '123.5k' 12345678900000 -> '12.35T' 0.0000012345 -> '1.2…

How can I get LibreOffice Calc to calculate significant figures automatically?

LibreOffice uses IEEE 754 64-bit floating point representation for all numbers, both integer and digital. See Floating-point arithmetic Decimal numbers like 0.1 and 0.2 cannot be represented exactly in binary systems. The decimal number 0.125 can be represented exactly as it is a binary (1/8). This is how IEEE 754 64-bit, used on all PCs, represents 0.125 and the three following numbers. Note that 0.125 = 1/8 and is represented exactly. The next numbers, obtained by incrementing the bi…

[Villeroy]

Tools>Options>Calc>Calculate… “Limit decimals for general number format”
The settings on that dialog page are a per-document settings. In order to make this a general setting:
FIle>Templates>Save…
File>Templates>Manage… right-click the template and make it your default template.