erAck, 3 months ago

@slothrop
Assumption: your numbers are not numeric values but just text that looks like numbers, and text is ignored in SUM(). Standard behaviour in all major spreadsheet applications.
To check hit Ctrl+F8 (View -> Value Highlighting) then text content is displayed black, numeric content blue and formula results green.

erAck, 3 months ago

@slothrop
See also https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data

slothrop, 3 months ago

deleted_by_author

stragu, 3 months ago

@slothrop that sounds very serious. Which version? Have you reported it? Would love to test it. I can report it you don't want to but can provide steps.

slothrop, 3 months ago

@stragu Nah, sorry, it was my mistake.

Numbers formatted as text…

Thanks, though.

slothrop, 3 months ago

deleted_by_author