https://issues.apache.org/ooo/show_bug.cgi?id=124827
--- Comment #3 from mroe <mroellig.n...@gmx.net> --- (In reply to oooforum from comment #2) > (In reply to mroe from comment #1) > > Lets have the first cell this date and the next are numbers (days). > > SUM( 01.05.2014; 5; 12) = 18.05.2014 (= 41760 + 17 = 41777) > MS-Excel understand this difference. Maybe. But if this is the right behaviour is a question of interpretation. Every "automagic" function have a limited right to exist. > Why not Calc? Calc isn't an Excel-clone. > > For your application it may be not expected, but you can simply resize the > > area fur SUM. > This is not user-friendly if you have a large column or line to calculate. > Did you try it? First you must drop the area and after reduce it. Yes, but this is another issue. Feel free to open a new issue for this behaviour. (Haven't find any for this.) Something like issue 12802. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.