[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Eike Rathke changed: What|Removed |Added Attachment #176154|0 |1 is obsolete|| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 --- Comment #16 from Eike Rathke --- (In reply to BillDuckMan from comment #13) > Created attachment 176154 [details] > Exported from Google Calendar - Rounding Issue > > The attached shows a rounding issue in column E, which is the difference > between columns D and C (dates/times). > > For example, opening the file in Calc I see 00:59 instead of 01:00 and 01:44 > instead of 01:45 That is fixed by actually applying the *duration* format [HH]:MM to column E. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 --- Comment #15 from Justin L --- repro 7.3+ -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Aron Budea changed: What|Removed |Added Assignee|bill.austinlo...@gmail.com |libreoffice-b...@lists.free ||desktop.org --- Comment #14 from Aron Budea --- (In reply to BillDuckMan from comment #13) Based on the comment I presume you didn't mean to assing this bug report to yourself. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 bill.austinlo...@gmail.com changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |bill.austinlo...@gmail.com |desktop.org | --- Comment #13 from bill.austinlo...@gmail.com --- Created attachment 176154 --> https://bugs.documentfoundation.org/attachment.cgi?id=176154=edit Exported from Google Calendar - Rounding Issue The attached shows a rounding issue in column E, which is the difference between columns D and C (dates/times). For example, opening the file in Calc I see 00:59 instead of 01:00 and 01:44 instead of 01:45 If I open the same file in MS Excel, the correct values are shown. --- The file is a subset of the main file, which itself shows mostly correct values [in column E] in Calc, so I include only the incorrect values. I have a work-around that seems to work. The work around is to change the cells in column E: - from: =(D2-C2) - to: =(D2-C2)+0.1 ...but I would rather not do this for obvious reasons. Thank you -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Aron Budea changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=14 | |3132| -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Eike Rathke changed: What|Removed |Added CC||libreoff...@nisz.hu --- Comment #12 from Eike Rathke --- *** Bug 143132 has been marked as a duplicate of this 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
[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 NISZ LibreOffice Team changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||3132 -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 --- Comment #11 from Eike Rathke --- (In reply to b. from comment #10) > except the seconds (or fractions?), they are rounded what leads to funny > effects Wrong. You are confusing with the SECOND() function. -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 b. changed: What|Removed |Added CC||newbie...@gmx.de --- Comment #10 from b. --- think it's less a problem of calculating but of 'standard', there was a change shortly - or old and implemented shortly - that calc for time values shows digits like a digital wall clock would do, thus always rounded down, except the seconds (or fractions?), they are rounded what leads to funny effects and some discussions already ... search for 'calc' and 'wall clock', -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 --- Comment #9 from Aron Budea --- The minimal value for 17:00 - in Excel, and in Calc < 6.2: 0.708327546296297 - in Calc 6.2+: 0.7083328 -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Aron Budea changed: What|Removed |Added Attachment #161903|application/x-ole-storage |application/vnd.ms-excel mime type|| -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 --- Comment #8 from Aron Budea --- Created attachment 167910 --> https://bugs.documentfoundation.org/attachment.cgi?id=167910=edit Sample with single time cell in XLSX Bug isn't specific to XLS, here's an XLSX saved in Excel, with the time copied over from the other sheet. Note that the numerical value (whatever's shown of it in the formula bar) is 0.7082121 in the buggy case, and 0.708 in the case when 5:00 PM is entered in Calc. The latter, "good" value is produced if 5:00 PM is entered in Excel, too, so it's a difference in "rounding" for display. -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Aron Budea changed: What|Removed |Added Hardware|x86-64 (AMD64) |All Keywords||bibisected, bisected, ||regression CC||er...@redhat.com Version|6.4.4.2 release |6.2.0.3 release See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||5580, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||7498 --- Comment #7 from Aron Budea --- It's as expected in 6.1.0.3, but not in 6.2.0.3. => regression Bibisected to the following commit using repo bibisect-linux-64-6.2. Adding CC: to Eike Rathke. Bug 125580 and bug 127498 have been identified as starting from the same commit. https://cgit.freedesktop.org/libreoffice/core/commit/?id=e2e47898180e547cad7ccde1e5890385d573e551 author Eike Rathke 2018-08-31 11:21:03 +0200 committer Eike Rathke 2018-08-31 12:50:52 +0200 Use tools::Time::GetClock() in number formatter for wall clock time -- 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 133919] FILEOPEN XLS Time values rounded incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=133919 Buovjaga changed: What|Removed |Added Blocks||109072 Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Keywords||filter:xls Summary|Import of Excel format data |FILEOPEN XLS Time values |transfer file rounds time |rounded incorrectly |incorrectly | --- Comment #6 from Buovjaga --- (In reply to Xisco FaulĂ from comment #5) > Created attachment 163611 [details] > Comparison MSO 2010 and LibreOffice 7.1 master So let's set to NEW Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109072 [Bug 109072] [META] XLS (binary) format bug tracker -- 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