FlipV of Shape Have Value string "1"

Posted by: khanh.le.duy on 27 April 2023, 7:45 pm EST

    • Post Options:
    • Link

    Posted 27 April 2023, 7:45 pm EST

    Dear Sir/Madam,

    In Front-End our application, we use SpreadJS 16 to import excel (have shape in content). Then we send json data to server.

    In Back-End, we use GrapeCity.Documents.Excel Ver 6.0.0 (FromJson() func) to get the json. And we receive the exception with message [String ‘1’ was not recognized as a valid Boolean]

    After investigate, we recognize this issue come from the flipV property in Json string to be [“flipV”: “1”].

    In normal case, the flipV (or flipH) should be True/False value.

    Please give us some solution or some option for flipV (or flipH) be able to passed Json string with FromJson() func.

    Khanh Le - From StepMedia


  • Posted 30 April 2023, 5:26 pm EST

    Hi Khanh,

    I could see the issue with the GCExcel 6.0.0, however, this issue has been fixed in the latest version of GCExcel 6.0.6. Kindly upgrade to the latest version of GCExcel V6.0.6.

    I have tested with the json generated by the latest version of SpreadJS V16.0.7 hosted at https://www.grapecity.com/spreadjs/designer/index.html

    You could also find attached the sample that I have used for testing. In the sample, the json generated by the SpreadJS is present in the spreadjs_exported.json file.

    Kindly let us know if you still face any problems.



    Sample: GCExcel.zip

  • Posted 3 May 2023, 1:53 pm EST

    Dear Ankit,

    We checked the latest version 6.0.6. And … it worked.

    Thank you so much. You saved our time!


    Khanh Le - From StepMedia

Need extra support?

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

Learn More

Forum Channels