Entering more than two decimal places in floating point column

[annoywife]

I feel like I am missing something very basic here: I’ve added a custom column with Column Type “Floating point numbers”, but I can only enter a max of two decimal places via the GUI. However, when I write directly to the database via a plugin/script, the field is capable of holding many more (e.g. when setting the custom column to format {0:.13f}, I can see precision to 13 decimal places).

Is there any way for me to enter more than two decimal places manually via the GUI?

[theducks]

13 is the whole number portion

13.3F would have 3 decimal places (and 9 whole digits)

[BetterRed]

Originally Posted by theducks

13 is the whole number portion

13.3F would have 3 decimal places (and 9 whole digits)

R U Sure ?



The Reading Ease value was calculated by Count Pages.

BR

[theducks]

Originally Posted by BetterRed

R U Sure ?

Attachment 193255

The Reading Ease value was calculated by Count Pages.

BR

Nope!
that was what I use in a save template. I don't format columns very often.

[chaley]

Originally Posted by annoywife

I feel like I am missing something very basic here: I’ve added a custom column with Column Type “Floating point numbers”, but I can only enter a max of two decimal places via the GUI. However, when I write directly to the database via a plugin/script, the field is capable of holding many more (e.g. when setting the custom column to format {0:.13f}, I can see precision to 13 decimal places).

Is there any way for me to enter more than two decimal places manually via the GUI?

No. The float field GUI widgets are limited to 2 decimal places. You can probably get around this using the Action Chains plugin instead of the built-in GUI widgets to present an edit widget then store the result in the database.

Originally Posted by theducks

13 is the whole number portion

13.3F would have 3 decimal places (and 9 whole digits)

The formatter does what @theducks says. For example, this template

{:>13.3f:'300/2.1'}

produces 142.857.

Originally Posted by BetterRed

R U Sure ?
Attachment 193255

The Reading Ease value was calculated by Count Pages.

BR

You are mixing things. The format template is used when displaying the number. The 2-decimal-digit format is used in edit widgets. See the attachments.

[annoywife]

Got it! Formatting strings change how a number is displayed, but have no effect on the number's actual value or on how the GUI allows/requires entry (such as only allowing two decimal places) - this is determined by the configuration of each GUI widget in the Calibre code.

Thanks to everyone for your quick and helpful responses - very much appreciated!

[chaley]

You can now specify the number of decimal digits allowed when editing a float in the custom column type editor.

[ownedbycats]

Just curious: Is there an option for unlimited numbers? Though I could see it causing issues, and I imagine an arbitrary high number like 99 would work just as well.

[chaley]

Originally Posted by ownedbycats

Just curious: Is there an option for unlimited numbers? Though I could see it causing issues, and I imagine an arbitrary high number like 99 would work just as well.

Nope. The range for decimals (digits after the decimal point) is 1 to 9.

[BetterRed]

Originally Posted by chaley

You can now specify the number of decimal digits allowed when editing a float in the custom column type editor.

BR