Bug 128479 - New SpellNumber function
Summary: New SpellNumber function
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-30 14:11 UTC by Victor Krymskiy
Modified: 2019-10-30 22:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Victor Krymskiy 2019-10-30 14:11:27 UTC 
Description:
To create native SpellNumber function to convert numbers to words (like here: https://support.office.com/en-ie/article/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98)

Steps to Reproduce:
To create native SpellNumber function to convert numbers to words (like here: https://support.office.com/en-ie/article/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98)

Actual Results:
No such function

Expected Results:
SpellNumber function


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 m_a_riosv 2019-10-30 22:46:59 UTC 
The option is implemented, try
=TEXT(2;"[NatNum12 cardinal]0")

Look at the end of the page https://help.libreoffice.org/6.3/en-US/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514
Released notes for 6.1 https://wiki.documentfoundation.org/ReleaseNotes/6.1#New_.E2.80.9Cspell_out.E2.80.9D_NatNum_modifier