Issue 23417 - Support for enhanced fraction format in Excel needed. In Excel it is possible to set the format for fraction to a special divisor (e.g ??/16).
Summary: Support for enhanced fraction format in Excel needed. In Excel it is possible...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m17
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, rfe_eval_ok
Depends on:
Reported: 2003-12-10 15:28 UTC by oc
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description oc 2003-12-10 15:28:42 UTC
In Excel it is possible to set the format for fraction to a special divisor e.g
??/16). For inproving the interoperability these formats must be supported in
OOo too.
Comment 1 ooo 2003-12-10 16:48:22 UTC
Comment 2 erwin.tenhumberg 2004-10-27 17:13:00 UTC
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 3 frank 2004-10-28 08:35:24 UTC
Hi Dancer,

never touch an Issue assigned to a developer. Such Issues are worked on
especially if the have the staus started.

Comment 4 frank 2004-10-28 08:36:37 UTC
reset started
Comment 5 sparr 2006-12-23 01:28:03 UTC
this issue has been STARTED for 3 years now.  im having trouble actually
compiling OOo, but i think ive got a hacky way to implement this feature in
about a dozen lines of code and 10 minutes, so im sure a real dev could do it
the Right Way pretty quickly.  i assume it just fell through the cracks.

also, KOffice also has this feature.
Comment 6 ooo 2007-01-03 15:59:44 UTC

Unfortunately the "started" status in this issue tracker just means accepted.
Yes, bad wording, seconded. So, if you have a solution, no matter how hacky you
think it may be, why don't you just attach the patch to this issue, state your
full name, submit a JCA (see ) and let us give it a try?

Comment 7 sparr 2007-01-03 17:25:32 UTC
unfortunately I cant compile a working copy of Base or Calc, so I can't test my
patch.  I guess I could post the *idea* here, as sort of pseudo-code, but it is
VERY hacky.  Basically I added a 'denominator' field to the formatting struct,
added 1-9 as valid digit placeholders alongside '0' '#' and '?', and then
aggregate the numbers into the denominator field when looking for placeholders.
 Then in the output code I check if theres a denominator and if so then output
(Num*Denom)/Denom.  I am going to put a little more effort into getting a
working build environment so I can test myself, if that all fails than I will
put up the untested patch here.
Comment 8 Marcus 2017-05-20 11:13:15 UTC
Reset assigne to the default "".