https://bugs.freedesktop.org/show_bug.cgi?id=54346
Bug #: 54346
Summary: Libreoffice 3.5.5 Calc WEEKDAY() function shows wrong
number of day
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: andis.lazd...@gmail.com
Created attachment 66437
--> https://bugs.freedesktop.org/attachment.cgi?id=66437
Sample file
Libreoffice 3.5.5 Calc WEEKDAY() function applies wrong number of day in
Conditional formatting applications. Sample file follows in attachment.
When I try to set certain formatting to Sundays and Saturdays, like in column A
in sample file (formula to apply different style is
OR(WEEKDAY(A1)=6;WEEKDAY(A1)=7)). If default Date format (12/30/1899) is
selected, special formatting is applied to Fridays and Saturdays, if Date
format 01/01/1904 is selected, special format is applied to Saturdays and
Sundays like predicted, if Date format 01/01/1900 (StarCalc 1.0) is selected,
special formatting is applied to Wednesdays and Trursdays. Value of WEEKDAY()
in column C at the same time is not changing with no respect to selected Date
format.
I don't know when this problem appeared, but I used this application for
several years without any problems since I found it by accident.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
