| Summary: | entered fractions misinterpreted; format '# ??/???' is not retained after saving. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Thomas Käfer <h485772> |
| Component: | Calc | Assignee: | Laurent Balland <jumbo4444> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | gerard.fargeot, h3734236, homaka, jumbo4444, miguelangelrv, raal |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:5.2.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Sample file
File with fraction formatting differences |
||
|
Description
Thomas Käfer
2015-01-21 09:53:45 UTC
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. |