Description: I have a simple =SUM(E5:E66) in E67. The (right) result is 1.468. The worksheet is saved in ods format. A friend that uses Excell reads a smaller number because the values of two cells are not summed. He sees the same range that I See, containing the 2 cells. If I save the file in xlsx format he has the same problem Actual Results: Wrong sum when the file is read by Excell Expected Results: The right value for the sum Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.6.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: it-IT (it_IT.UTF-8); UI: en-US Calc: threaded
Created attachment 184529 [details] A simple ods worksheet with a sum that gives the wrong result when read by Excell
You have defined the data range 'dati' (Menu/Data/Define database range) with the option 'Contains columns labels' marked, so excel takes the first line of the range as column labels, converting E5 to text. Deselect it so excel opens fine in both file types.