https://bugs.freedesktop.org/show_bug.cgi?id=76549
Priority: medium
Bug ID: 76549
Assignee: [email protected]
Summary: Other: Date shown with wrong day using different
format
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.5.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96283
--> https://bugs.freedesktop.org/attachment.cgi?id=96283&action=edit
Sample file
Problem description: The problem emerged in a file similar to the one attached.
There is a column where each row is a date obtained by adding 15 minutes to the
preceding one. The following columns contain references to the original date
using different formats (the first two use the TEXT function, the other two are
direct references). In the first rows the dates are shown correctly, but after
about 2500 rows, when the first row starts a new day, the columns that are
formatted to display just date are showing a different day than the ones that
are formatted showing both date and hour.
I tried on a windows machine using an older LibreOffice release (3.6.5) and it
shows the difference from the first row. This is a more consistent and reliable
behaviour but in my opinion still not correct, since a date refers to the same
day even when formatted in a different way.
Steps to reproduce:
1.Open the attached file
2.Look at row 2499
Current behavior: References to the same date are showing different day when
formatted in a different way.
Expected behavior: Dates shown with different formats should still refer to the
initial day
Operating System: Ubuntu
Version: 4.1.5.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
