Problem description: Steps to reproduce: 1. Start building report 2. Insert a data field from the data base with x=0.00cm and y=0.00cm in the detail section 3. Insert date field today() anywhere in header or footer 4. The date will display in a report as Saturday, 30 December 1899 5. Set either x or y at 0.01cm or more 6. The date will display correctly in the report Current behavior: Incorrect if both x and y are set at0.00cm Expected behavior: Correct if either x or y set 0.01cm or more This supplements previously submitted error report Operating System: Windows 7 Version: 4.1.0.4 release
Shure that it is the new version LO 4.1.0.4 ? I have just tested with Linux 64bit rpm - there it works right. We had some problems with date in the header and footer under Windows. See https://bugs.freedesktop.org/show_bug.cgi?id=58805 . But this bug might have been fixed. If not we have to reopen it.
Please attach an example database with two reports: 1) One showing the problem. (x=y=0) 2) One showing the correct result (x or y set to 0.01cm or more)
Created attachment 83910 [details] Months.odb Sample database months.odb attached. This has both x and y set at 0.00 and gives a wrong date Report1_x_0.00.odt is the corresponding report saved as an odt file. Day is correct, but date month and year are all wrong at 30 December 1899. Report1_x_0.01.odt is the report when x=0.01. date is correct Alan McKenzie
Created attachment 83911 [details] Report1_x_0.00.odt
Created attachment 83912 [details] Report1_x_0.01.odt
*** Bug 67893 has been marked as a duplicate of this bug. ***
OK, reproduced.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fc92c1abebcfe9b18649d35b76bf22e001e332da fdo#67930 don't use variables for formattedtext in header/footer The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=76408b0f0d7e91cddb8b056069a2ee547109b156&h=libreoffice-4-1 fdo#67930 work around fdo#68024 It will be available in LibreOffice 4.1.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
LibreOffice 4.1.2 was downloaded and run on Thursday 15 August. All reports which had previously resulted in an incorrect date for date() when x=y=0 now produced the correct date in the footer. The same reports are still incorrect when run today with LibreOffice 4.1.0.4 Thanks for a successful fix. Alan McKenzie
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1e10f6d229587ffc2a955c225b489645f8016e23 fdo#67930 work around fdo#68024 It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c582a7b280afc96ecf897356e0885d2bcf289710&h=libreoffice-4-4 fdo#67930 work around fdo#68024 It will be available in 4.4.0.0.beta3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.