Bug found in cell notes for Spread.NET 6

Posted by: ericlam on 8 September 2017, 3:01 pm EST

  • Posted 8 September 2017, 3:01 pm EST

    I seem to have found a bug in FpSpread component (Spread .NET 6 WinForms). It occurs when there was already a cell note previously, you update the cell note via code (e.g. ActiveCell.Note = "new value"), GUI shows updates values correctly but when you save the spreadsheet it doesn't actually save the cell note's new value. Other notes: C# with .NET 3.5 and saving to XLS format.

    This same problem also happens if you copy and paste any cells (which have cell notes) over cells that also already have notes. Again updated cell notes don't get saved (even though GUI reflects the update correctly).

    Also tested for issue in GrapeCity Spread Designer and confirmed bug exists there too (so pretty sure it's not my code anymore). Steps done in Designer:

    1.) Create a new cell note

    2.) Saved spreadsheet as .XLS.

    3.) New spreadsheet (to close previous).

    4.) Re-open saved document.

    5.) Update the existing cell Note in Designer and re-save.

    6.) New spreadsheet (to close previous).

    7.) Re-open saved document and check the cell Note (it is not the updated value!!!).

     

    We have recently purchased a license (and maintenance) to this component only to discover this bug soon after. 

    Temporary workaround for our code to update a cell note value is to do Cell.ResetNote() before setting the new cell note value. However, unsure how best to workaround the bug for other possible user operations (e.g. copy and paste, drag-fill, etc). Hopefully a patch can be provided ASAP.

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    I was able to replicate the issue using Spread designer but the issue was not replicated when through code. Could you please have a look at the attached sample that I created at my end and which is working fine. I would request you to modify the same to depict your issue so that I can replicate the issue at my end and debug it further.

    Thanks,

    Manpreet Kaur


    2012/10/UpdateCellNote.zip
  • Replied 8 September 2017, 3:01 pm EST

    Hi,

    I don't know if it is of any consequence that I usually perform cell note updates via ActiveCell.Note, but I've been able to reproduce the issue with some alterations to the stripped down project you provided me. Note: One thing I did first of all was to downgrade the project to .NET 3.5 to make sure it was the same framework version as what I'm using. The problem may still exist when working with .NET 4.0+, but I have not tested this as I am not working with .NET 4.0 and up.

    Please see the attachment.

    Kind Regards,
    Eric 


    2012/10/UpdateCellNoteBugReproduced.zip
  • Replied 8 September 2017, 3:01 pm EST

    As mentioned previously, I can temporarily workaround the issue for code-based updates to cell notes by doing ActiveCell.ResetNote() before setting it again via ActiveCell.Note.

    However, I'm quite concerned that the user is allowed to perform other non-code related operations (like copy and paste) that in the GUI appears to update the cell note correctly, but does not actually save the updated cell notes correctly.

    Cheers,
    Eric. 

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    I was not able to replicate the issue at my end, please have a look at the steps that I followed at my end:

    1. Typed in the text in the textbox that would be assigned as new cell note to the cell.

    2. Clicked on the Change cell note button to change the cell note and the cell note was updated correctly.

    3. Click on the save excel button to save Spread to Excel.

    4. Click on Open Excel button to load the Excel file in Spread, the new cell note showed correctly

    I have also attached a video that depicts the same, please download the same from the following link: http://speedy.sh/jvg5M/CellNoteVideo.zip, to have a look at it and let me know if I missed something that would help me to replicate the issue at my end. I would also like to know the system configuration of the machine on which you are able to replicate the issue. I hope you are using the latest version of Spread.Net 6 i.e v6.0.xx05. Please provide with any information that would help to narrow down the issue further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    [sorry duplicated post - see below]
    2012/10/UpdateCellNoteBugReproduced_v2-2.zip
  • Replied 8 September 2017, 3:01 pm EST

    Hi Manpreet,
     
    Sorry, but I can't download that video file from Speedy - that website detects I'm in Japan and forces me to sign-up for a premium account to download it. No thanks.

    Attached is the same project, but I stripped out all unnecessary code and also put in a fresh FpSpread control from the toolbox without any customisation - I noticed when in Form Design mode that you had set the "NoteStyle"="StickyNote" on the first cell for convenience, but this seems to stop the bug from happening on that cell. The project references to a "FarPoint.Win.Spread" of version: 6.0.3505.2008 (which from the website appears to be the latest version).

    I've uploaded a video to YouTube: http://youtu.be/cavaaru5XNM

    Steps using the GUI (as shown in video):
    - Load the app
    - Go to Cell[0,0], set the value to "A" and add a cell note "A" (using the Change Cell Note button)
    - Go to Cell[0,1], set the value to "B" and add a cell note "B"
    - Go to Cell[0,2], set the value to "C" and add a cell note "BJN"
    - Go to Cell[0,2], update the wrong cell note of "BJN" to "C"
    - Check all the cell notes to make sure it should read "A", "B", "C"
    - Save the file
    - Open the file
    - Notice that re-opened file doesn't seem to have saved the correct cell notes of: "A", "B", "C" (even checked in Excel)
    - Try changing all the cell notes again (without deleting them)
    - Again save the file
    - Again open the file
    - Same issue as mentioned

    Also coding manipulation of cell notes is only one aspect of the problem and it's one that I can already workaround as mentioned previously.

    IMO the bigger problem is that the user can copy and paste the cell from another and it supposedly copies the cell note with it, but upon saving it doesn't actually save the correct cell note. Watch this: http://youtu.be/xN_dQ9VcaCQ
    Note: Other operations like drag-fill and drag-drop move cells (and possibly more) that your component supports may also be affected by this bug.

    Cheers,
    Eric.

    PS: All YouTube vidoes are set as "Unlisted" so no one else should find them unless they know the exact links.

    2012/10/UpdateCellNoteBugReproduced_v2-3.zip
  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    Due to some internal reasons some of the posts are moderated and hence you receive such a message, however we continuously keep a track of all the moderated posts so the post is not lost. For the issue that you have reported I was able to replicate the issue at my end and it seems to be a bug. I have reported the issue to the development team and the bug number for the same is #99929466. It would be fixed in the next maintenance release.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    Hi,

    Ok great. Do you have any idea of when the next maintenance release might come out?

    Also please ensure that the bug fix gets tested for user operations that are automatically supported by the FpSpread control because the project I'm developing with your component will need to support users doing copy-paste, drag-drop move and drag-fill (support for these operations is one of the main reasons why we chose to use the Spread.NET component).

    Thanks,
    Eric.

    PS: Sure, I'll keep that in mind regarding the procedure for post moderation. 

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    I would like you to know that the next maintenance release of Spread is expected to be released by the end of this year and you can download the same from the following link once it is available:

                          http://www.gcpowertools.com/DownloadLatestVersion

    I have specifically mentioned in the bug reported to the development team for a fix of this issue in scenarios like copy paste, drag fill and others. Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    [sorry duplicated post - see below]
    2012/10/UpdateCellNoteBugReproduced_v2.zip
Need extra support?

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

Learn More

Forum Channels