Bug 115007 - Add a number formatting option (for using in Format() BASIC function, and in Calc number format) to spell number, like in NUMBERTEXT extension
Summary: Add a number formatting option (for using in Format() BASIC function, and in ...
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Mike Kaganski
URL:
Whiteboard: target:6.1.0 target:6.2.0 target:6.1.0.1
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-14 20:32 UTC by Mike Kaganski
Modified: 2018-06-13 17:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Draft of ODF enhacement "number:transliteration-spellout" (6.18 KB, text/plain)
2018-06-05 13:33 UTC, László Németh
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2018-01-14 20:32:46 UTC
We have a great NUMBERTEXT extension by László Németh (https://extensions.libreoffice.org/extensions/numbertext-1; http://numbertext.org/) which allows to spell a number (works for many languages). However, it works with document language by default (not with cell language; it's natural that a function's result doesn't normally depend on its cell's formatting); it requires a separate column if one wants to continue using the number in calculations; it isn't available outside of Calc.

The proposal is to add a new formatting code to number formatter, which would spell its number. This would allow to use it in Basic; in Writer; allow to apply to numeric cells and continue using it in calculations; allow to depend on cell's language. The textual representation of a number is, actually, just a formatting.
Comment 1 Buovjaga 2018-01-31 17:36:45 UTC
OK -> NEW
Comment 2 Eike Rathke 2018-05-07 09:58:49 UTC
A dedicated format code only if there's an equivalent in Excel format codes to express such thing, which I doubt there is.

Apart from that, it probably would already be possible using the [NatNum#] mechanism and use a so far unallocated number to "spell out" in any language. This mechanism is already used.

See
offapi/com/sun/star/i18n/NativeNumberMode.idl
offapi/com/sun/star/i18n/XNativeNumberSupplier.idl
i18npool/source/defaultnumberingprovider/defaultnumberingprovider.cxx
Comment 3 Mike Kaganski 2018-05-13 00:14:52 UTC
https://gerrit.libreoffice.org/54186
Comment 4 Commit Notification 2018-05-15 09:43:41 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=56a7f308cf57f87d9e2cdeb77f48b570f81de85e

tdf#115007: add NatNum codes for cardinal/ordinal number names/indicators

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Commit Notification 2018-05-15 12:37:33 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=fb345397694258d87746879e4c530cc11c777843

Guard static variables, tdf#115007 tdf#117171 follow-up

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 László Németh 2018-06-05 13:33:50 UTC
Created attachment 142540 [details]
Draft of ODF enhacement "number:transliteration-spellout"
Comment 7 Commit Notification 2018-06-08 13:09:31 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=90d233b0311a208967a3e264820e00395bf057fb

tdf#115007: Use [NatNum12 params...] syntax

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 8 Commit Notification 2018-06-08 16:01:02 UTC
László Németh committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=32f1c56d8ff5e6f87dbcf086fd3743d6d36182bc

tdf#115007: add import/export to NatNum12 (spell out numbers,

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 9 Commit Notification 2018-06-11 11:06:22 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=807d4382cb021d2ac3ea99d6757a7b368a32941d

Derive NativeNumberXmlAttributes2 from NativeNumberXmlAttributes, tdf#115007 follow-up

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Commit Notification 2018-06-11 21:00:05 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "libreoffice-6-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=90385c35cc6bea312eedeea2de33529e76cd6f2a&h=libreoffice-6-1

tdf#115007: Use [NatNum12 params...] syntax

It will be available in 6.1.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 11 Commit Notification 2018-06-11 21:00:13 UTC
László Németh committed a patch related to this issue.
It has been pushed to "libreoffice-6-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=ecad621f6889e8af23baa4faee62d10f580ec074&h=libreoffice-6-1

tdf#115007: add import/export to NatNum12 (spell out numbers,

It will be available in 6.1.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Commit Notification 2018-06-11 21:00:20 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-6-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=e2a39848fa11dfc082ca9142266cbfe8adb586f2&h=libreoffice-6-1

Derive NativeNumberXmlAttributes2 from NativeNumberXmlAttributes, tdf#115007 follow-up

It will be available in 6.1.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 13 Commit Notification 2018-06-13 17:50:45 UTC
László Németh committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=958c23246a3606f2cb33ad5c136127f951bbbc69

tdf#115007 NatNum12 "spell out" formats in dates

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.