https://bugs.documentfoundation.org/show_bug.cgi?id=77834
--- Comment #25 from m_a_riosv <[email protected]> --- (In reply to b. from comment #24) > Just as here is activity ... > one cell say A1 with > '100000000001, with the leading apostrophe, another say A2 with > '200000000002, with the leading apostrophe, and the calculations: > " = A1 + A2 " resulting in 300000000003, while > " = SUM( A1 : A2 ) " -> 0 is nothing I want to read documentation > about, it's a simple silly fail in keeping "consistency" alive. > ..... Because ranges doesn't convert the strings in their possible values, it only happens with direct references. And depending on the values in Menu>Tools>Options>LibreOffice Calc>Formula>Detailed calculation settings. -- You are receiving this mail because: You are the assignee for the bug.
