https://bugs.documentfoundation.org/show_bug.cgi?id=162661
--- Comment #4 from m_a_riosv <[email protected]> --- Created attachment 196096 --> https://bugs.documentfoundation.org/attachment.cgi?id=196096&action=edit Sample file with dates columns in Data as true dates. Converting date columns in Data to true dates, e.g. with Menu/Data/Text to column, works fine. Calc doesn't accept the automatic conversion in Ranges from text to values, only with direct references. And it is not a bug, but by design. =A1*2 ->works =SUM(A1)*2 doesn't work Also, there are options in Menu/Tools/LibreOffice Calc/Formula - Custom (conversion of text to numbers and more) -- You are receiving this mail because: You are the assignee for the bug.
