[Libreoffice-bugs] [Bug 108514] New: Start of week (day) does not change with locale settings , or adhere to ISO standard

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108514

            Bug ID: 108514
           Summary: Start of week (day) does not change with locale
                    settings, or adhere to ISO standard
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lutradev at runbox.com

Description:
Sunday is considered "first day of the week" by LibreOffice (with Saturday as
day 7), regardless of Locale settings or international standard.
I.e. LO have defined week to be [Sunday --> Saturday], instead of [Monday -->
Sunday]

My Locale (Norwegian, Norway) have Monday (1) as first day of the week, and
Sunday as last (7), in accordance with international standard (specifically ISO
8601). 

When I use either 'weeknum()' or 'weekday()' on a Sunday, it will be
displayed/defined as the same weeknumber as the following monday, and
weekday=1, repectively.

This also applies when I use conditinoal formatting to highlight dates:
[Date is --> This week --> Apply XYZ formatting]. This is demonstrated in the
attached screenshot.

Steps to Reproduce:
1. Add a date to cell (sunday): A1 =11.06.2017
2. Cell B1 =weekday(A1) --> output: 1
3. Same for Saturday, but output as day 7

Actual Results:  
Sunday is output as First Day of the Week (1).
Saturday is output as Last Day of the Week (7).

Expected Results:
Monday should be considered First Day of the Week (1).
Sunday should be considered Last Day of the Week (7).


Reproducible: Always

User Profile Reset: No

Additional Info:
I've tried changing Locale settings around, but nothing works.
I've tested/checked this bug to be true for maxOS, Linux, and Windows.


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0)
Gecko/20100101 Firefox/53.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170613/a1b17df5/attachment.html>