https://bugs.documentfoundation.org/show_bug.cgi?id=100593

--- Comment #6 from Nadith Malinda <[email protected]> ---
@ Laurent BP 
so what you said is implement a new format code like (lets take 16 here this
can be change too... no?)
 # ?/16# - which does reduced fraction even with forced denominator

if we choose Format > Cells > Numbers, Category: Fraction as this code

it will give output as you mentioned. as example 
having setup format like you said in Format > Cells > Numbers, Category to #
?/16#
then if we enter 
3.3125 -> 3 5/16
3.5    -> 3 1/2
3.45   -> 3 7/16
3.25   -> 3 1/4
1.0625 -> 1 1/16
1.125  -> 1 1/8

simply if if the fraction part can be reduce output should be in  reduced
fraction form
if not it should be in forced denominator form. in this case in  x/16 where x
is not divided by 16

is that you want....?

if so I would like to try this bug

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to