<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Start of week (day) does not change with locale settings, or adhere to ISO standard"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108514">108514</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Start of week (day) does not change with locale settings, or adhere to ISO standard
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>lutradev@runbox.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>