Bug 153213 - [NatNum12] does not handle fractions properly
Summary: [NatNum12] does not handle fractions properly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Number-Format
  Show dependency treegraph
 
Reported: 2023-01-26 09:44 UTC by Mike Kaganski
Modified: 2023-03-24 14:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2023-01-26 09:44:04 UTC
It is impossible to use [NatNum12] with a fractional number format.

E.g., put 0.4 to a cell in Calc, and format the cell using format string "0/0", and it would show "2/5". One could expect that "[NatNum12]0/0" would allow to get (in en-US) "two fifths" or the like, but it shows "two/five" instead.
Comment 1 Buovjaga 2023-03-24 14:42:20 UTC
Repro

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fba19e93cca9a7cdfa1e4ac92291cd0b7f06d715
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 24 March 2023