[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2023-04-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

--- Comment #5 from Eike Rathke  ---
So what do you expect? We introduced some special handling for subtracting
date+time formatted values to yield better results, and these 44749.33
and 44749.354167 are not exact (neither decimal nor binary floating point)
numbers, and displaying the result from this calculation in time format is
slightly off. Yes.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2023-04-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

BogdanB  changed:

   What|Removed |Added

 CC||buzea.bog...@libreoffice.or
   ||g
 Blocks||107575


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107575
[Bug 107575] [META] Number format bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

  Regression By||Eike Rathke
 CC||79045_79...@mail.ru

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

Xisco FaulĂ­  changed:

   What|Removed |Added

   Keywords|bibisectRequest |bibisected, bisected
 CC||xiscofa...@libreoffice.org

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

QA Administrators  changed:

   What|Removed |Added

   Keywords||bibisectRequest

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

Telesto  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||7334

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #4 from m.a.riosv  ---
Something to do with tdf#127334?
https://bugs.documentfoundation.org/show_bug.cgi?id=127334#c1

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

--- Comment #3 from Mike Kaganski  ---
The change in 6.3 happened after commit
85c0521f01f5c726e9f754b3175a550121e566c8.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

Mike Kaganski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

Mike Kaganski  changed:

   What|Removed |Added

 CC||er...@redhat.com
Version|7.0.6.2 release |6.3.0.4 release
   Keywords||regression

--- Comment #2 from Mike Kaganski  ---
Repro using Version: 7.3.5.1 (x64) / LibreOffice Community
Build ID: d56c1c78db15939340c3db8ee3b6667832313d23
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

Doing hard recalc (Ctrl+Shift+F9) does not change the result. Cloning the
formats from one row to the other and hard-recalc changes the calculation
result.
The document has "Precision as shown" *unset*.

This is not reproducible using Version: 6.0.0.3 (x64)
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 12; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL

but repro using Version: 6.3.0.4 (x64)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL

It is different using Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL

in the latter, hard recalc puts 0:29 to the both cells.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149898] Calculating datetime differences - different results depending on number format

2022-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149898

cpohle  changed:

   What|Removed |Added

Summary|Calculating datetime|Calculating datetime
   |differences - different |differences - different
   |results depending on|results depending on number
   |formatting  |format

-- 
You are receiving this mail because:
You are the assignee for the bug.