Created attachment 123907 [details] bug is shown by example The summation =sum() does not work combined with the =fixed() function. It works fine for normal numbers. When =fixed() is used to give a number with a fixed amount of decimals, the =sum() function does not recognize the number anymore and does not sum it up. The strange part is that adding the fixed numbers DOES work and give a good result. So in case A1 to A3 are =fixed(1,2), this results in =A1+A2+A3 equals 3, whereas =sum(A1:A3) equals 0. see example file.
Nothing wrong with this. FIXED function help says "Returns a number as *text* with a specified number of decimal places and optional thousands separators." and SUM function ignores text.