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: 0.6.9 – Обновление для LibreOffice 4.0 и исправление

Compatibility: 4.0
Operating Systems:
License: GPL

Release: 0.6.7 – First on this site

Compatibility: 3.3
Operating Systems:
License: GPL

Feedback

Post your review

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

Reviews

  • Vaso Oct 26, 2020, 9:12 PM (9 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