Bug 77165 - BASIC: Difference of days (function days) not longer calculated in Calc
Summary: BASIC: Difference of days (function days) not longer calculated in Calc
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
4.2.2.1 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-08 06:44 UTC by ADR
Modified: 2014-04-11 16:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
No result of function days() (12.73 KB, image/png)
2014-04-08 06:44 UTC, ADR 		Details
the complete file with many days function uses for testing (76.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-11 06:29 UTC, ADR 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description ADR 2014-04-08 06:44:44 UTC 
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
Comment 1 Julien Nabet 2014-04-08 20:44:33 UTC 
On pc Debian x86-64 with master sources (future 4.3.0) updated yesterday, I gave a try.
The interval (day, month, ...) is required.
Comment 2 ADR 2014-04-09 12:59:01 UTC 
@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.
Comment 3 Julien Nabet 2014-04-10 19:32:24 UTC 
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.
Comment 4 ADR 2014-04-11 06:29:14 UTC 
Created attachment 97211 [details]
the complete file with many days function uses for testing
Comment 5 ADR 2014-04-11 12:59:27 UTC 
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.
Comment 6 Julien Nabet 2014-04-11 16:31:29 UTC 
Thank you for your feedback, I put it WFM.