The report builder report shows wrong (1899-12-30) date instead of Today(), and time 00:00 instead of Now() current value. See attached file, open report for edit, I put date/time into header/footer and details area, the fields in Details, shows correct date/time values. This error is a reincarnation of some old bugs from report builder past. This not happens in LibO 3.6.4, regression.
I have tested with Version 4.0.0.0.beta2+, Branch:libreoffice-4-0, Time: 2012-12-28_12:46:28 and a linux-rpm-32bit-system. I can't confirm this behavior. Have tested to insert Today() and Now() by Insert → Date and Time Have done this in pageheader and -footer, reportheader and -footer and groupheader. All the same right date and right time.
"See attached file" - no attached file, please attach document and reopen as REOPENED :) Thanks for reporting
Created attachment 72771 [details] bugdoc with report This database created in LibO 4 beta2, see report.
reopen.
I opened the report with Version 4.0.0.0.beta2+ Time: 2013-01-07_14:50:57. I could see a blue and a grey area with the actual date and time, date is formatted "10.01.13". Then I could see yellow areas with actual date and time, date formatted "2013. 1. 10." I opened the report for editing. Seems, that all dates have been formatted as the dates in the yellow areas ("Detail"), but the formatting is ignored in the header and in the footer. I couldn't format it as "Hungarian" - its still shown as "German" because of the local settings. Could this be a part of the problem?
Created attachment 72773 [details] report header screenshot
Created attachment 72774 [details] report footer screenshot
all date formatted as YYYY". "M". "D. The extra quotation marks in format I subitted in separate bug: 58797.
Created attachment 72789 [details] Date and time of attachment 72771 [details] - shown on linux 32bit rpm. I don't see any quotes in the date-format. Which java-version do you use? I use 1.6.0_29 on linux 32bit rpm
Java 1.6.37, same with 1.7.10. May be it is a windows problem. Wait until someone other can test it under windows, and with other locale than Hungarian, may be it is Hungarian only or windows only bug. Quotes is another bug.
Created attachment 72838 [details] Screenshot Mac OSX 10.8.2 Hi, can't reproduce either... See attached screenshot. Tested with Mac OSX 10.8.2 and LibreOffice Versie 4.0.0.1 (Bouw-id: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799) TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time: 2013-01-09_10:49:53
Can't test this bug any longer until bug 58371 (https://bugs.freedesktop.org/show_bug.cgi?id=58371) is fixed.
Created attachment 72951 [details] bugdoc with report I created in oroginal bugdoc a new report in RC1, the page header and footer contains wrong date. The bugdoc saved with new name.
Still can't confirm using Mac OSX 10.8.2 with LibreOffice Version 4.0.0.1 (Build id: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799) TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time: 2013-01-09_10:49:53
Created attachment 73019 [details] First page in LibreOffice 4.0 RC1; Can't reproduce
Created attachment 73020 [details] Second page in LibreOffice 4.0 RC1; Can't reproduce
Created attachment 73023 [details] newly cretaed database in RC1 I not argue that it can't be reproduced under Mac, it can be a windows platform only bug.
Change platform to windows.
Created attachment 74105 [details] windows dates and times screenshot Jorendc asked me to test this as I use Windows. I tested on W8 pro 32 bit, x86. I opened the two reports in "72023 newly created database in RC1." The dates in the header and footer are indeed incorrect - see attached screen shot. They should be todays date. I tested using LO 4.0.0.3. I am changing the status accordingly.
(In reply to comment #19) > > I tested using LO 4.0.0.3. > > I am changing the status accordingly. It's also confirmed in the German OpenOffice-Forum. You did assign yourself to this bug. As I understand this you are working to get it resolved, right? Robert
*** Bug 61151 has been marked as a duplicate of this bug. ***
I see this as well on both WinXP and Win8 using v4.0. It's definitely something new with this version as I confirmed the correct behavior using an earlier version (v3.6).
Lionel - believe this one is yours
(In reply to comment #23) > Lionel - believe this one is yours Well... Windows-only bugs are not my area of speciality, and that's a big understatement. (I have no Windows build environment...) The best hope would be to find another developer that *does* have some Windows build environment and experience. I'm willing to collaborate, but cannot do this on my own. (In reply to comment #0) > The report builder report shows wrong (1899-12-30) date instead of Today(), > and time 00:00 instead of Now() current value. > This error is a reincarnation of some old bugs from report builder past. *Maybe*, if you remember or can find out (the more exactly, the better) when (what version, what OpenOffice.org issue number, ...) had this bug and when it got fixed, I could look at the diff and get some inspiration.
One first bug: https://issues.apache.org/ooo/show_bug.cgi?id=93017 Second bug: https://issues.apache.org/ooo/show_bug.cgi?id=100535 Third: https://issues.apache.org/ooo/show_bug.cgi?id=104911
Zoltán, thanks very much for these pointers. I looked into them, and there are my conclusions: Code pointers: http://cgit.freedesktop.org/libreoffice/core/commit/?id=b23505498be71f1ccf1086abe0832234ae34ed93 http://cgit.freedesktop.org/libreoffice/core/commit/?id=350d5ca9803e7e58167b7b5942ebdf429ed9b0af http://cgit.freedesktop.org/libreoffice/core/commit/?id=e200eed28c83326b1639d28f4175f21e52d1cb8c http://cgit.freedesktop.org/libreoffice/core/commit/?id=0db94dbe0a0f79e1c649b681eaa3dbaa065faa64 http://cgit.freedesktop.org/libreoffice/core/commit/?id=3759dd21fb161f9016e5b53756b57a45f25712ed See also: https://issues.apache.org/ooo/show_bug.cgi?id=102432 Is this bug fixed in LibreOffice? Any takers for the bug with these pointers?
@info@ben-wagner.de - please don't change priority without an explanation of why. This policy is in place so that users don't over estimate bugs that affect themselves and thus make our bug tracker not useful for prioritization purposes. Just going into the future please leave comments. thanks!
*** Bug 62894 has been marked as a duplicate of this bug. ***
I changed date-related stuff in Reportbuilder recently... Try with a recent master build or LibreOffice 4.0.3. (Sorry, but since I have no Windows machine, I cannot test myself.)
In fact it is fixed even in 4.0.2. 4.0.1 was the last wrong version.