node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard

Published 20 hours ago • verified publisher icon theoephraim

feat(worksheet): enable add data validation call

Open uladkasach opened this issue 9 months ago • 1 comments

closes https://github.com/theoephraim/node-google-spreadsheet/issues/566

example of using it to create a dropdown field in screenshot:

image

uladkasach avatar Apr 25 '24 13:04 uladkasach

@theoephraim Can we get this merged in please? 🙏

ollebergkvist avatar May 06 '24 14:05 ollebergkvist

@theoephraim Hi Theo! Can this pr be merged please? 🙏

caseybrookes avatar May 10 '24 16:05 caseybrookes

Just realized that originally this PR had unintentionally included a package-lock.json diff.

That's now been corrected, with the diffs now scoped purely to the intended setDataValidation feature

uladkasach avatar May 12 '24 14:05 uladkasach

I'll take a look at this and get it merged in today! Apologies for the delay.

I've been hard at work on a new project - an open source dev tool for dealing with configuration - https://dmno.dev/ It's still in beta but please check it out and ⭐ the repo if you have a sec.

theoephraim avatar May 12 '24 17:05 theoephraim

Ok folks - this has been merged after adding tests and cleaning things up a bit.

A notable change, the function signature was changed to match the rest of the library more closely. It is now await sheet.setDataValidation(range, rule)

See https://theoephraim.github.io/node-google-spreadsheet/#/classes/google-spreadsheet-worksheet?id=fn-setdatavalidation

theoephraim avatar May 12 '24 20:05 theoephraim