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