sumtex sum as text SUMTEX - sum as text

Tags: Calc Extensions

Rating: ★ ★ ★ ★ ★

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

sumtex sum as text dad74ee5 bf17 40ec 8690 61249b9b252a

Description

Функция для преобразования чисел в числительные. Поддерживает русский, украинский, белорусский языки. Пример: 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

Feedback

★ ★ ★ ★ ★

Post your review

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

Reviews

  • Vaso Oct 26, 2020, 9:12 PM (3 months 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
    wget https://extensions.libreoffice.org/assets/downloads/z/sumtex-0-6-9.oxt
    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