tableHome Edition macOS

Check data

Product:

Application: Spreadsheet Home Edition macOS

The current version of MyOffice Spreadsheet supports working with drop-down lists created in third-party editors and designed to check data entered into cells.

The following limitations currently apply:

•It is not possible to change the data source for the drop-down list.

•It is not possible to change the drop-down list settings.

•Errors set in third-party editors are not supported.

•Drop-down lists inserted as a control or ActiveX are not supported.

The data source for the drop-down list can be edited in the following ways:

•Edit values

•Add values within a range: When adding values to a range, a named range, a smart table, the values are added to the drop-down list according to their place in the range.

•Delete values partially or completely: If one or more values are deleted, values are displayed in their place in the drop-down list (an empty cell), if all values are deleted, the drop-down list becomes empty.

The values of the list are always up-to-date. For example, if the source is the result of a formula and the formula's arguments change, then the corresponding values in the list are updated.

A cell with a drop-down list can be cut, copied and pasted. But if the contents of the drop-down list are determined by a condition, then when inserting a cell with a list, only the value selected in the cell is inserted.

In the drop-down list, the values are displayed in the form in which they are displayed in the source. In a cell, the display of the selected value is determined by the format of this cell. For example, if the drop-down list contains dates, and the General or Text format is selected for the cell, then the selected date in the cell will be converted according to the format: the date 02.02.2020 will be displayed as the value 43863.

Enter a value in a cell

To enter a value in a cell with a drop-down list, follow these steps:

1.Select the cell. A prompt for entering a value will be displayed above the cell, if it was created in a third-party editor.

2.Do one of the following:

•Expand the drop-down list and select the desired value. To work with the drop-down list, you can use the mouse or keyboard keys (see the table).

•Enter the value manually and press the enter key or click the fx_accept_icon button in the Formula bar. The entered value must match character by character with the required value in the drop-down list. The case of characters is not taken into account when entering a value.

If the value entered manually is incorrect, the drop-down list is automatically expanded. The "Invalid value" error is displayed at the top of the list.

To edit the entered value, do one of the following:

•Select the correct value from the drop-down list.

•Start entering the correct value manually. The drop-down list will automatically close.

•Close the drop-down list by clicking on the data_checkin_close button at the top of it, the fx_reject_icon button in the Formula bar, or press Esc. Enter the correct value manually.

If the field is intended only for entering the value manually, the error is displayed without a drop-down list.

The table lists that are used when working with the drop-down list.

Action	Keyboard shortcut
Open the list	Option+↓
Select a value	↓ and ↑
Apply value	Enter
Select the first value of the list	Fn+←
Select the last value of the list	Fn+→
One screen down	Fn+↓
One screen up	Fn+↑
Close the list	Esc

The commands One screen down and One screen up are used to quickly view long drop-down lists. When executing commands, the list scrolls to the next or previous items.

Was this helpful?

Yes