Notes not visible anymore

Posted by: petri.rasanen on 25 September 2023, 12:40 am EST

  • Posted 25 September 2023, 12:40 am EST

    Hi,

    We are using Documents for Excel v6.0.3 to send json file to SpreadJS 16.2. In attached excel file there are notes and comments and they are visible. But when updated to latest Documents version 6.2.2 the notes are not displayed anymore. I tried various versions of Documents and the last version notes are displayed is 6.1.0.

    Br,

    Petri

    TestFileWithNotes.zip

  • Posted 25 September 2023, 9:28 pm EST

    Hello Petri,

    We have tried creating a JSON file with your given Excel file with 6.2.2 and 6.10 versions and tried loading it in the SpreadJS designer and the issue is not replicable.

    https://www.grapecity.com/spreadjs/designer/index.html

    Please find the code that we have used and the files generated and let us know if you are doing anything different.

    Workbook wb = new Workbook();
    wb.Open("TestFileWithNotes.xlsx");
    string json = wb.ToJson();
    File.WriteAllText("Test.json", json);

    Regards,

    Prabhat Sharma.

    JsonResult.zip

  • Posted 25 September 2023, 11:53 pm EST

    Hi,

    Here is a sample project in which you can replicate the issue.

    Br,

    Petri

    GCDocuments-Notes.zip

  • Posted 26 September 2023, 4:40 pm EST - Updated 26 September 2023, 4:45 pm EST

    Hello Petri,

    Thank you for providing the sample.

    We have run the sample at our end but the issue is not replicable, please see the attached GIF for reference and let us know if you are doing anything differently.

    Along with this please let us know the following so that we can test it in the same environment:

    1. machine Culture
    2. OS details.
    3. Browser details on which you are testing this app.

    Regards,

    Prabhat Sharma.

  • Posted 26 September 2023, 7:09 pm EST - Updated 26 September 2023, 7:14 pm EST

    Hi,

    Windows 11, Chrome 117, Region was set Finnish (Finland).

    But when I tried with region English (United States) it is working!

    So this is related to region. Also noted that when I scale the sheet bigger, you can see very small note appearing.

    Br,

    Petri

  • Posted 27 September 2023, 9:15 pm EST - Updated 27 September 2023, 9:20 pm EST

    Hello Petri,

    Thank you for providing the details.

    We have tested the app in your mentioned environment but the issue is not replicating. Please see the attached screenshots for reference.

    We have also mentioned the exact Chrome and VS versions for your reference, please share the version you are using at your end.

    Also, please check with another browser and let us know if you are facing the same issue with it.

    **Note: ** As per our understanding, you are not getting any cell notes [Threaded Comments] in any of the cells when building the app with 6.2.2 builds. Please let us know if you have any different understanding.

    Regards,

    Prabhat Sharma.

  • Posted 28 September 2023, 5:16 pm EST - Updated 28 September 2023, 5:21 pm EST

    Hi,

    Change the region format to Finnish (Finland). My doubt is that problem relates to dot (.) and comma (,) used as decimal / thousand separator. That may affect the sizing of notes window.

    Br,

    Petri

  • Posted 2 October 2023, 10:41 pm EST - Updated 2 October 2023, 10:46 pm EST

    Hello,

    We have also tried that but the issue is still not replicable, please see the attached screenshot for reference.

    Can you please test it on some other machine and let us know if you face the same issue with it too?

    Also, share the screen resolution and scaling details.

    Regards,

    Prabhat Sharma.

  • Posted 3 October 2023, 11:41 pm EST - Updated 3 October 2023, 11:46 pm EST

    Hi,

    Have tried with different machine, same thing with Finnish settings.

    Note that in your environment (in picture) you do not have Finnish decimal/digit grouping symbol. Screen resolutions have tried (1980x1080) and (2560x1440) with scaling 100% and 150%. The reason is decimal symbol comma (,) we are using in Finland. Dot (.) is working I tested.

    Br,

    Petri

  • Posted 4 October 2023, 10:07 pm EST

    Hello,

    Thank you for the screenshot.

    We too can observe the issue at our end and escalate this to the development to look into this matter on an urgent basis. We will update you as soon as we get the update from their end.

    [Internal Tracking ID: DOCXLS-8995]

    Regards,

    Prabhat Sharma.

  • Posted 15 October 2023, 8:56 pm EST

    Hello Petri,

    We are glad to inform you that the issue has been fixed in the latest version of GcExcel release 6.2.3.

    Please upgrade to the latest version to fix this issue:

    https://www.nuget.org/packages/GrapeCity.Documents.Excel/6.2.3

    Regards,

    Prabhat Sharma

  • Posted 15 October 2023, 8:56 pm EST

    Hello Petri,

    We are glad to inform you that the issue has been fixed in the latest version of GcExcel release 6.2.3.

    Please upgrade to the latest version to fix this issue:

    https://www.nuget.org/packages/GrapeCity.Documents.Excel/6.2.3

    Regards,

    Prabhat Sharma

Need extra support?

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

Learn More

Forum Channels