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.