Created attachment 140153 [details] Calc file fraction conversions When entering a decimal into A1 say(0.75),and certain other decimals, and want a fraction in B1, formatted as a fraction (# ??/??), all I get is the number 1(one). Tried to look for an answer online but none conclusive. I will attach an attachment. This is happening on boyh of my laptops, a Gateway, and a Acer aspire, both around 10 or so years old.
Looks the file has something wrong. Select cell B5, on the side bar change the denominator places to one and then to two again and I think it is showed properly.
Hi Rickie, You are using: #" "??/?? as Fraction Format. Enter instead into Format Cells > Fraction # ??/?? or select the first 128 31/68 in the Format list in Fraction Category. Cordially
I tried using the side bar like you said but instead of getting 5/64 in B5 I got 1/9. Going back to two decimal places in B5 rendered a 1(one) again. Also tried reformatting to # ??/?? with out the quotes I had, it did not change the output. I also tried using Libre Office calc in Linux Mint 18.3 from a live USB stick and was able to get the correct answers. There were only two options to choose from in fractions format menu and both worked. One answer was 3/4 the other was 3/ 4. in cell E16 converting 0.75 to a fraction. The 4 moved over one space to the right. Thanks rjs1943
Created attachment 140167 [details] Here is an updated ver of fi,e in question Updated version of ODS fractions ile in question..
For me redo the cell format works fine. Version: 6.0.2.1 (x64) Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89 CPU threads: 4; OS: Windows 10.0; UI render: GL; Locale: es-ES (es_ES); Calc: CL
Created attachment 140171 [details] The change i was proposing Sorry for the inprecision.
Downloaded and opened your attachment 140171 [details] and nothing has changed on my end, still the same. Getting a 1(one) in certain cells. Maybe something is wrong with my installation. On both laptops though? Having the same results on both computers. Even if I start up a new file and put in decimals and format as fractions, still getting a 1(one) on both computers. I'm currently running Ubuntu Mate 17.10 on both. Maybe I'll try and run Ubuntu Mate from a USB live thumb drive which has an ubuntu mate iso file on it and see what happens. I'll try it tomorrow and let you know how it turns out. :) Have a wonderful Evening: rjs1943
Attachment 140171 [details], looks fine for me, please test Menu/Help/Restar on Safe Mode.
Created attachment 140176 [details] LO decimal to fractions
Tried running LO calc in safe mode, still the same result. Enclosed is a new file with 0.75 in cell A1 converting to fraction in cell B1 and still getting a number 1(one) in cell B1. Only 123 2/4 was able to return a 3/4 in cell B1. I need a global format for all cells in the original spreadsheet I uploaded.
Created attachment 140180 [details] Screenshot This is what I see opening your last file, without any change.
Here is a screen shot of the file with the format menu open.
Created attachment 140190 [details] LO calc fractions format menu Here is a screen shot of LO calc fractions
Hi, Your file is broken and need update. Hit Ctrl+Shift+F9 and everything should be good again. Which version did you use to create your file? Date of creation says 2018-02-04T15:50:22
No change after pressing crtl>shift>F9. Just put a couple of blue arrows on two cells. I used ver 5.4.4.2, I think it was. Am now using Version: 6.0.2.1 Build ID: 1:6.0.2~rc1-0ubuntu0.17.10.1~lo1. Thanks for the quick reply.I will upload file.
Created attachment 140230 [details] dec to frac after crtl>shift>F9
(In reply to Rickie from comment #15) > No change after pressing crtl>shift>F9. Just put a couple of blue arrows on > two cells. I used ver 5.4.4.2, I think it was. Am now using Version: 6.0.2.1 > Build ID: 1:6.0.2~rc1-0ubuntu0.17.10.1~lo1. > > Thanks for the quick reply.I will upload file. It seems you did not correctly maintain Ctrl+Shift keys pressed while hitting once F9 key. Your "blue arrows" are for Audit of your spreadsheet, to see which cell is linked to which. They appeared because you hit Shift+F9 and not Ctrl+Shift+F9. By the way, which locale do you use? Could you give the complete content of Help> About LibreOffice?
Created attachment 140234 [details] Libre Office Help content Here is LO help info you asked for. Tried ctrl>shift>F9 again, nothing that I could see happened.
Created attachment 140519 [details] How to add hard recalc to Data - Calculate Please see this screenshot to learn how you can add Recalculate Hard to the Data - Calculate menu. Go to Tools - Customize and do it like in the screenshot. Put recalc in the search. Set Target to Data | Calculate. Select Recalculate Hard and click the arrow button pointing right, OK.
(In reply to Buovjaga from comment #19) > Created attachment 140519 [details] > How to add hard recalc to Data - Calculate > > Please see this screenshot to learn how you can add Recalculate Hard to the > Data - Calculate menu. > Go to Tools - Customize and do it like in the screenshot. > Put recalc in the search. > Set Target to Data | Calculate. > Select Recalculate Hard and click the arrow button pointing right, OK. Dear Reporter, Please follow the steps in comment 19. Closing as RESOLVED NOTABUG