entering the fraction 73/200 (which is 0.365) by entering "0 73/200" displays 3/8 afterwards, which is 0.375 Is this some kind of rounding problem? can this be turned off? Or is this a bug in the code that "automatically reduces" fractions? https://help.libreoffice.org/Calc/Entering_Fractions I'm Running Linux Mint 17.1 with LibreOffice: Version: 4.2.7.2 Build ID: 420m0(Build:2)
Hello, use your own format # ??/??? See the last paragraph in the help. When I use format of cell # ??/???, calc display 73/200 and value is 0,365 I'm closing this as notabug, set to unconfirmed again if you still observe the bug.
Reopen because 3 or more digits (???) for divisor is not retained after saving. Cell formatted # ??/??? as suggested. Works untill spreadsheet is closed. Closed and reopened: cells show default # ??/?? format.
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 88562ee6e352b5446bb55e906e8f1c2f34035a49 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-16_23:58:11
Created attachment 112629 [details] Sample file Attached file open for me with three places for divisor, several versions. Last Win7x64 Version: 4.5.0.0.alpha0+ Build ID: b3b4bbaf6cbd2226b659fea7d6ae473ccf84e9dd TinderBox: Win-x86@39, Branch:master, Time: 2015-01-12_06:13:44
(In reply to m.a.riosv from comment #4) > Created attachment 112629 [details] > Sample file > > Attached file open for me with three places for divisor, several versions. > Last Win7x64 > Version: 4.5.0.0.alpha0+ > Build ID: b3b4bbaf6cbd2226b659fea7d6ae473ccf84e9dd > TinderBox: Win-x86@39, Branch:master, Time: 2015-01-12_06:13:44 # ???/??? works # ??/??? doesn't work Could you test?
Yes as you comment. I don't know maybe is mandatory both sides having the same lenght.
See also question here https://ask.libreoffice.org/en/question/59529/inserting-fractions-in-the-calc-cell/?answer=59616#post-id-59616 Tested # ??/??? in LO 5.0.2.2 which is still not saved in .ODS.
Created attachment 123328 [details] File with fraction formatting differences Cells D32 to D42 contain the formatting I have questions about
When exporting, same value (nPrecision) is stored for both nNumeratorDigits and nDenominatorDigits. See call with WriteFractionElement_Impl http://opengrok.libreoffice.org/xref/core/xmloff/source/style/xmlnumfe.cxx#1467 WriteFractionElement_Impl( nInteger, bThousand, nPrecision, nPrecision, nDenominator ); http://opengrok.libreoffice.org/xref/core/xmloff/source/style/xmlnumfe.cxx#WriteFractionElement_Impl void SvXMLNumFmtExport::WriteFractionElement_Impl( sal_Int32 nInteger, bool bGrouping, sal_Int32 nNumeratorDigits, sal_Int32 nDenominatorDigits, sal_Int32 nDenominator )
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8f8fa5674d3853ed8ca6762b512e6b63c53f1039 tdf#88657 calculate denominator length It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ed4410850af1e62a27db10d5f15ad98c50dedce5 add test for tdf#88657 It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.