-
Bug
-
Resolution: Fixed
-
Low
-
5.8.4, 5.9.1, 5.10.4, 6.14.1, 6.14.2, 6.14.3, 6.15.4, 6.15.6, 6.15.7, 7.2.1, 7.4.6, 7.9.3
-
17
-
Severity 3 - Minor
-
22
-
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
Summary
Dates are not sorted correctly when user is on European browser (such as Deutsch).
Environment
Tested in:
- Confluence server 6.15.6
Steps to Reproduce
- Make sure that browser is on English language
- Create a page with random dates in a table
- Save, and try to sort it
- Tables are sorted correctly
- Go to user profile > setting > edit > set language as Deutsch
- Go back to the page > try to sort the dates
Expected Results
Dates are sorted correctly
Actual Results
Dates are not sorted correctly. In fact, it's sorted in a random way. see f0S76Dx2jG.gif
Notes
This issue is different than CONF-34002 since CONF-34002 is an improvement request for dates to be able to be sorted.
Date sorting feature doesn't sort plain text dates since plain text dates could be ambiguous to users with different system & profile locales.
- causes
-
-
- Closed
-
-
PSR-702 You do not have permission to view this issue
- is cloned from
-
CONFSERVER-34002 Dates aren't sorted correctly
- Closed
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
- is related to
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
- Closed
-
- Gathering Interest
-
- Gathering Interest
-
PSR-662 Loading...
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-38083] Dates aren't sorted correctly in European time format (dd.mm.yyyy)
| Remote Link | Original: This issue links to "PSR-702 (Bulldog)" [ 607665 ] | New: This issue links to "PSR-702 (JIRA Server (Bulldog))" [ 607665 ] |
| Link | New: This issue relates to CONFSERVER-35168 [ CONFSERVER-35168 ] |
| Remote Link |
New:
This issue links to "A1 Server. Master Baseline › Main Plugins - Samurai › issue- |
| Remote Link |
New:
This issue links to "A1 Server. Master Baseline › Main Plugins - Little Big Platform › issue- |
| Remote Link | New: This issue links to "PSR-662 (Bulldog)" [ 622325 ] |
| Description |
Original:
{panel:bgColor=#e7f4fa}
*NOTE:* This bug report is for *Confluence Server*. Using *Confluence Cloud*? [See the corresponding bug report|http://jira.atlassian.com/browse/CONFCLOUD-38083]. {panel} h3. Summary Dates are not sorted correctly when user is on European browser (such as Deutsch) h3. Environment Tested in: * Confluence server 6.15.6 h3. Steps to Reproduce # Make sure that browser is on English language # Create a page with random dates in a table # Save, and try to sort it # Tables are sorted correctly # Go to user profile > setting > edit > set language as Deutsch # Go back to the page > try to sort the dates h3. Expected Results Dates are sorted correctly h3. Actual Results Dates are not sorted correctly. In fact, it's sorted in a random way. see [GIF attached|https://jira.atlassian.com/secure/attachment/206841/f0S76Dx2jG.gif] h3. Notes This issue is different than |
New:
{panel:bgColor=#e7f4fa}
*NOTE:* This bug report is for {*}Confluence Server{*}. Using {*}Confluence Cloud{*}? [See the corresponding bug report|http://jira.atlassian.com/browse/CONFCLOUD-38083]. {panel} h3. Summary Dates are not sorted correctly when user is on European browser (such as Deutsch). h3. Environment Tested in: * Confluence server 6.15.6 h3. Steps to Reproduce # Make sure that browser is on English language # Create a page with random dates in a table # Save, and try to sort it # Tables are sorted correctly # Go to user profile > setting > edit > set language as Deutsch # Go back to the page > try to sort the dates h3. Expected Results Dates are sorted correctly h3. Actual Results Dates are not sorted correctly. In fact, it's sorted in a random way. see [^f0S76Dx2jG.gif] h3. Notes This issue is different than Date sorting feature doesn't sort plain text dates since plain text dates could be ambiguous to users with different system & profile locales. |
Hi Zac Xu,
at the moment we are using confluence 7.14.1 and languagesettings on german.
Table1: If we create tables and fill dates with the datepicker we cant sort any column from the table.
Table2: If we fill in the date manual in the digitalformat "day.month.year" the sort function is completely wrong.
Table1:
<p class="auto-cursor-target"><br /></p> <table><colgroup><col /><col /></colgroup> <tbody> <tr> <th scope="col">date</th> <th scope="col">order</th></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-01" /> </p></div></td> <td>1</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-31" /> </p></div></td> <td>3</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-13" /> </p></div></td> <td>2</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-03" /> </p></div></td> <td>5</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-01" /> </p></div></td> <td>4</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-03-10" /> </p></div></td> <td>7</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-17" /> </p></div></td> <td>6</td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr></tbody></table> <p class="auto-cursor-target"><br /></p>
Table2
<p class="auto-cursor-target"><br /></p> <table><colgroup><col /><col /></colgroup> <tbody> <tr> <th scope="col">date</th> <th scope="col">order</th></tr> <tr> <td>01.01.2021</td> <td>1</td></tr> <tr> <td>31.01.2021</td> <td>3</td></tr> <tr> <td>02.02.2021</td> <td>4</td></tr> <tr> <td>27.03.2021</td> <td>6</td></tr> <tr> <td>09.02.2021</td> <td>5</td></tr> <tr> <td>08.01.2021</td> <td>2</td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr></tbody></table> <p class="auto-cursor-target"><br /></p>
Hi it1829750478 ,
Your screenshots seems not uploaded. Could you please create a sample page and upload its storage format so that we could reproduce this issue in order to fix it.
Cheers,
Hi de8df2978224
Could you please create a sample page and upload its storage format so that we could reproduce this issue in order to fix it.
Cheers,
Zac
Hi it1829750478 ,
For table 1, empty cell sorting bug was known and fixed in 7.14.2, you could find more detail on ticket: https://jira.atlassian.com/browse/CONFSERVER-74697
For table 2, the date sorting feature was implemented against consistent datetime attributes in semantic <time> tags like
<time datetime="2022-02-17">Users could insert it by using datepicker in editor. Plain text is sorted alphabetically. We don't parse plain text dates because it's ambiguous to users with different system and profile locales settings.
Cheers,
Zac