Hi,
Is there anyway to add dropdown list to the excel file using ods tagsets or any other ods engine which creates ods excel file.
Thank you,
Ananda
Thank you for your reply. I am talking about adding data validation list for a perticular cell.
Hi:
Oh, you mean using the DATA choice on the ribbon to pick Data Validation like this:
I do not think you can do that with ODS. That would be a question for Tech Support. I know you can interact with the print and margin settings on the ribbon, using ODS EXCEL and ODS TAGSETS.EXCELXP options, but I am not aware of any way to insert data validation control into an XLSX file created with ODS.
Cynthia
Thats right
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.