PASTING VALUES

[Stephen Welborn]

Trying to add Validation to cells.

 setTimeout(() => {

                    spreadsheetObj.addDataValidation({ type: 'Decimal', operator: 'Between', value1: '0.0',value2:'1000000.00', ignoreBlank: false }, 'E4:E7');

                    spreadsheetObj.numberFormat('_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@@_)', 'E4:E7');

                   

                }, 1000)

However, when pasting values to the cells this is not honored.

[Sangeetha Priya Murugan]

Hi Stephen,

If you paste any values in the data validation applied range, the whole cell model gets replaced, and the data validation also gets removed based on the MS Excel behavior. The same behavior is done on our end, which is our default behavior and not an issue on our end.

Please get back to us with a detailed description of your issue, including video demonstrations and screenshots. If we misunderstood your issue or need any further assistance on this,