ListOK icon ListOK

Tags: Calc Education

last edited: 2021-04-07


Несколько функций Calc для обработки множеств

Some tricks


The extension adds to the Add-in category of the Function Wizard:

  • LST() Converts a text string to a normalized Set notation
  • LSTARR() Converts a text strings from cell range to a normalized Set
  • LSTAND() A ∪ B (union) - the Set of all things that are members of either A or B
  • LSTDEL() A\B (relative complement) - Set difference of A and B, Set of elements in A but not in B
  • LSTOR() A ∩ B (intersection) - the Set of all things that are members of both A and B
  • LSTCNT() |A| (cardinality) - the number of elements of the Set
  • LSTNOT() A′ (complement) - are the elements not in A
  • LSTIN() A ∈ B (subset) - the Set A is a subset of B (contained in B)
  • LSTHAL() Values of Set - horizontal array of Set elements
  • LSTVAL() Values of Set - vertical array of Set elements
  • LSTFMT() Formatted string - pad each display value of the Set with leading zeros to the specified length

The scope of use of functions is very wide. For example, check if the current time is included in a predefined list of hours

=IF(LSTIN(HOUR(NOW());"0-8, 13, 19-23");"Free time";"Working time")

Or quickly form a long array of even numbers {=LSTHAL("1-10")*2}

Or collect the values listed in the column into single string =LSTARR(C5:C18) - similar to =TEXTJOIN (", ";1;C5:C18), but it is also written shorter, and the result is usually a little more compact (for example, instead of "26, 19, 15, 14, 16, 2, 6, 12, 7, 17, 10, 28, 27, 11" the string will be "2, 6, 7, 10-12, 14-17, 19, 26-28" )

Or calculate something like =SORT(UNIQUE(A5:A25)) (for natural numbers) with {=LSTVAL(LSTARR(A5:A25))}

But the main purpose of these functions is to process lists of numbered objects. For example, the formation and verification of reports on the use of forms of insurance policies (to solve this problem, the first version of these algorithms was written)


Release List

Release: 2.4.1 2021-04-02 – Версия для Java

Compatibility: 3.3
Operating Systems: Linux, Windows, macOS
License: MPL

Пожалуйста, убедитесь, что Java установлена в вашей операционной системе и её использование разрешено в Сервис - Параметры - LibreOffice - Расширенные возможности - Параметры Java 

Исходные файлы проекта (*.java,*.idl,*.xcu) включены в JAR-файл внутри OXT

Other Extensions


Несколько функций Calc для обработки множеств



This extension helps to select a set of records from the table, the sum of the values ​​of which will be the specified number.



Find invalid formulas in a spreadsheet



Post your review

You cannot post reviews until you have logged in. Se connecter.


  • Roman Kuznetsov 6 avr. 2021 à 15:06 (Il y a 20 mois)

    Please change a language to English in (Sub)Title and in Release Notes description ;-)

    A great extension

RSS feed for reviews on this page | RSS feed for all reviews