Fill Handle Copies Wrong Dates when Using non-English Locale
search cancel

Fill Handle Copies Wrong Dates when Using non-English Locale

book

Article ID: 380497

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Copying dates using the fill handle (small square in the bottom right of the cell, the cursor turns to a '+' [plus] sign) when on a non-English locale copies wrong values.

Steps to Reproduce:

  1. Configure the locale to a non-English locale (e.g.: Czech, Spanish, German...). Using Czech for the following steps.
  2. Navigate to the Projects and have multiple project instances displayed.
  3. From a cell of Date type (like 'Finish Date'), Set the date to some valid date in the future where the first digit is 12 or lower (e.g.: '01.12.2026' - As per the Czech locale, this would be 'December 1st, 2026').
  4. Drag the fill handle to copy the value to other adjacent cells, like project instances below.

Expected Results: New Finish Date for the projects will be '01.12.2026'.

Actual Results: New Finish Date for the projects will be '12.01.2026' for the first project, '01.12.2026' for the second, '12.01.2026' for the third, '01.12.2026' for the fourth...

  1. Set the date to some valid date in the future where the first digit is higher than 12 (e.g.: '31.12.2026' - As per the Czech locale, this would be 'December 31st, 2026').
  2. Drag the fill handle to copy the value to other adjacent cells, like project instances below.

Expected Results: New Finish Date for the projects will be '31.12.2026'.

Actual Results: 'NaN.NaN.NaN' value will briefly display on the target cells, an error will be displayed ('CMN-0016: Attribute 'schedule_finish' has an invalid value') and the values will roll back to their original dates.

Environment

Clarity 16.2.2

Cause

DE155565

Resolution

This issue has been fixed in Clarity 16.3.1 and the fix has been backported to Clarity 16.2.3 patch #2.

 

Workaround: Instead of using the fill handle, copy the value by using the keyboard copy/paste shortcuts.