[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-05-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Albrecht Müller changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Albrecht Müller changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Albrecht Müller changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Eike Rathke changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com --- Comment

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Albrecht Müller changed: What|Removed |Added Status|RESOLVED|REOPENED

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #14 from ja...@sortsk.pl --- Maybe simply store amount of seconds in '__int64'. +/- 10 thousand years require only ~330 billions of seconds. There is plenty of room even for fractions (milliseconds, microseconds or

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #13 from Mike Kaganski --- (In reply to jarko from comment #12) which is again offtopic here, since representation of times as fractions of day is industry standard, that is directly used in billions of spreadsheets (e.g. in

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #12 from ja...@sortsk.pl --- All these are consequences of the use of floating point numbers, while best fits integers. -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #11 from Mike Kaganski --- (In reply to jarko from comment #10) > The whole discussion is about what kind of method is preferred when > presenting data: impossible exact binary representation of given number or > exact number

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #10 from ja...@sortsk.pl --- The whole discussion is about what kind of method is preferred when presenting data: impossible exact binary representation of given number or exact number known to user. If

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #9 from Mike Kaganski --- (In reply to jarko from comment #8) > But in example, we have 2 well defined points, strict up to second. Time > lapse is 10 minutes. No more, no less. No need to truncate or round fraction > of

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #8 from ja...@sortsk.pl --- Appreciate your deep and comprehensive explanation. Thank you! At the end let me say little words of my approach. In huge prevailing cases internal arithmetic counting time difference gives us the

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Mike Kaganski changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 ja...@sortsk.pl changed: What|Removed |Added Resolution|NOTABUG |---

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Mike Kaganski changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Albrecht Müller changed: What|Removed |Added CC||albrecht.muel...@astrail.de

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 --- Comment #3 from Mike Kaganski --- (In reply to Aron Budea from comment #2) > Interestingly it displayed 0:10 in both cases before the following commit > (just noting here): > > Use tools::Time::GetClock() in number formatter for

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Aron Budea changed: What|Removed |Added CC||ba...@caesar.elte.hu --- Comment

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 132083] FORMATTING - Wrong date substraction in cell's operation

2020-04-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=132083 Mike Kaganski changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|---