Problem with drag fill block option

Posted by: alexb on 8 September 2017, 12:48 pm EST

  • Posted 8 September 2017, 12:48 pm EST

    Hi


    We have updated the far point to version 3.0.


    On the previous version the data_changed event was triggered when each cell was updated by the drag and fill operation.


    Now on current version the data_changed event is not triggered when cell is updated following the drag and fill operation.


    What can be done?


    Thanks.

  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    I thought that was probably what you meant so I tested this with version 3.0.1004 and if I drag three rows of data across four columns the event fires four times.  What version are you using?
  • Replied 8 September 2017, 12:48 pm EST

    Hi Bob


    I have ment ActiveSheet.Models.Data.Changed event.

  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    There is no data_changed event in the Spread for WindowsForms product.  Are you referring to the Changed event for the data model?  If so, I am not able to reproduce this.  Could you post a small project reproducing this for us to debug?
  • Replied 8 September 2017, 12:48 pm EST

    Hi  Bob


     


    You  are right we used event: ActiveSheet.Models.Data.Changed  and not like in example.


     


    After some investigation I found that was the problem.


    Then we use drag and fill option in previous version it was not overwriting the TAG of cell and in current version it overwriting the Tag also.


    Was it a bug ? or now it is a bug? What should we do?

  • Replied 8 September 2017, 12:48 pm EST

    Hi Bob


    We using the next files:


    File Versions


    This version installs the following file versions on your system. See Installed Files for the exact location of these files.





































    FileVersion
    FarPoint.CalcEngine.dll3.0.2008.2005
    FarPoint.Excel.dll3.0.2008.2005
    FarPoint.Win.Spread.Design.dll         3.0.2004.2005
    FarPoint.Win.Spread.dll3.0.2004.2005
    FarPoint.Win.dll3.0.2004.2005
    FarPoint.SpreadWrapper.dll3.0.2004.2005
    FarPoint.SpreadDesigner.exe1.0.2000.2005
    FarPoint.PluginCalendar.WinForms.dll3.0.2004.2005
    FarPoint.Win.Ink.dll3.0.2000.2005
    FarPoint.Win.TextRenderer.dll2.5.2001.2005


    I have attached the test solution.



    2007/09/TestFragFillOption04.zip
  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    You are using the Change event of the spreadsheet which isn't going to fire when doing a drag and fill.  I am not sure how you were getting it to work in an earlier version.  You need to use the Changed event of the data model instead.
  • Replied 8 September 2017, 12:48 pm EST

    I was able to reproduce this and have written it up as a bug for the development team to fix.
  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    There will not be a "fixed" version.  The way it behaved earlier was incorrect.  FillRange delegates to the DataModel methods to copy data from one location to another and tags, notes, formulas and values are stored there so they will always be overwritten when you do a drag/fill.  It will continue to behave as it does now.

  • Replied 8 September 2017, 12:48 pm EST

    Hi Bob


    When you expect the fixed version will be released?

  • Replied 8 September 2017, 12:48 pm EST

    This bug came back As Intended.  It was a bug in the previous version and should have been overwritten.
  • Replied 8 September 2017, 12:48 pm EST

    Hi Bob


    I missed your post one before last, therefore asked then will be the fixed.


    So if we want to copy only the values of the cells then we use drag and fill option we should overwrite the drag fill event and do copy in ourselves in code?


     

  • Replied 8 September 2017, 12:48 pm EST

    Are you setting the Tag property on individual cells or on columns/rows?
  • Replied 8 September 2017, 12:48 pm EST

    We use tag in each cell.

  • Replied 8 September 2017, 12:48 pm EST

    Hello,


    We should be wrapping this up to make it available later this week. Assuming QA testing does not find anything glaringly wron in the build, this should be available soon.


    This is not the intended behavior of the Ctrl-V InputMap in Spread. This key combination should always paste the data from the clipboard into the Spread starting at the active cell. I am not able to reproduce the problem you are seeing. Could you post a small zipped project reproducing this issue for us to debug?

  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    After some discussion the development team decided this was a bug and it has been fixed and will be in the next maintenance release which we are currently testing.  In version 3 it will behave the same as in version 2.5.
  • Replied 8 September 2017, 12:48 pm EST

    Alex -

    This issue is currently being discussed by the development team.  I will let you know what the final outcome is.  In the meantime if you are allowing undo's in your project then you will have to handle the copy yourself.   If you do not allow undo's (FpSpread1.AllowUndo = False) then you can set the e.DataOnly = True in the DragFillBlock event and then the tags will be maintained.
  • Replied 8 September 2017, 12:48 pm EST

    Hello,


    It looks like this is a bug in the current release. I have not seen this before. I then replaced the assembly with our latest build for the maintenance and the paste worked correctly. This bug will be fixed in the next maintenance release.

  • Replied 8 September 2017, 12:48 pm EST

    The property: AllowUndo of the grid changes to this bahavior.


    2007/10/TestFragFillOption04.zip
  • Replied 8 September 2017, 12:48 pm EST

    Hi


    So when is it expected to be released?


    I have used meanwhile like you advised and set the property of the grid AllowUndo =  false but now we have problem with CTR V function in grid. It is only works first time and after it no mater there I try to do CTR V options it jumps automatically  to first cell there I have succeeded to use this option in first time and probably the last one.  Is it intended behavior?


     

  • Replied 8 September 2017, 12:48 pm EST

    Ok thank you, we will wait to maintenance release.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels