Created attachment 139921 [details] a complex calc time sheet document that show errors loading this calc sheet on Versione: 6.0.1.1 Build ID: 1:6.0.1~rc1-0ubuntu0.16.04.1~lo1 Thread CPU: 8; SO: Linux 4.13; Resa interfaccia: predefinito; VCL: gtk2; Versione locale: it-IT (it_IT.UTF-8); Calc: group italian version on ubuntu 16.04.03 with kernel: Linux jessica 4.13.0-32-generic #35~16.04.1-Ubuntu SMP Thu Jan 25 10:13:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux 1) Columns From AE to AI show a "#VALORE!" error 2) Editing Formula in AD4 doesn't permit change the double ugual sign "==" whith a single one the same sheet open normally on libreoffice calc 5.4 Version: 5.4.4.2 Build ID: 1:5.4.4~rc2-0ubuntu0.16.04.1~lo1 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: it-IT (it_IT.UTF-8); Calc: group I seem to remember that same sheet was opened correctedly in libreoffice 6 until same days ago
What does the *string* "00.30" in AB5 mean? It is supposed to mean time; still for Italy, the "." is thousands separator... is there an unambiguous conversion? You use strings universally for things that must be numbers, times etc. I don't know if this should be treated a bug, but my personal position is that this is user error. One should use "TIME(0;30;0)" and proper cell format (which is already set btw) instead of strings like "00.30" imo.
For information: changes for bug 105226 did a change of the time separator from '.' dot to ':' colon . This is the reason why calculating with the text string "00.30" fails now in an Italian locale and shows once more why such string calculations should not be used. In fact in this case it worked only in an Italian locale, loading the document in a different locale may have failed anyway, and even worse in a locale with '.' as decimal separator and conversion from text to number enabled produces the number 0.3 instead, which if used as time is different from the value for 00:30.