How to display more than 12 entries in Calc 7►Validity►Selection list?

Summary

As user of Calc version 7, we need to display more than 12 entries in a cell with “Validity”. Which is using a “Selection list”. So that users can select an entry to their liking within a list of 100 entries. How?

Below is the same question as above. But with steps to reproduce, details, and attached spreadsheet.


Steps to Reproduce

  1. Using Calc 7, select any cell.
    For example, the cell B1 in this attached spreadsheet “validity—calc_7—revision_1.ods

  2. Navigate to “Data” menu —> “Validity…” option

  3. Click on “Criteria” horizontal tab

  4. Set “Allow” field to “Cell range

  5. Set the “Source” field to a range of 100 entries. For example one column with 100 rows.
    For example, the “Sheet2” in this attached spreadsheet “validity—calc_7—revision_1.ods

  6. Click on this cell you choose above. In this example B1. An handy selection menu is display.

  7. Notice that only the first 12 entries are included in the menu. This is the challenge.
    In this attached spreadsheet “validity—calc_7—revision_1.ods”, in “Sheet1”, cell B2 show this challenge.

  8. Expected result is that somehow users would be able to select other entries ranging from 13 to 100. For example, within the select menu, using a scroll bar, or using an autocomplete field, or anything else that would allow them to select any of the 100 entries. Within the “Assumptions” listed below.


Assumptions

  • Assumes that the resolution is stable when using large amount of grouped rows and columns

  • Assumes that the resolution is stable when doing large number of operations. Including adding rows, removing rows, moving rows.


What we tried that did not work

  • We searched the following documentation. But found no answer.

  • We tried an alternative at “Insert” menu —> “Form control” —> “List Box”. But this does not meet the users needs. Because this is very unstable. For example, When using a large amount of grouped rows and columns, when users are doing large number of operations, such as adding rows, removing rows, moving rows. In turn, the “List Box” somehow either loose its original anchor to a cell, or disappear.


Notice that only the first 12 entries
are included in the menu. This is the
challenge. In this attached
spreadsheet
“validity—calc_7—revision_1.ods”,
in “Sheet1”, cell B2 show this
challenge.

Expected result is that somehow users
would be able to select other entries
ranging from 13 to 100. For example,
within the select menu, using a scroll
bar, or using an autocomplete field,
or anything else that would allow them
to select any of the 100 entries.
Within the “Assumptions” listed below.

It is true, but you have a slider at the right side of the drop-down list, and you can select the larger numbers by usage of the slider.

Slider in the Data Validity drop-down list

Thanks @Zizi64 :slight_smile: This works and resolved this challenge.

It was a user error then.

Somehow when the dropdown menu is display this slider is not automatically display. I’m assuming that this is so that the interface remain clean and uncluttered. Make sense.

Today I learned that to display this slider, the user has to first open the menu, then do any one of the following actions to their liking:

  • Press and hold the down arrow
  • Use the mouse wheel down
  • Use the mouse, move over the invisible slider, then click on its handle to use scroll down

“Somehow when the dropdown menu is display this slider is not automatically display.”

What operating system and which version of the LO are you using??

The slider appears immediately for me on Windows in all of installed LO versions.

@Zizi64 :slight_smile: Debian 10. LO 7.0.4.2.


Below is the same answer as above. But with details if you’re interested in those.

Linux Debian 10 with code name Buster. Using GNOME 3.30.2 with its default Wayland option.

LO "Version Information:

  • Version: 7.0.4.2
  • Build ID: 00(Build:2)
  • CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: gtk3
  • Locale: en-CA (en_CA.UTF-8); UI: en-US
  • Debian package version: 1:7.0.4_rc2-1~bpo10+2
  • Calc: threaded