Escaping double quotes in cell's validation list.

1 Answer 14 Views
Spreadsheet
Edward
Top achievements
Rank 1
Veteran
Iron
Edward asked on 31 May 2021, 05:22 AM
Can I escape double quotes in cell's validation list?
range.validation({
    dataType: "list",
    showButton: true,
    comparerType: "list",
    from: `"Item 1", Item 2, Items 3"`, // Double quotes after Item 1 is required, options: Item 1", Item 2, Item 3.
    allowNulls: false,
    type: "warning",
    messageTemplate: "Invalid."
});

1 Answer, 1 is accepted

Sort by
0
Accepted
Edward
Top achievements
Rank 1
Veteran
Iron
answered on 31 May 2021, 07:15 AM
Sorry, found I made a mistake on escaping, just escape double quotes as usual with \\ will do the work.
Tags
Spreadsheet
Asked by
Edward
Top achievements
Rank 1
Veteran
Iron
Answers by
Edward
Top achievements
Rank 1
Veteran
Iron
Share this question
or