[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #12 from Kohei Yoshida libreoff...@kohei.us --- (In reply to comment #11) @Kohei: Did you by chance have the Tools-Options-Calc-Calculate Date set to 1904-01-01 when you loaded the document but not when you created it? Nope, it's set to the default option of 12/30/1899. Then I can reproduce the simple test case you attached (submitted as bug 78294), otherwise not. The error Laurent originally described seems to be something different and persists in any case. I get that. But unfortunately the above date issue prevents me from even looking into it or even analyzing the test document. It would be nice for someone to work on reducing the test document to a bare minimum that can still reproduce the problem. Otherwise this one is a bit hard to work on. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #13 from Laurent BP jumbo4...@yahoo.fr --- (In reply to comment #12) It would be nice for someone to work on reducing the test document to a bare minimum that can still reproduce the problem. I'm going to have a look at it tonight. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #14 from Laurent BP jumbo4...@yahoo.fr --- The bug occurs with the following conditions: - MATCH function with type=0 (exact match) - search criterion is formatted as date - search criterion is a formula Create a test case from scratch (see attached file): - create a new spreadsheet - format cell A1 as date - insert formula in A1 =B1 - insert a text in B1 such as test2 - in C1:C3 insert text test1 test2 test3 - in A2 insert formula =MATCH(A1;C1:C3;0) Result is 2 as expected - save file - File Reload = MATCH function returns #N/A Ctrl+Shift+F9 calculates correctly -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #15 from Eike Rathke er...@redhat.com --- (In reply to comment #12) (In reply to comment #11) Did you by chance have the Tools-Options-Calc-Calculate Date set to 1904-01-01 when you loaded the document but not when you created it? Nope, it's set to the default option of 12/30/1899. That's completely odd. I could reproduce your case only when the date was 1904 (check on a newly created empty document) before loading the testcase. Maybe http://cgit.freedesktop.org/libreoffice/core/commit/?id=571cefca474e6b77d68f9fa31f805dcf692927fd also helps your problem anyhow.. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Laurent BP jumbo4...@yahoo.fr changed: What|Removed |Added Attachment #98067|0 |1 is obsolete|| --- Comment #16 from Laurent BP jumbo4...@yahoo.fr --- Created attachment 98582 -- https://bugs.freedesktop.org/attachment.cgi?id=98582action=edit Test case with #N/A result of MATCH function in A2 In attachment 98067 if you change format of search criterion D1 to General, then the bug disappear. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #17 from Eike Rathke er...@redhat.com --- Thanks Laurent! Great analysis! -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #18 from Laurent BP jumbo4...@yahoo.fr --- To reproduce the bug, search criterion could be of *any number format* (not necessary date) different from General: percent, currency, text... Other cell format (font, background, border, etc.) has no effect on the bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |libreoff...@kohei.us |desktop.org | --- Comment #19 from Kohei Yoshida libreoff...@kohei.us --- The new test document looks great. I'll take a look. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #10 from Laurent BP jumbo4...@yahoo.fr --- (In reply to comment #9) This is a date related. I'll put Eike on CC. 4.2 doesn't seem to have this problem. Only master. Hi Kohei, It seems there is two different bugs. * Bug described in comment #0 I can NOT reproduce if I revert to commit 6255be7ca294d350143290c343673f264f42220c Version: 4.2.0.0.alpha0+ Build ID: 10696a254f0cea548a9d06d62c20d37acde2c46f If I cherry-pick next commit 7333881bb7b04f7e4e2a28638024ae82a9c14e81 I CAN reproduce. Then I confirm suggestion of comment #4 and it affect 4.2.* * Bug described in comment #9 This bug does NOT affect any version I tested around the previous commit. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #11 from Eike Rathke er...@redhat.com --- @Kohei: Did you by chance have the Tools-Options-Calc-Calculate Date set to 1904-01-01 when you loaded the document but not when you created it? Then I can reproduce the simple test case you attached (submitted as bug 78294), otherwise not. The error Laurent originally described seems to be something different and persists in any case. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Summary|MATCH function result |MATCH function result |inconsistent between save |changes between save and |and load|load -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #5 from Kohei Yoshida libreoff...@kohei.us --- Created attachment 98318 -- https://bugs.freedesktop.org/attachment.cgi?id=98318action=edit reduced test document I reduced the original test document to just 2 formula cells, on a single sheet. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Attachment #98318|0 |1 is obsolete|| --- Comment #6 from Kohei Yoshida libreoff...@kohei.us --- Created attachment 98319 -- https://bugs.freedesktop.org/attachment.cgi?id=98319action=edit Even more reduced test document. Even more reduced test document. Now it only has C9 as formula cell. Open the document, do hard recalc (Ctrl-Shift-F9), save it, reload it, do hard recalc again, save it, reload it and on and on and on. The value of C9 keeps changing. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 --- Comment #7 from Kohei Yoshida libreoff...@kohei.us --- Actually why is the value of B1 changing on every reload? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Attachment #98319|0 |1 is obsolete|| --- Comment #8 from Kohei Yoshida libreoff...@kohei.us --- Created attachment 98321 -- https://bugs.freedesktop.org/attachment.cgi?id=98321action=edit one ISO date B1 is supposed to be 1977-12-23. When you load this doc in 4.0, it rightly displays 1977-12-13. The file itself contains that date. Yet, when you load this using the master build, it becomes 1973-12-22. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77990] MATCH function result changes between save and load
https://bugs.freedesktop.org/show_bug.cgi?id=77990 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added CC||er...@redhat.com --- Comment #9 from Kohei Yoshida libreoff...@kohei.us --- This is a date related. I'll put Eike on CC. 4.2 doesn't seem to have this problem. Only master. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
