Sorunuzu Sorun

Francewhoa isimli kullanıcının profili - etkinlik

2021-03-05 19:09:50 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

@Zizi64 :) Debian 10. LO 7.0.4.2. Below is the same answer as above. But with details if you're interested in those.

2021-03-05 19:08:45 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

@Zizi64 :) Debian 10. LO 7.0.4.2. Below is the same answer as above. But with details if you're interested in those.

2021-03-05 19:08:18 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

@Zizi64 :) Debian 10. LO 7.0.4.2. Below is the same answer as above. But with details if you're interested in those.

2021-03-05 19:07:46 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

@Zizi64 :) Debian 10. LO 7.0.4.2. Below is the same answer as above. But with details if you're interested in those.

2021-03-05 18:57:51 +0100 rozet alındı  Hayran
2021-03-05 07:19:00 +0100 rozet alındı  Popüler Soru (kaynak)
2021-03-04 19:34:12 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

Thanks @Zizi64 :) This works and resolved this challenge. It was a user error then. Somehow when the dropdown menu is

2021-03-04 19:33:59 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

Thanks @Zizi64 :) This works and resolved this challenge. It was a user error then. Somehow when the dropdown menu is

2021-03-04 19:33:52 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

Thanks @Zizi64 :) This works and resolved this challenge It was a user error then Somehow when the dropdown menu is di

2021-03-04 19:33:25 +0100 cevaba yorum yazıldı How to display more than 12 entries in Calc 7►Validity►Selection list?

Thanks @Zizi64 :) This works and resolved this challenge It was a user error then Somehow when the dropdown menu is di

2021-03-04 19:24:47 +0100 en iyi cevap olarak işaretlenmiş 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.


2021-03-04 19:24:47 +0100 rozet alındı  Alim (kaynak)
2021-03-04 18:33:40 +0100 soru düzeltilmiş How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in Calc►Validity►Selection list? Summary As user of Calc version 7, we need to disp

2021-03-04 18:32:36 +0100 soru düzeltilmiş How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in Calc►Validity►Selection list? Question As user of Calc version 7, we need to dis

2021-03-04 18:30:47 +0100 soru düzeltilmiş How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in "Validity"►"Selection list"? Question As user of Calc version 7, we need to disp

2021-03-04 18:28:37 +0100 soru düzeltilmiş How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in "Validity"►"Selection list"? Question As user of Calc version 7, we need to disp

2021-03-04 18:28:05 +0100 soru düzeltilmiş How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in "Validity"►"Selection list"? Calc 7 Question As user of Calc version 7, we need

2021-03-04 18:25:36 +0100 bir soru sordu How to display more than 12 entries in Calc 7►Validity►Selection list?

How to display more than 12 entries in "Validity"►"Selection list"? Calc 7 Question As user of Calc version 7, we need

2021-02-05 06:03:08 +0100 cevap düzeltilmiş Calc links open in browser twice

Same challenge here. Calc opens hyperlink twice in browser. To resolve this challenge, here are two resolution to choo

2021-02-05 06:00:49 +0100 bir soru cevapladı Calc links open in browser twice

Same challenge here. Calc opens hyperlink twice in browser. To resolve this challenge, here are two resolution to choo

2020-10-05 11:56:23 +0100 rozet alındı  Güzel Cevap (kaynak)
2020-10-05 05:32:45 +0100 rozet alındı  Ölü diriltici (kaynak)
2020-10-05 05:10:40 +0100 rozet alındı  Ölü diriltici (kaynak)
2020-10-04 06:59:17 +0100 cevap düzeltilmiş Looking for French tutorials

French tutorials: Videos: List of 130 videos at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7X

2020-10-04 06:51:38 +0100 cevap düzeltilmiş Looking for French tutorials

French tutorials: Videos: List of 130 videos at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7X

2020-10-04 06:51:00 +0100 cevap düzeltilmiş Looking for French tutorials

French tutorials: Videos: List of 130 videos at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7X

2020-10-04 06:49:09 +0100 cevap düzeltilmiş Looking for French tutorials

French tutorials: Videos: List of 130 video at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7Xk

2020-10-04 06:48:48 +0100 cevap düzeltilmiş Looking for French tutorials

French tutorials & documentation: 130 videos in French at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu

2020-10-04 06:44:22 +0100 cevap düzeltilmiş Looking for French tutorials

French documentation: 130 videos in French at https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7Xktk

2020-10-04 06:44:04 +0100 cevap düzeltilmiş Looking for French tutorials

French documentation: Video https://www.youtube.com/playlist?list=PL0pdzjvYW9RFl1ZRu8MkE3QxWQSt7Xktk Wiki homepage at

2020-10-04 06:41:49 +0100 bir soru cevapladı Looking for French tutorials

French wiki documentation: Homepage at https://wiki.documentfoundation.org/Documentation/fr User https://wiki.document

2020-10-04 06:32:59 +0100 cevap düzeltilmiş Libre office Cloud Hosted in France

Bonjour Yves :) The cloud version of LibreOffice is called "LibreOffice Online" The official wiki documentation about L

2020-10-04 06:24:42 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7 or more recent. Which support mult

2020-10-04 06:23:53 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 06:20:05 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 06:19:26 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 06:18:07 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 06:14:36 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 05:58:45 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Which support multi-threads. Ste

2020-10-04 05:56:26 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Steps to activate multi-threads

2020-10-04 05:55:29 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Steps to activate multi-threads

2020-10-04 05:53:56 +0100 cevap düzeltilmiş How can I make LibreOffice multi-threaded

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7. Starting with version 6, LibreO