[Libreoffice-bugs] [Bug 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #10 from Commit Notification --- Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b02d05f460fb43424d4288969ea826afc06b66e5 tdf#135249: sc_ucalc: Add unittest It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #9 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/3115faaa72b25bdd3af140d275635b0f0cd06e3a Resolves: tdf#135249 Duration input 0:123 or 0:0:123 or 0:123:59 is valid It will be available in 6.4.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 Commit Notification changed: What|Removed |Added Whiteboard|target:7.1.0 target:7.0.1 |target:7.1.0 target:7.0.1 ||target:6.4.7 -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #8 from Mike Kaganski --- ... at least extending scope of formats to serve as masks, although complex internally (since formats of course are more complex than masks would be, which opens for ambiguity), seems simpler from user PoV, than introducing another cell format category like "input mask", so that users need to handle three things (actual stored data type; display format; input mask) vs existing two (actual stored data type; display format). Additionally, IMO input masks would be largely redundant, almost always being a kind of simplified display formats. -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #7 from Mike Kaganski --- Thanks Eike! A nice change. (In reply to Eike Rathke from comment #4) > (In reply to gabrielhml from comment #3) > > It is also possible that the person writes 1:1:40 but does not mean time > Which can always be prefixed with an ' apostrophe to force text. The same could be told about 1:1:123 ;-) > > but more than that, it would be nice if as a general rule Calc would try to > > conform to the format of the cell. This would apply to other cases too. > That quickly leads into a hell of confusion, the more if empty cells are > formatted already. Number display formats are not input masks. Both PoVs have pros and contras. I don't think that the "hell" would be larger than now, and that comes not from some software problems, but from spreadsheet concept (and tasks it is designed for) complexity, and general human laziness. However, an increase of consistency would be a good thing. We already take formatting into account when treating user input: first when a field is formatted as text; then IIRC times vs durations started to be considered recently ... and that goes against the "Number display formats are not input masks" idea. Personally I support the suggestion to extend consideration of cell formatting when interpreting cell input. Like "first try to treat cell format as kind of input mask; then consider general group of cell format; only then fall back to normal processing". So a format like "DD/MM/YY" would result in considering an input first as DMY; then as date (using configured acceptance patterns); then generic processing (checking numbers, percents, currencies, times, formulas etc...). That would possibly be a major change, and could benefit from having a configuration option, but that seems increasing consistency over current situation (when we declare "formats are not masks, except here, and also here, and again here..."). -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #6 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/bd33e2673b3d97a6f1d7ab16eb8f83faae09d980 Resolves: tdf#135249 Duration input 0:123 or 0:0:123 or 0:123:59 is valid It will be available in 7.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 Commit Notification changed: What|Removed |Added Whiteboard|target:7.1.0|target:7.1.0 target:7.0.1 -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 Commit Notification changed: What|Removed |Added Whiteboard||target:7.1.0 -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 --- Comment #5 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1616b53292cdc22c04d07bb21e71bf43dcd22299 Resolves: tdf#135249 Duration input 0:123 or 0:0:123 or 0:123:59 is valid It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59
https://bugs.documentfoundation.org/show_bug.cgi?id=135249 Eike Rathke changed: What|Removed |Added Summary|If cell is formatted as |Allow duration inputs of |time or duration, then |0:mm or 0:0:ss with values |allow inputs with parts |>59, or 0:mm:ss with mm>59 |greater than 59 | -- 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