MyOffice Spreadsheet web editor supports working with cells for which data validation and selection of a value from a drop-down list is configured in third-party editors.
There are a number of restrictions in the current version of the web editor:
•It is not possible to change the data source for the drop-down list and validation conditions, but you can delete the value from the source.
•The suggestions set for the drop-down list are not displayed.
•Error messages created in third-party editors are not supported.
•Copying a cell while saving a drop-down list is not supported.
•It is not possible to create a new drop-down list and configure data validation.
One or more data validation cells can be stretched to autofill cells located to the left, right, bottom or top.
When merging cells, the data validation condition is saved only from the upper left cell of the range. When unmerging cells:
•The data validation condition is kept for the upper-left cell of the range if it was set for this cell before merging the cells.
•The data validation condition is stored in each cell of the range if it was set for the merged cell. If the merged cell contained a drop-down list and a value was selected in it, then it will be saved only in the upper-left cell of the range.
The values of the drop-down list are always relevant. For example, if there is a formula result in the source, and the formula's arguments change, then the corresponding value is updated in the list.
The drop-down list displays the values in the same format as they appear in the source. The format of a cell determines how the selected value is displayed.