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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.