Created attachment 97055 [details] No result of function days() Problem description: Steps to reproduce: 1. formate to cells ("CELLONE" and "CELLTWO") in DD.MM.YYYY style and fill them each with a date 2. formate a third cell as number and use (in German) "=TAGE(ZELLONE;ZELLTWO)". (In English the function may have an other name) Current behavior: ### as result, no calculated number as before Expected behavior: the difference between the two dates in number (of days). This was in previous LibreOffice versions calculated correct within the same unchanged document. Operating System: Windows XP Version: 4.2.2.1 release
On pc Debian x86-64 with master sources (future 4.3.0) updated yesterday, I gave a try. The interval (day, month, ...) is required.
@Julien Nabet: Thank you for testing! But sorry: what du you mean with "the interval is required"? The interval is given through the date of cell "D2" substituted from the date of cell "C2". The result was the number of days between this two dates and it worked before in this way. I couldn't detect a change in the arguments needed for the function "days" (in German "tage") in the formula editor.
ADR: indeed I was wrong. Could you attach the file so I'm sure I won't mistake again? On pc Debian x86-64 with master sources (future 4.3.0) updated today, I tried the function "days" and it worked but perhaps I missed something.
Created attachment 97211 [details] the complete file with many days function uses for testing
Ok, here are some knew points I found out: 1) tried out 4.2.2 at another computer - works! 2) the windows profile LibreOffice settings have something to do with the problem: after deleting (German Windows XP) c:\dokumente und einstellungen\<login>\Anwendungsdaten\LibreOffice\ completly, the calculation works! As result, this was a problem of not working LibreOffice settings from previous versions. I dont think, that I changed settings after upgrading to 4.2.2., so may be others who used their old settings can habe some behaviour. Good to know that cleaning the settings helps. Thanks for your answers.
Thank you for your feedback, I put it WFM.