Data validation list type formulae limit - drop-down cell items limit

[DevMoustafa97]

If we specify a list of valid values (One, Two, Three, Four).
Excel will provide a dropdown with these values using the code below

worksheet.getCell('A1').dataValidation = {
  type: 'list',
  allowBlank: true,
  formulae: ['"One,Two,Three,Four"']
};

it works, but if the length of that single element in the array ('"One,Two,Three,Four"') is > 1024 (quotes included)

on LibreOffice:
it treats the entire string as a single value
on Microsoft excel:
it gives an error on opening the file and if you let it fix that it will remove all list validation

can we add more values without these issues?

[rohitvishwakarma1819]

@DevMoustafa97 did you find any solution ?

[Kiran-Oleti]

@DevMoustafa97 @rohitvishwakarma1819 did you find the solution to add n number of values to the dropdown without gettinng error in excel while opening