When entering 1/4 for one quarter into a cell, Calc automatically converts it to 01/04/21. Then, using Format|Cells and selecting Fraction, the entered value becomes 44200.
If, I enter 13/64, the value shown when I select the cell is ‘13/64. Using Edit|Find and Replace… with (’) as the character to replace, the spread sheet reports Err:502.
When 1/4 is entered, 1/4 is expected. And, when 13/64 is entered, 13/64 is expected. It is a case in which “What I do is not what I get!” How can the automatic formatting be completely turned off so that this frustration does not have to be dealt with when using numbers in a calculation spread sheet?
LibreOffice Version: 184.108.40.206
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 2; OS: Linux 4.9; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US