FlipV of Shape Have Value string "1"

FlipV of Shape Have Value string "1"

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

• 

  khanh.le.duy

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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
  
  SimpleExcelShape.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  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.

  Regards,

  Ankit

  Sample: GCExcel.zip

• 

  khanh.le.duy

  • Post Options:
  • Link
    Copy

  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!

  Regards,
  
  Khanh Le - From StepMedia