Added validation are lost after doing export/import for worksheet

Added validation are lost after doing export/import for worksheet

Posted by: tarun.softengg on 8 July 2021, 8:34 am EST

• 

  tarun.softengg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 July 2021, 8:34 am EST

  I have a simple use case where I have added validation in the sheet but when I export and import that sheet back again, all validations are lost

  Please let me know if anything is missing here

  	const jsonOptions = {
  		ignoreFormula: false,
  		ignoreStyle: false,
  		frozenColumnsAsRowHeaders: true,
  		frozenRowsAsColumnHeaders: true,
  		doNotRecalculateAfterLoad: false
  	};
  	const serializationOption = {
  		ignoreFormula: false,
  		ignoreStyle: false,
  		rowHeadersAsFrozenColumns: true,
  		columnHeadersAsFrozenRows: true,
      doNotRecalculateAfterLoad: false
  	};
  

  I am using these options to serialize and deserialize, I have added validations like

  NumberValidator, DateValidator
  

  but when I export this workbook and import it back then i see validations are gone!!

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 9 July 2021, 6:30 am EST - Updated 3 October 2022, 9:44 am EST

  Hi Tarun,

  We are sorry but we are unable to replicate the issue at our end. Could you please provide a small sample that replicates the issue so that we could investigate it further and assist you accordingly?

  You may also refer to the following sample that we used for testing and modify it to replicate the issue.

  sample: https://codesandbox.io/s/spread-js-json-import-export-forked-k2et2?file=/src/index.js

  Regards,
  
  Avinash

  Here is a gif of our observation.’