[Libreoffice-bugs] [Bug 93323] [HH]:MM Time Format shows incorrect value for hours over 24h in German locale
https://bugs.documentfoundation.org/show_bug.cgi?id=93323 Alexander Nolting a.nolt...@almano.de changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTABUG |--- Ever confirmed|0 |1 --- Comment #2 from Alexander Nolting a.nolt...@almano.de --- Hello Gerard, let me recap this: I tried to change the cell format for column E from HH:MM to [HH:MM]. In the Cell Format dialog under User defined (Benutzerdefiniert in German) I antered [HH:MM]. The dialog change the Category to User defined but does not!!! allow to add and save this format as it's not an allowed format. The format after clicking OK reverts to HH:MM. Nothing changed in D36. I changed for E5 the value from 00:30:00 to 1 and exits the cell. The cell shows now 00:00 and after entering the cell again for editing it show 24:00:00. As for now correct. But in D36 the value is now -71:30. Not correct. In cell F5 the value is still 8:45 - also not correct: should -16:15 or an 00:00 if the cell format does not allow to present negative time values. And last [HH]:MM should show accumulated hours. So the Bug is not fixed. -- 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 93323] [HH]:MM Time Format shows incorrect value for hours over 24h in German locale
https://bugs.documentfoundation.org/show_bug.cgi?id=93323 --- Comment #3 from GerardF gerard.farg...@orange.fr --- Sorry, it's my fault: I should have wrote [HH]:MM instead of [HH:MM]. Format cells E5 to E35 with [HH]:MM (same as D36) Cells in F shows the modulo 24:00 of the calculation. To see negative hours, you need [HH]:MM format. -- 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 93323] [HH]:MM Time Format shows incorrect value for hours over 24h in German locale
https://bugs.documentfoundation.org/show_bug.cgi?id=93323 Alexander Nolting a.nolt...@almano.de changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |NOTABUG --- Comment #4 from Alexander Nolting a.nolt...@almano.de --- Hello Gerard, sorry, havent seen that the E column value wasn't copied but accumulated. Thanks for your help! Alex -- 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 93323] [HH]:MM Time Format shows incorrect value for hours over 24h in German locale
https://bugs.documentfoundation.org/show_bug.cgi?id=93323 GerardF gerard.farg...@orange.fr changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||gerard.farg...@orange.fr Resolution|--- |NOTABUG --- Comment #1 from GerardF gerard.farg...@orange.fr --- Select column Pause and format as [HH:MM] and you will see the cause of D36 result. Filling cell with numeric value increment this value by 1, so 0:30 becomes 24:30, 48:30 etc… If you want to copy down the same value, hold the Ctrl key while dragging the fill handle. -- 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