Strange sum from number and text For example: A1=1 A2='2 A3=3 A4=SUM(A1:A3) result = 4 correct (for me) A5=A1+A2+A3 result = 6 is correct? Is a bug? For me is ambiguous Note that A6='2 +'3 result Err:509 Thanks
Not a bug, see FAQ https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data#Find_.26_Replace_with_different_
Or rather https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data