[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED OS|Linux (All) |All Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #9 from Eike Rathke --- Fwiw, processing "0:66" as time value is possible with =VALUE(RIGHT("0:66";2))/24/60 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #8 from Eike Rathke --- TIMEVALUE() uses the number parser's input detection, we maybe could tell it to lax it in this case and accept the dirt the user throws at it as being intentional. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #7 from Mike Kaganski --- (In reply to Xisco Faulí from comment #6) > Not sure whether it's a regression, since the commit changed value greater > than 59 not to be time, however the value is displayed correctly in MSO 2010 Of course it is not; and of course the original description is over-optimistic declaring "0:66" a "correctly formatted time text string". But yes, it's an interoperability issue (that might need a fix on a specific function level, to avoid treating invalid times in general, but still allow in the TIMEVALUE function where they are told explicitly to be times). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 Xisco Faulí changed: What|Removed |Added Keywords|bibisectRequest |bibisected, bisected Version|6.4.3.2 release |6.4.0.0.alpha0+ --- Comment #6 from Xisco Faulí --- The issue started to happen after https://cgit.freedesktop.org/libreoffice/core/commit/?id=7d72b9d34c1183b7471a7a97c007aba10de2d27e author Eike Rathke 2019-10-18 19:35:47 +0200 committer Eike Rathke 2019-10-18 23:44:09 +0200 commit 7d72b9d34c1183b7471a7a97c007aba10de2d27e (patch) treef4f1b1a5a2a5c184626f3efef83277416c157c4f parent b3f67f9887e30240292b2f40c64161ed53281795 (diff) Input with subsequent part greater than 59 is not time or duration Not sure whether it's a regression, since the commit changed value greater than 59 not to be time, however the value is displayed correctly in MSO 2010 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #5 from Xisco Faulí --- Created attachment 162586 --> https://bugs.documentfoundation.org/attachment.cgi?id=162586=edit Comparison MSO 2010 and LibreOffice 7.1 master -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 Telesto changed: What|Removed |Added Keywords||bibisectRequest -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 Mike Kaganski changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW CC||er...@redhat.com --- Comment #4 from Mike Kaganski --- Confirmed in Version: 6.4.5.2 (x64) Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6 CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: CL OASIS OpenDocument 6.1.18 tells: > TIMEVALUE > Summary: Returns a time serial number from given text. > > Syntax: TIMEVALUE( Text T ) > > Returns: Time > > Constraints: None > > Semantics: This computes the serial number of the text string T, which is a > time, > using the current locale. This function shall accept ISO time format > (HH:MM:SS), > which is locale-independent. If the text of T has a combined date and time > format, > e.g. -MM-DD HH:MM:SS, the fractional part of the date serial number is > returned. > If the text of T does not have a time format, an evaluator may attempt to > convert > the number another way (e.g., using VALUE), or it may return an Error (this is > implementation-dependent). > > See also TIME 6.10.17, DATE 6.10.2, DATEVALUE 6.10.4, VALUE 6.13.34 As I read it, it accepts *a* time format (see the "If the text of T does not have a time format"), so the requirement to accept ISO time format is not exclusive, but a minimal requirement, not denying accepting other formats like non-ISO "0:66". Additionally, there's an explicit provision that the value may be converted using *another* (unspecified) way (and an example given, which again is not exclusive). This issue creates interoperability problem, since e.g. MS Excel 2016 accepts such values, thus formulas working in Excel don't work in Calc. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #3 from aplatypus --- Created attachment 162581 --> https://bugs.documentfoundation.org/attachment.cgi?id=162581=edit Screenshot of correct behaviour using: v6.3.4.2. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #2 from aplatypus --- Created attachment 162580 --> https://bugs.documentfoundation.org/attachment.cgi?id=162580=edit Screenshot of error using: v6.4.3. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION
https://bugs.documentfoundation.org/show_bug.cgi?id=134455 --- Comment #1 from aplatypus --- Created attachment 162579 --> https://bugs.documentfoundation.org/attachment.cgi?id=162579=edit Sample spreadsheet to reproduce the bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs