SUMTEX - sum as text

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

★ ★ ★ ★ ★

Calc Extensions

latest release: 2024-02-05 06:20:25

Description

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

Release	Description	Compatibility	Operating Systems	License	Release notes	Updated
0.6.7	First on this site	3.3		GPL		2020-03-05 23:13:35	Download
0.6.9	Обновление для LibreOffice 4.0 и исправление	4.0		GPL		2020-03-05 23:13:35	Download

Feedback

★ ★ ★ ★ ★

Post your review

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

Reviews

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
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