Drag and fill creates unexpected/invalid values when dragging horizontally

[khattakdev]

Forum post

Hi,

I observed the following unexpected behaviour (reproducible with advanced example 5.6.12 and 6.x): The FillHandle feature is activated. Columns "Start Date" and "% Done" are side by side. Now I select a cell in the start date column and drag it horizontally to the % done cell. As result, % done gets a new value of several millions %.
My expectation is that only valid values are copied, like date to date, checkbox to checkbox, number to number, string to string etc..

See my screenshots below: I dragged the start date value to the right. => Duration remains unchanged. => Manually scheduled is checked now. => % Done gets an invalid value.

Is it possible to avoid it?