Created attachment 150306 [details] This is the spread sheet with the bug manifest. In the attached ods I added a column to the right of column F which is called "Hops (in FV)" and called it "Grain temp". Then, in cell G171, I entered 21 but what appeared was 2121 even though the edit line showed 21. I found that if I cut and pasted the contents of H171 into G171 H171's value (72) appears in G171 correctly and if I then changed the contents of G171 to 21 the cell's contents became 21 - as it should do. So: some weird initialization problem seems to have occurred in cell G171 when I added the column G.
Thank you for reporting the bug. I can confirm that the bug is present in Version: 6.2.1.2 (x64) Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL Version: 6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-08_00:38:10 Locale: en-US (en_US); UI-Language: en-US Calc: CL Steps I have done for cell G171: 1.I have opened attached file 2.deleted data from cell G171 3.I tried to enter 21 in G171 in the input line its showing 21 only but in the cell its appearing 2121 (I have tried entering other 2digit numbers in the input line its showing 2digit number only but in the cell its appearing different ) 4.when I cut and paste the contents of H171 into G171,H171's value (72) appears in G171 correctly and again if I changed the contents of G171 to 21 the cell's contents shows 21
Also reproduced in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 @Eike, do you have any idea why this happens ?
Created attachment 150376 [details] cell properties
that not a bug, it's a feature ;-) please have a look at the attachment