OLAP - Wrong order of month with German culture and MMM YYYY format

OLAP - Wrong order of month with German culture and MMM YYYY format

Posted by: h.otte on 28 February 2021, 8:54 pm EST

• 

  h.otte

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 February 2021, 8:54 pm EST - Updated 3 October 2022, 5:06 am EST

  hi,
  
  like I wrote in the header the order of the month is wrong when you use the format MMM YYYY (short month & long year) with the German culture file.
  
  The only month which doesn’t work correctly and appears at the wrong place is Mrz, which is short for März (=March).
  
  At first I guessed the problem came from the fact that the month has an ‘ä’ in its longer form, but there is no problem with the order when you set the format to MMMM YYYY and therefore see the whole name.

  You can see the error when in your examples, e.g. https://www.grapecity.com/wijmo/demos/OLAP/PivotGrid/Overview/purejs
  
  when you set the culture to German
  
  (insert in the html )
  
  change the date-format to MMM yyyy (Line 23 in the app.js: dateField.format = ‘MMM yyyy’
  
  and put the date in the columns
  
  

  In the resulting table Mrz 2018-Mrz 2020 is between Jan 2021 and Sep 2018
  
  

  Thank you and best regards

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 1 March 2021, 10:49 pm EST

  Hi Holger,

  Thank you for reporting the issue. I have forwarded this to the developers with internal tracking id WJM-19429. I will update you once this issue is fixed.

  In the meantime, as a workaround, you can use the sortComparer property of PivotField to manually sort the date field:

  https://stackblitz.com/edit/js-avumhw

  Regards,
  
  Ashwin

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 22 March 2021, 11:14 pm EST

  Hi,

  The issue has been fixed in the latest nightly build of Wijmo. You can verify the same using the sample link below:

  https://stackblitz.com/edit/js-exsix4

  Note that nightly builds have not been passed through the QA cycles and are not suitable for production environment.

  ~regards

• 

  h.otte

  • Post Options:
  • Link
    Copy

  Posted 15 April 2021, 12:49 am EST

  Thank you and thanks to the developer team for the fast reply, the workaround and the fast fix.