sumtex sum as text SUMTEX - sum as text

Calc function to convert numbers to words (Russian, Ukrainian, Belarussian).

★ ★ ★ ★ ★
Calc Extensions
Download latest

latest release: 2024-03-18 19:07:16


Функция для преобразования чисел в числительные. Поддерживает русский, украинский, белорусский языки. Пример: SUMTEX(1234;"ягоды") даёт результат "одна тысяча двести тридцать четыре ягоды" на русской сборке, " одна тисяча двісті тридцять чотири ягоды " на украинской. Тот же результат можно получить на русской сборке, введя формулу =SUMTEX(1234;"ягоды"; ; ; ; ; ; ; ;"укр").

Release List

Release Description Compatibility Operating Systems License Release notes   0.6.9 Обновление для LibreOffice 4.0 и исправление 4.0 GPL Download 0.6.7 First on this site 3.3 GPL Download


★ ★ ★ ★ ★

Post your review

You cannot post reviews until you have logged in. Login Here.


  • Vaso Oct 26, 2020, 9:12 PM (4 years ago)

    ★ ★ ★ ★ ★

    Must have addon. I wonder why this solution or function (not only for the three languages of cause) are not implemented yet in Calc.

    This Extension has a bug — works only with Russian interface language.

    To fix it you should change language parameter in 7-th line of CalcAddins.xcu file from "ru" to "en".
    You can do it manually or use following quick solution (for linux OS):

    At first remove this extension if it is already installed. Restart LibreOffice and close it.
    Next steps (in terminal):
    export TDIR=`mktemp -d` && cd $TDIR
    unzip sumtex-0-6-9.oxt CalcAddins.xcu
    sed -i '7s/"ru"/"en"/' CalcAddins.xcu
    zip sumtex-0-6-9.oxt CalcAddins.xcu
    libreoffice sumtex-0-6-9.oxt

    That's all

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